[CALCITE-1178] Allow SqlBetweenOperator to compare DATE and TIMESTAMP

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Sean Hsuan-Yi Chu
• Created: 30/Mar/16 03:36
• Updated: 06/Mar/20 07:36
• Resolved: 23/Sep/19 09:55

Description

An expression such as

date '1999-03-02' between date '1999-03-01' and timestamp '1999-03-03 00:00:00.0'

will incur SqlValidatorException since SqlBetweenOperator does not allow DATE and TIMESTAMP comparison. In terms of usability, it would be great if this type of comparison is allowed in Calcite.

Issue Links

• links to: GitHub Pull Request #1470