[
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 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}
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
{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}
> 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 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)
