Syntax

    1. mysql> set enable_vectorized_engine=true;
    2. mysql> select k1, k2, array_sort(k2) array_test;
    3. +------+-----------------------------+-----------------------------+
    4. | k1   | k2                          | array_sort(`k2`)            |
    5. +------+-----------------------------+-----------------------------+
    6. |  2   | [6, 7, 8]                   | [6, 7, 8]                   |
    7. |  3   | []                          | []                          |
    8. |  4   | NULL                        | NULL                        |
    10. |  6   | [1, 2, 3, NULL]             | [NULL, 1, 2, 3]             |
    11. |  7   | [1, 2, 3, NULL, NULL]       | [NULL, NULL, 1, 2, 3]       |
    12. |  8   | [1, 1, 2, NULL, NULL]       | [NULL, NULL, 1, 1, 2]       |
    13. |  9   | [1, NULL, 1, 2, NULL, NULL] | [NULL, NULL, NULL, 1, 1, 2] |
    14. +------+-----------------------------+-----------------------------+
    16. +------+------------------------------------------+------------------------------------------+
    17. | k1   | k2                                       | array_sort(`k2`)                         |
    19. |  1   | ['a', 'b', 'c', 'd', 'e']                | ['a', 'b', 'c', 'd', 'e']                |
    20. |  2   | ['f', 'g', 'h']                          | ['f', 'g', 'h']                          |
    21. |  3   | ['']                                     | ['']                                     |
    22. |  3   | [NULL]                                   | [NULL]                                   |
    23. |  5   | ['a', 'b', 'c', 'd', 'e', 'a', 'b', 'c'] | ['a', 'a', 'b', 'b', 'c', 'c', 'd', 'e'] |
    24. |  6   | NULL                                     | NULL                                     |
    25. |  7   | ['a', 'b', NULL]                         | [NULL, 'a', 'b']                         |
    26. +------+------------------------------------------+------------------------------------------+