[ https://issues.apache.org/jira/browse/FLINK-31066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17693216#comment-17693216 ]
Matthias Pohl commented on FLINK-31066: --------------------------------------- I ran the sample code (once compiled with Flink release-1.16 and once compiled with release-1.17) on a Flink cluster based on the binaries of 1.16.1 and 1.17-SNAPSHOT (commit 21158c06) The only config changed I added was the following one: {code} state.backend: hashmap state.backend.type: filesystem {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 > Assignee: Matthias Pohl > Priority: Major > Labels: release-testing > Attachments: SavepointReleaseTesting.java > > > 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)