struct()

SinceVersion 2.0.0

struct()

description

Syntax

STRUCT<T1, T2, T3, ...> struct(T1, T2, T3, ...)

construct an struct with variadic elements and return it, Tn could be column or literal

notice

Only supported in vectorized engine

example

1. mysql> select struct(1, 'a', "abc");
2. +-----------------------+
3. | struct(1, 'a', 'abc') |
4. +-----------------------+
5. | {1, 'a', 'abc'}       |
6. +-----------------------+
7. 1 row in set (0.03 sec)

9. mysql> select struct(null, 1, null);
10. +-----------------------+
11. | struct(NULL, 1, NULL) |
12. +-----------------------+
13. | {NULL, 1, NULL}       |
14. +-----------------------+
15. 1 row in set (0.02 sec)

17. mysql> select struct(cast('2023-03-16' as datetime));
18. +----------------------------------------+
19. | struct(CAST('2023-03-16' AS DATETIME)) |
20. +----------------------------------------+
21. | {2023-03-16 00:00:00}                  |
22. +----------------------------------------+
23. 1 row in set (0.01 sec)

25. mysql> select struct(k1, k2, null) from test_tb;
26. +--------------------------+
27. | struct(`k1`, `k2`, NULL) |
28. +--------------------------+
29. | {1, 'a', NULL}           |
30. +--------------------------+
31. 1 row in set (0.04 sec)

keywords

STRUCT,CONSTRUCTOR