[ https://issues.apache.org/jira/browse/CALCITE-2719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16706859#comment-16706859 ]
Piotr Bojko commented on CALCITE-2719: -------------------------------------- [~julianhyde] I am afraid MySQL - as far I have read the docs - does not support any casting to explicite 32 bit integer. I would go with CAST to SIGNED for INTEGER - this would be still a step further from current. The I would log to issues: # CAST to INTEGER when pushed to MySQL can produce overflow (bug, now it is similar but with signed/unsigned values) # Escaping to alien built in data types is based on hardcoding uderscore in an identifier (bug/improvement) > 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 SIGNED > INT. > When accepted I will try to fix this. -- This message was sent by Atlassian JIRA (v7.6.3#76005)