[ 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)