[
https://issues.apache.org/jira/browse/CALCITE-7069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17985741#comment-17985741
]
Mihai Budiu commented on CALCITE-7069:
--------------------------------------
I think MySQL will reject the specific program you wrote.
If I am right, there is simply no way to cast something to BIGINT UNSIGNED.
The only way you can create such values is by arithmetic with other existing
BIGINT UNSIGNED, which in the end must come from some tables.
> Invalid unparse for INT UNSIGNED and BIGINT UNSIGNED in MysqlSqlDialect
> ------------------------------------------------------------------------
>
> Key: CALCITE-7069
> URL: https://issues.apache.org/jira/browse/CALCITE-7069
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.40.0
> Reporter: ZheHu
> Assignee: ZheHu
> Priority: Minor
>
> After CALCITE-1466, we support UNSIGNED INT and UNSIGNED BITINT types,
> however, in MySQL, cast(1 as INT UNSIGNED) or cast(1 as BIGINT UNSIGNED) is
> not legal, we should convert it to forms like cast(1 as UNSIGNED).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
