[FLINK-35423] ARRAY_EXCEPT should support set semantics

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.20.0
• Fix Version/s: 1.20.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Sergey Nuyanzin
• Reporter: Sergey Nuyanzin
• Created: 22/May/24 14:58
• Updated: 07/Jun/24 09:14
• Resolved: 07/Jun/24 09:14

Description

After a number of discussions e.g. here [1]
It was decided to follow set semantics for ARRAY_EXCEPT and ARRAY_INTERSECT.

It is marked as a blocker since ARRAY_EXCEPT was added in 1.20 only and has not been released yet, so the change should be done before 1.20.0 release to avoid inconsistencies.

[1] https://github.com/apache/flink/pull/24526

Issue Links

• is related to: FLINK-31663 Add ARRAY_EXCEPT supported in SQL & Table API
• links to: GitHub Pull Request #24828
• mentioned in: Page Loading...