You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/03/09 23:40:38 UTC

[jira] [Created] (CALCITE-613) Literals need to be treated more flexible

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)