array_range

SinceVersion 1.2.0

array_range

description

Syntax

  1. ARRAY<Int> array_range(Int end)
  2. ARRAY<Int> array_range(Int start, Int end)
  3. ARRAY<Int> array_range(Int start, Int end, Int step)

The parameters are all positive integers. start default value is 0, and step default value is 1. Return the array which numbers from start to end - 1 by step.

notice

Only supported in vectorized engine

example

  1. mysql> set enable_vectorized_engine=true;
  3. mysql> select array_range(10);
  4. +--------------------------------+
  5. | array_range(10)                |
  6. +--------------------------------+
  7. | [0, 1, 2, 3, 4, 5, 6, 7, 8, 9] |
  8. +--------------------------------+
  10. mysql> select array_range(10,20);
  11. +------------------------------------------+
  12. | array_range(10, 20)                      |
  13. +------------------------------------------+
  14. | [10, 11, 12, 13, 14, 15, 16, 17, 18, 19] |
  15. +------------------------------------------+
  17. mysql> select array_range(0,20,2);
  18. +-------------------------------------+
  19. | array_range(0, 20, 2)               |
  20. +-------------------------------------+
  21. | [0, 2, 4, 6, 8, 10, 12, 14, 16, 18] |
  22. +-------------------------------------+

keywords

ARRAY, RANGE, ARRAY_RANGE