system.numbers

This table contains a single UInt64 column named number that contains almost all the natural numbers starting from zero.

You can use this table for tests, or if you need to do a brute force search.

Reads from this table are not parallelized.

Example

  1. :) SELECT * FROM system.numbers LIMIT 10;
  1. ┌─number─┐
  2. │      0 │
  3. │      1 │
  4. │      2 │
  5. │      3 │
  6. │      4 │
  7. │      5 │
  8. │      6 │
  9. │      7 │
  10. │      8 │
  11. │      9 │
  12. └────────┘
  14. 10 rows in set. Elapsed: 0.001 sec.

Original article