You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Vineet Garg (Jira)" <ji...@apache.org> on 2020/01/14 17:15:00 UTC
[jira] [Created] (CALCITE-3733) MySQL JDBC rewrite should rewrite
CAST as TIMESTAMP to CAST as DATETIME
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)