Sergey Nuyanzin created FLINK-31066:
---------------------------------------
Summary: 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
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
SELECT a FROM MyTable WHERE a = 1 or a = 2 or a IS NOT NULL
where MyTable is for instance
```
CREATE TABLE MyTable (
a bigint,
b int not null,
c varchar,
d timestamp(3)
) with (...)
```
--
This message was sent by Atlassian Jira
(v8.20.10#820010)