[CALCITE-5241] Implement CHAR function (for MySQL, Spark compatibility), and JDBC {fn CHAR(n)}

• Type: Wish
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.32.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jiajun Xie
• Reporter: Pengfei Zhan
• Created: 19/Aug/22 10:52
• Updated: 10/Sep/22 08:40
• Resolved: 09/Sep/22 06:40

Description

Implement the CHAR(n) function and the {fn CHAR(string)} JDBC function.

Spark and hive support `char(n)`, however, calcite doesn't support it. Is there any message I missed?

Issue Links

• is related to: CALCITE-2510 Add CHR built-in function (Oracle only)
• links to: GitHub Pull Request #2878