Syntax

    1. mysql> set enable_vectorized_engine=true;
    3. mysql> select k1,k2,k3 from collect_test order by k1;
    4. | k1   | k2         | k3    |
    5. +------+------------+-------+
    7. |    2 | 2022-07-04 | NULL  |
    8. |    2 | 2022-07-04 | hello |
    9. |    3 | NULL       | world |
    10. |    3 | NULL       | world |
    11. +------+------------+-------+
    13. +------+--------------------------+--------------------+
    14. | k1   | collect_list(`k2`)       | collect_list(`k3`) |
    15. +------+--------------------------+--------------------+
    16. |    1 | [2022-07-05]             | [hello]            |
    17. |    2 | [2022-07-04, 2022-07-04] | [hello]            |
    18. |    3 | NULL                     | [world, world]     |