[CALCITE-2510] Add CHR built-in function (Oracle only)

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: Sergey Tsvetkov
• Created: 30/Aug/18 08:51
• Updated: 21/Aug/22 22:20
• Resolved: 23/Jul/19 08:44

Description

Adding CHR() function support, available in Oracle & PostgreSql

https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions019.htm

https://www.postgresql.org/docs/9.4/static/functions-string.html

 

Issue Links

• is related to: CALCITE-2846 Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference
• relates to: CALCITE-5241 Implement CHAR function (for MySQL, Spark compatibility), and JDBC {fn CHAR(n)}
• links to: GitHub Pull Request #810
• links to: https://github.com/apache/calcite/pull/810