[CALCITE-6423] Invalid unparse for CHAR without precision in MySQLDialect

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.37.0
• Fix Version/s: 1.38.0
• Labels: pull-request-available
• Assignee: xiong duan
• Reporter: xiong duan
• Created: 28/May/24 11:04
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

As code review comment in https://github.com/apache/calcite/pull/3799.

Execute SQL :

select cast(product_id as char) from product

Expected MySQL SQL should be:

select cast(product_id as char) from product

But is:

select cast(product_id as char(1)) from product

Issue Links

• links to: GitHub Pull Request #3804