[CALCITE-5664] Support CONVERT function with "USING" keyword

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.34.0
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: pull-request-available
• Assignee: ZheHu
• Reporter: ZheHu
• Created: 20/Apr/23 08:20
• Updated: 27/Jul/23 10:22
• Resolved: 03/May/23 19:12

Description

After CALCITE-111, we now support CONVERT(charValue, srcCharsetName, destCharsetName) that works on converting character sets.
CONVERT(charValue USING transcodingName) also fits the SQL standard, and MySQL has  implement it, which is the same as TRANSLATE(charValue USING transcodingName) 

For example:

• select convert('employ_id' using utf16) as alia from employee
• select translate('employ_id' using utf8) as alia from employee

Noted: Calcite already supports this from the parser.

Issue Links

• relates to: CALCITE-5685 Support MySQL CONVERT function that works on data types
• links to: GitHub Pull Request #3173