[
https://issues.apache.org/jira/browse/CALCITE-2719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16706490#comment-16706490
]
Piotr Bojko commented on CALCITE-2719:
--------------------------------------
Here is a pull - https://github.com/apache/calcite/pull/953
I've come to conclusion that CAST to INTEGER which is already customized in
MySQL should be converted to CAST to SIGNED in MySQL, same as for this case.
However - now conversion (for INTEGER) goes to UNSIGNED. History for the
MySqlDialect tells nothing about that.
Should we also change CAST to INTEGER ?
> MySQL does not support cast to bigint type
> ------------------------------------------
>
> Key: CALCITE-2719
> URL: https://issues.apache.org/jira/browse/CALCITE-2719
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.17.0
> Reporter: Piotr Bojko
> Assignee: Julian Hyde
> Priority: Major
>
> Cast to BIGING is not supported in MySQL. The trick is to use CAST to
> UNSIGNED INT.
> When accepted I will try to fix this.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
