Stamatis Zampetakis created CALCITE-4690:
--------------------------------------------
Summary: Error when when executing query with CHARACTER SET in
Redshift
Key: CALCITE-4690
URL: https://issues.apache.org/jira/browse/CALCITE-4690
Project: Calcite
Issue Type: Bug
Components: core, jdbc-adapter
Affects Versions: 1.27.0
Reporter: Stamatis Zampetakis
Assignee: Stamatis Zampetakis
Fix For: 1.28.0
Redshift does not support character sets in [data
types|https://docs.aws.amazon.com/redshift/latest/dg/r_Character_types.html].
In fact it seems that it only supports
[UTF-8|https://docs.aws.amazon.com/redshift/latest/dg/multi-byte-character-load-errors.html].
As a result any appearance of the CHARACTER SET clause in a query leads to
errors.
{code:sql}
select cast (col1 as varchar(3) CHARACTER SET "ISO-8859-1") from test;
{code}
{noformat}
Error: ERROR: type "pg_catalog.varchar_iso-8859-1" does not exist
(state=42704,code=0)
{noformat}
Even if {{CHARACTER SET}} clause is not explicitly present in the original
query it might appear in the generated SQL via {{RelToSqlConverter}} due to
casts or other operations.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
