[CALCITE-4014] calcite convert(column using utf8mb4) throws exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.21.0
• Fix Version/s: 1.24.0
• Component/s: core
• Assignee: Unassigned
• Reporter: groobyming
• Created: 19/May/20 10:28
• Updated: 28/May/21 13:12
• Resolved: 26/May/20 23:21

Description

    Hello everyone, I found that when performing the following sql verification, I will be prompted that the UTF8MB4 field cannot be found in the table, but after reading the source code calcite is built-in to support this convert function, is it not fully implemented yet?

 

SQL is as follows:

select convert(name using utf8mb4) from test b where name = '4'

 

Error Message:

  

Issue Links

• duplicates: CALCITE-111 Support CONVERT function, for changing character sets