[
https://issues.apache.org/jira/browse/FLINK-31066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Nuyanzin updated FLINK-31066:
------------------------------------
Description:
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
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}
where MyTable is for instance
{code:sql}
CREATE TABLE MyTable (
a bigint,
b int not null,
c varchar,
d timestamp(3)
) with (...)
{code}
was:
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
SQL jobs with Sarg related queries could be restored from previous Flink
version.
An example of SQL
{noformat:sql}
SELECT a FROM MyTable WHERE a = 1 or a = 2 or a IS NOT NULL
{noformat}
where MyTable is for instance
{noformat:sql}
CREATE TABLE MyTable (
a bigint,
b int not null,
c varchar,
d timestamp(3)
) with (...)
{noformat}
> 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
> 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
> 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}
> 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)
