[CALCITE-4690] Error when executing query with CHARACTER SET in Redshift

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.27.0
• Fix Version/s: 1.28.0
• Component/s: core, jdbc-adapter
• Labels: pull-request-available
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 09/Jul/21 18:32
• Updated: 20/Oct/21 05:25
• Resolved: 13/Jul/21 17:37

Description

Redshift does not support character sets in data types. In fact it seems that it only supports UTF-8. As a result any appearance of the CHARACTER SET clause in a query leads to errors.

select cast (col1 as varchar(3) CHARACTER SET "ISO-8859-1") from test;

Error: ERROR: type "pg_catalog.varchar_iso-8859-1" does not exist (state=42704,code=0)

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.

Issue Links

• links to: GitHub Pull Request #2457