[CALCITE-1330] DB2 does not support character sets in data type

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: MinJi Kim
• Created: 25/Jul/16 23:50
• Updated: 27/Feb/24 22:23
• Resolved: 26/Jul/16 19:36

Description

I have a very small db2 database, and it does not support "varchar(100) CHARACTER SET `ISO-8859-1`".

db2 => select TS, cast(TS as varchar(100)) from mydb.mytimestamp
TS 2
-------------------------- ----------------------------------------------------------------------------------------------------
2016-07-18-01.02.03.000000 2016-07-18-01.02.03.000000
1 record(s) selected.

db2 => select TS, cast(TS as varchar(100) CHARACTER SET "ISO-8859-1") from mydb.mytimestamp
SQL0104N An unexpected token "CHARACTER SET "ISO-8859-1"" was found following
"t(TS as varchar(100)". Expected tokens may include: "<space>".
SQLSTATE=42601