[CALCITE-1668] Simplify "1 = 1" to true, "1 > 2" to false

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Kevin Risden
• Created: 02/Mar/17 20:34
• Updated: 24/Mar/17 03:20
• Resolved: 04/Mar/17 21:12

Description

The RexUtil.simplify method should handle literal comparison simplification. From an email on the calcite-dev mailing list:

Calcite doesn't seem to optimize away the literal comparison literal case
with RexUtil.simplify. In my understanding any literal comparison literal
results in a simple TRUE/FALSE result.

I'm not sure this is valid in the general case, but I put together a simple
example of doing this on the RexUtil simplifyCall.

https://github.com/apache/calcite/pull/376

Issue Links

• relates to: CALCITE-1638 Simplify $x=$x to true