v.22.12New Feature

Support Numeric Literals with Underscore Separators

Official CH changelog text
Support numeric literals with _ as the separator, for example, 1_000_000. #43925 (jh0x).
Support numeric literals with underscores as separators in SQL queries, allowing numbers like 1_000_000 for improved readability.

Why it matters

Underscore separators in numeric literals enhance code clarity and maintainability by making large numbers easier to read and understand within SQL statements.

How to use it

Users can directly use underscores as digit separators in numeric literals when writing SQL queries, for example: SELECT 1_000_000 AS million.

Related resources

PreviousNext