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

["Flink Jira Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-32188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Flink Jira Bot updated FLINK-32188:
-----------------------------------
    Labels: pull-request-available stale-major  (was: pull-request-available)

I am the [Flink Jira Bot|https://github.com/apache/flink-jira-bot/] and I help the community manage its development. I see this issues has been marked as Major but is unassigned and neither itself nor its Sub-Tasks have been updated for 60 days. I have gone ahead and added a "stale-major" to the issue". If this ticket is a Major, please either assign yourself or give an update. Afterwards, please remove the label or in 7 days the issue will be deprioritized.


> Support to "where" query with a fixed-value array and simplify condition for an array-type filed.
> -------------------------------------------------------------------------------------------------
>
>                 Key: FLINK-32188
>                 URL: https://issues.apache.org/jira/browse/FLINK-32188
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Planner
>    Affects Versions: 1.12.2, 1.17.0, 1.16.1
>            Reporter: Xin Chen
>            Priority: Major
>              Labels: pull-request-available, stale-major
>         Attachments: image-2023-05-25-17-16-02-288.png, image-2023-05-25-20-44-08-834.png, image-2023-05-25-20-44-47-581.png, image-2023-06-06-16-50-10-805.png, image-2023-06-06-16-50-54-467.png, screenshot-1.png, screenshot-10.png, screenshot-11.png, screenshot-12.png, screenshot-2.png, screenshot-3.png, screenshot-4.png, screenshot-5.png, screenshot-6.png, screenshot-7.png, screenshot-8.png, screenshot-9.png
>
>
> 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"？



--
This message was sent by Atlassian Jira
(v8.20.10#820010)