[
https://issues.apache.org/jira/browse/CALCITE-2719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16706511#comment-16706511
]
Julian Hyde commented on CALCITE-2719:
--------------------------------------
I'm thoroughly surprised that MySQL has a BIGINT type but does not allow
CAST(... AS BIGINT). But it's MySQL, so nothing is surprising. :)
I confirmed on rextester.com that {{select cast('-9876543210' as signed)}} does
the right thing and produces a 64 bit signed integer value (what the SQL
standard calls BIGINT).
Do your best to find something that works for 32 bit signed integer (what the
SQL standard calls INTEGER).
I would like to get this into 1.18. Can you get it done by end of tomorrow
Monday, for the code freeze?
> 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)
