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

Posted to issues@calcite.apache.org by "Feng Zhu (Jira)" <ji...@apache.org> on 2020/04/14 02:24:00 UTC

[jira] [Commented] (CALCITE-3733) In JDBC adapter, when generating SQL for MYSQL, generate TIMESTAMP type as DATETIME for CAST

    [ https://issues.apache.org/jira/browse/CALCITE-3733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082792#comment-17082792 ] 

Feng Zhu commented on CALCITE-3733:
-----------------------------------

Fixed in [https://github.com/apache/calcite/commit/9262d8d250eebfe126b07863ba89b1d4e6ec6219], thanks for your PR [~vgarg] !

> In JDBC adapter, when generating SQL for MYSQL, generate TIMESTAMP type as DATETIME for CAST
> --------------------------------------------------------------------------------------------
>
>                 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
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> 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)