CHAR-function leads to Syntax error when used as first argument for many functions

Detail name	Value
Changelog Number	9114
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.1.0, Exasol 6.2.0
Fix Versions	Exasol 6.2.3, Exasol 6.1.8
Resolution Date	2019-11-28

Description

Many functions return a SyntaxError when using the function [CHAR|https://docs.exasol.com/sql_references/functions/alphabeticallistfunctions/ch[a]r.htm?Highlight=CHR] as first argument.
The reason for that is an ambiguity with the data type CHAR.

Example

SELECT ASCII(CHAR(53));
SELECT CONCAT(CHAR(53), CHAR(54));

Workaround

You can use CHR instead which does exactly the same thing as CHAR, but without ambiguity with the data type CHAR.

SELECT ASCII(CHR(53));
SELECT CONCAT(CHR(53), CHR(54));