[CALCITE-613] Implicitly convert character values in comparisons

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0-incubating
• Assignee: Julian Hyde
• Reporter: Sean Hsuan-Yi Chu
• Created: 09/Mar/15 22:40
• Updated: 01/Mar/21 04:10
• Resolved: 03/Apr/15 13:14

Description

In relational DB such as Postgres, this query works fine.
"select ... from ... where column (INT type) between '10' and '11'"

Calcite blocks this query early by the fact that data types "char" & "integer" are not directly compatible. However, this is very common for people to filter columns with date types. For example,

"...where date between '1911-01-01' and '1911-01-02' "

To relax this type check when comparing with literals can help improve usability.

Issue Links

• is duplicated by: CALCITE-17 support string date/time literals to DATE/TIMESTAMP automatically
• relates to: CALCITE-2032 Error when implicitly converting character literal to date literal