arrays_overlap

    Syntax

    判断left和right数组中是否包含公共元素。返回结果如下:

    1. +--------------+-----------+-------------------------------------+
    2. | c_left | c_right | arrays_overlap(`c_left`, `c_right`) |
    3. +--------------+-----------+-------------------------------------+
    4. | [1, 2, 3] | [5, 6] | 0 |
    5. | [1, 2, NULL] | [1] | NULL |
    6. | NULL | [1, 2] | NULL |
    7. +--------------+-----------+-------------------------------------+

    ARRAY,ARRAYS,OVERLAP,ARRAYS_OVERLAP