3644964 - "dflib/dfe_CastConstant.cxx" error occurs on SAP IQ 16.1 SP05.14 using multi-byte character set

• "dflib/dfe_CastConstant.cxx" error occurs when executing queries involving multi-byte characters in SAP IQ 16.1 SP05.14.

(dba)> select substr('일이삼사오육칠팔구십', 1,5) as multi_bytes_result into #tmp1 from iq_dummy;
Could not execute statement.
  Data exception - string data, right truncation.
  --
  (dflib/dfe_CastConstant.cxx 1015)
  SQLCODE=-1001009, ODBC 3 State="HY000"

Line 1, column 1
  select substr('일이삼사오육칠팔구십', 1,5) as multi_bytes_result into #tmp1 from iq_dummy

Press ENTER to continue...

• The issue arises when inserting results of "substr()" function into a #temp table
• The error does not occur in SAP IQ 16.0 SP11.28 or SAP IQ 16.1 SP004.07 under similar conditions.

• SAP IQ 16.1 SP05.14
• IQ database created with Collations using Multi-bytes character set like 949KOR, EUC_KOREA, 936ZHO ...

sql error -1001009, data exception, string truncation, multi-byte characters, sap iq 16.1, temporary tables, substr function, string_rtruncation, workaround, varchar conversion, sap iq 16.0 compatibility, sql anywhere error , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem