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']"