[FLINK-32188] Support to "where" query with a fixed-value array and simplify condition for an array-type filed.

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.12.2, 1.17.0, 1.16.1
• Component/s: Table SQL / Planner
• Labels: auto-deprioritized-major pull-request-available
• Assignee: Unassigned
• Reporter: Xin Chen
• Created: 25/May/23 08:57
• Updated: 18/Aug/23 22:35

Description

When I customized a data source connector which assumed as image-connector, I met issues while creating a table with ddl to specify a field "URL" as an array type. When submitting an SQL task with Flink, I specified query of this field with a fixed array. For example, "select * from image source where URL=ARRAY ['/flink. jpg', '/flink_1. jpg']", but it couldn't obtain the corresponding predicate filters at all.

Does the custom connector not support to query fields of array type with "where"？

Issue Links

• links to: GitHub Pull Request #22719