Sean Hsuan-Yi Chu created CALCITE-613:
-----------------------------------------
Summary: Literals need to be treated more flexible
Key: CALCITE-613
URL: https://issues.apache.org/jira/browse/CALCITE-613
Project: Calcite
Issue Type: Bug
Reporter: Sean Hsuan-Yi Chu
Assignee: Julian Hyde
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
