array_pushback

SinceVersion 2.0

array_pushback

description

Syntax

Array<T> array_pushback(Array<T> arr, T value)

Add the value to the end of the array.

Returned value

The array after adding the value.

Type: Array.

notice

Only supported in vectorized engine

example

1. mysql> select array_pushback([1, 2], 3);
2. +---------------------------------+
3. | array_pushback(ARRAY(1, 2), 3)  |
4. +---------------------------------+
5. | [1, 2, 3]                       |
6. +---------------------------------+

8. mysql> select col3, array_pushback(col3, 6) from array_test;
9. +-----------+----------------------------+
10. | col3      | array_pushback(`col3`, 6)  |
11. +-----------+----------------------------+
12. | [3, 4, 5] | [3, 4, 5, 6]               |
13. | [NULL]    | [NULL, 6]                  |
14. | NULL      | NULL                       |
15. | []        | [6]                        |
16. +-----------+----------------------------+

18. mysql> select col1, col3, array_pushback(col3, col1) from array_test;
19. +------+-----------+---------------------------------+
20. | col1 | col3      | array_pushback(`col3`, `col1`)  |
21. +------+-----------+---------------------------------+
22. |    0 | [3, 4, 5] | [3, 4, 5, 0]                    |
23. |    1 | [NULL]    | [NULL, 1]                       |
24. |    2 | NULL      | NULL                            |
25. |    3 | []        | [3]                             |
26. +------+-----------+---------------------------------+

keywords

ARRAY,PUSHBACK,ARRAY_PUSHBACK