[FLINK-31066] Release Testing: Verify FLINK-29932 Upgrade Calcite to 1.29.0

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Tests
• Labels: release-testing
• Assignee: Matthias Pohl
• Reporter: Sergey Nuyanzin
• Created: 14/Feb/23 13:57
• Updated: 27/Feb/23 11:04
• Resolved: 27/Feb/23 09:59

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 

SELECT a FROM MyTable WHERE a = 1 or a = 2 or a IS NOT NULL;

SELECT a FROM MyTable WHERE a = 1 or a = 2 or a IS NULL;

where MyTable is for instance

CREATE TABLE MyTable (
   a bigint,
   b int not null,
   c varchar,
   d timestamp(3)
) with (...) 

Issue Links

• is related to: FLINK-20873 Upgrade Calcite version to 1.27
• is related to: FLINK-21239 Upgrade Calcite version to 1.28
• is related to: FLINK-29932 Upgrade Calcite version to 1.29.0
• Testing discovered: FLINK-31093 NullpointerException when restoring a FlinkSQL job from a savepoint
• Testing discovered: FLINK-31143 Invalid request: offset doesn't match when restarting from a savepoint
• Testing discovered: FLINK-31084 DataGen sequence generator requires the definition of start/end values