v.25.10Improvement
Now the function generateSerialID supports a non-constant
Now the function generateSerialID supports a non-constant argument with the series name. Closes #83750. #88270 (Alexey Milovidov).Why it matters
This feature addresses the limitation wheregenerateSerialID required a constant series name. By allowing a non-constant argument, it enables generating serial IDs dynamically based on varying series names, providing greater flexibility in distributed unique ID generation scenarios.How to use it
You can pass a non-constant expression, such as a column reference or a more complex expression, as the series name argument togenerateSerialID. For example:SELECT generateSerialID(user_id) FROM users;This allows each row to generate a unique serial ID within its own series dynamically.