[jira] [Created] (CALCITE-3733) MySQL JDBC rewrite should rewrite CAST as TIMESTAMP to CAST as DATETIME

[Vineet Garg (Jira)]

Vineet Garg created CALCITE-3733:
------------------------------------

             Summary: MySQL JDBC rewrite should rewrite CAST as TIMESTAMP to 
CAST as DATETIME
                 Key: CALCITE-3733
                 URL: https://issues.apache.org/jira/browse/CALCITE-3733
             Project: Calcite
          Issue Type: Bug
          Components: jdbc-adapter
            Reporter: Vineet Garg
            Assignee: Vineet Garg


Queries containing cast timestamp literal is rewritten into cast as TIMESTAMP. 
This syntax is not supported with MySql. Since TIMESTAMP is equivalent to 
DATETIME it should be rewritten into CAST as DATETIME.

I will provide a test case later.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)