[CALCITE-1435] Wrong comparison of TIMESTAMP literals

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: core
• Assignee: Unassigned
• Reporter: Timo Walther
• Created: 13/Oct/16 12:18
• Updated: 22/Feb/19 01:22

Description

The following expression always returns true when using ProjectToCalcRule which is invalid:

TIMESTAMP '2011-01-01 00:00:00.001' >= TIMESTAMP '2011-01-01 00:00:00.005'

The reason for this is that a wrong RexProgram is built since RexUtil#makeKey returns the same key for both timestamps. Both timestamps, however, have the same digest (fractional seconds are missing).