[
https://issues.apache.org/jira/browse/CALCITE-7069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17985740#comment-17985740
]
ZheHu commented on CALCITE-7069:
--------------------------------
I don't follow, if MysqlSqlDialect can convert CAST(1 as BIGINT UNSIGNED) to
CAST(1 as UNSIGNED), the result should be right.
> 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)
