[
https://issues.apache.org/jira/browse/CALCITE-6423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xiong duan updated CALCITE-6423:
--------------------------------
Description:
As code review comment in [https://github.com/apache/calcite/pull/3799.]
Execute SQL :
{code:java}
select cast(product_id as char) from product{code}
Expected MySQL SQL should be:
{code:java}
select cast(product_id as char) from product{code}
But is:
{code:java}
select cast(product_id as char(1)) from product{code}
was:
As code review comment in [https://github.com/apache/calcite/pull/3799.]
Execute SQL :
{code:java}
select cast(product_id as char) from product{code}
Exppected MySQL SQL should be:
{code:java}
select cast(product_id as char) from product{code}
But is:
{code:java}
select cast(product_id as char(1)) from product{code}
> Invalid unparse for CHAR without precision in MySQLDialect
> ----------------------------------------------------------
>
> Key: CALCITE-6423
> URL: https://issues.apache.org/jira/browse/CALCITE-6423
> Project: Calcite
> Issue Type: Improvement
> Affects Versions: 1.37.0
> Reporter: xiong duan
> Assignee: xiong duan
> Priority: Minor
> Fix For: 1.38.0
>
>
> As code review comment in [https://github.com/apache/calcite/pull/3799.]
> Execute SQL :
> {code:java}
> select cast(product_id as char) from product{code}
> Expected MySQL SQL should be:
> {code:java}
> select cast(product_id as char) from product{code}
> But is:
> {code:java}
> select cast(product_id as char(1)) from product{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
