2464249 - LOAD TABLE statement ignores conversion error - SAP IQ

SAP IQ ignores conversion error when adding only the "IGNORE CONSTRAINT UNIQUE" constraint violation to the LOAD TABLE statement.
As a result, invalid data (NULL) may be inserted in the table.

For example, when inserting the following data using the LOAD TABLE statement, SAP IQ inserts invalid data into a numeric column.

1,AA,
A,BB,

(DBA)> LOAD TABLE repro_tab (col1, col2) USING FILE 'load.dat' DELIMITED BY ',' ROW DELIMITED BY 0x0a QUOTES ON ESCAPES OFF IGNORE CONSTRAINT UNIQUE 0;
2 row(s) affected
Execution time: 0.01 seconds

(DBA)> select * from repro_tab
       col1 col2
----------------------
          1 AA
     (NULL) BB

(2 rows)

• SAP IQ 16.0 SP 08 PL23 and later

LOAD TABLE. DATA VALUE, ignore constraint, CONVERSION ERROR, UNIQUE, NULL , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed