arrays_overlap

SinceVersion 1.2.0

arrays_overlap

description

Syntax

BOOLEAN arrays_overlap(ARRAY<T> left, ARRAY<T> right)

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

1. 1    - left和right数组存在公共元素；
2. 0    - left和right数组不存在公共元素；
3. NULL - left或者right数组为NULL；或者left和right数组中，任意元素为NULL；

notice

仅支持向量化引擎中使用

example

1. mysql> set enable_vectorized_engine=true;

3. mysql> select c_left,c_right,arrays_overlap(c_left,c_right) from array_test;
4. +--------------+-----------+-------------------------------------+
5. | c_left       | c_right   | arrays_overlap(`c_left`, `c_right`) |
6. +--------------+-----------+-------------------------------------+
7. | [1, 2, 3]    | [3, 4, 5] |                                   1 |
8. | [1, 2, 3]    | [5, 6]    |                                   0 |
9. | [1, 2, NULL] | [1]       |                                NULL |
10. | NULL         | [1, 2]    |                                NULL |
11. | [1, 2, 3]    | [1, 2]    |                                   1 |
12. +--------------+-----------+-------------------------------------+

keywords

ARRAY,ARRAYS,OVERLAP,ARRAYS_OVERLAP