[jira] [Assigned] (FLINK-31066) Release Testing: Verify FLINK-29932 Upgrade Calcite to 1.29.0

["Matthias Pohl (Jira)" <ji...@apache.org>]

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

Matthias Pohl reassigned FLINK-31066:
-------------------------------------

    Assignee: Matthias Pohl

> Release Testing: Verify FLINK-29932 Upgrade Calcite to 1.29.0
> -------------------------------------------------------------
>
>                 Key: FLINK-31066
>                 URL: https://issues.apache.org/jira/browse/FLINK-31066
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Tests
>            Reporter: Sergey Nuyanzin
>            Assignee: Matthias Pohl
>            Priority: Major
>              Labels: release-testing
>
> In fact this is a task to check all 3 Calcite upgrade related issues (1.27.0, 1.28.0 and 1.29.0)
> Since there were added optimization for Sarg in Calcite 1.27.0 it would make sense to check that different queries with Sarg operator are working ok.
> Also would make sense to check that SQL jobs with Sarg related queries could be restored from previous Flink version.
> An example of SQL 
> {code:sql}
> SELECT a FROM MyTable WHERE a = 1 or a = 2 or a IS NOT NULL;{code}
> {code:sql}
> SELECT a FROM MyTable WHERE a = 1 or a = 2 or a IS NULL;
> {code}
> where MyTable is for instance
> {code:sql}
> CREATE TABLE MyTable (
>    a bigint,
>    b int not null,
>    c varchar,
>    d timestamp(3)
> ) with (...) 
> {code}



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