system.numbers_mt

The same as system.numbers but reads are parallelized. The numbers can be returned in any order.

Used for tests.

Example

  1. :) SELECT * FROM system.numbers_mt 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