[
https://issues.apache.org/jira/browse/CALCITE-2719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16706859#comment-16706859
]
Piotr Bojko edited comment on CALCITE-2719 at 12/3/18 9:16 AM:
---------------------------------------------------------------
[~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 implementation.
Then I would log following 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)
was (Author: ptrbojko):
[~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 implementation.
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)
