Open Weijun-H opened 6 months ago
It seems that the functions array_union and array_intersect are unable to process columnar data that contains NULL values. These NULL values are being overlooked in the process.
array_union
array_intersect
❯ CREATE TABLE array_intersect_table AS VALUES ([1, 2, 2, 3], [2, 3, 4]), ([2, 3, 3], [3]), ([3], [3, 3, 4]), (null, [3, 4]), ([1, 2], null), (null, null) ; 0 rows in set. Query took 0.013 seconds. ❯ select array_intersect(column1, column2) from array_intersect_table; +------------------------------------------------------------------------+ | array_intersect(array_intersect_table.column1,array_except_table.column2) | +------------------------------------------------------------------------+ | [2, 3] | | [3] | | [3] | +------------------------------------------------------------------------+ 3 rows in set. Query took 0.007 seconds.
No response
take
Describe the bug
It seems that the functions
array_union
andarray_intersect
are unable to process columnar data that contains NULL values. These NULL values are being overlooked in the process.To Reproduce
Expected behavior
No response
Additional context
No response