v.24.4Improvement

SELECT * FROM numbers() Works Like SELECT * FROM system.numbers

Official CH changelog text
For convenience purpose, SELECT * FROM numbers() will work in the same way as SELECT * FROM system.numbers - without a limit. #61969 (YenchangChan).
The numbers() table function now behaves like system.numbers and returns an infinite sequence of numbers without requiring a LIMIT clause.

Why it matters

Previously, SELECT * FROM numbers() required a LIMIT clause to avoid infinite results. This feature aligns numbers() with system.numbers by allowing queries without specifying a LIMIT, improving usability and convenience for users generating sequences.

How to use it

Users can simply use SELECT * FROM numbers() without specifying a LIMIT. This query will now return an infinite sequence of numbers, just like SELECT * FROM system.numbers.

Related resources

PreviousNext