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).
The generateSerialID function now supports a non-constant argument for the series name, allowing dynamic series naming during ID generation.

Why it matters

This feature addresses the limitation where generateSerialID 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 to generateSerialID. For example:

SELECT generateSerialID(user_id) FROM users;

This allows each row to generate a unique serial ID within its own series dynamically.