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.
- links to