For operations involving the date datatype, when one of the operands is a DATE literal without a cast, query fails.
The following query fails to validate:
Query failed: SqlValidatorException: Cannot apply 'BETWEEN' to arguments of type '<ANY> BETWEEN <CHAR(9)> AND <DATE>'. Supported form(s): '<COMPARABLE_TYPE> BETWEEN <COMPARABLE_TYPE> AND <COMPARABLE_TYPE>'
The following query executes fine:
Both the queries execute fine on postgres