The restrict implicit binary conversion mode (CONVERSION_MODE set to 1) applies to LOAD TABLE with CHECK constraint or default value.
CREATE TABLE t3 (c1 INT,
csi SMALLINT,
cvb VARBINARY(2),
CHECK (csi<cvb));
SET TEMPORARY OPTION CONVERSION_MODE = 1;
This request:
LOAD TABLE t3(c1 ',', csi ',', cvb ',')
FROM '/s1/mydata/t3.inp'
QUOTES OFF ESCAPES OFF
ROW DELIMITED BY '\n'
fails with the message:
"Invalid data type comparison in predicate (t3.csi < t3.cvb), [-1001013] ['QFA13']"