[CALCITE-5891] Create a test fixture that would apply PROJECT_REDUCE_EXPRESSIONS to all tests in SqlOperatorTest

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.35.0
• Component/s: core
• Assignee: Mihai Budiu
• Reporter: Mihai Budiu
• Created: 02/Aug/23 19:29
• Updated: 16/Oct/23 20:58

Description

SqlOperatorTest has many tests, including end-to-end tests.

However, none of these tests exercise the PROJECT_REDUCE_EXPRESSION rules, which often produce different results than these tests for constant expressions.

Ideally we should be able to subclass SqlOperatorTest and use a fixture that also applies this optimization prior to evaluation.

I have marked this as a major priority, because I suspect it would catch many bugs with minimal effort. (I have found at least 10 so far.)

Issue Links

• relates to: CALCITE-6000 There should be a SqlParserFixture which parses again after unparsing