1#----------------------------------------------------------------------- 2# Bug#29706621 - CHECK CONSTRAINT COMPARING COLUMNS IS NOT ALWAYS 3# ENFORCED WITH UPDATE QUERIES. 4#----------------------------------------------------------------------- 5CREATE TABLE t1 (id INT PRIMARY KEY, 6a CHAR(10) NOT NULL, 7b LONGTEXT NOT NULL, 8CHECK (LOCATE(a, b) != 0)) ENGINE=NDBCLUSTER; 9INSERT INTO t1 VALUES (1, "a", "abcd"), (2, "b", "abcde"), (3, "c", "abcd"); 10# Without additional fix to read_set evaluation the below statement 11# has failed due constraint evaluated on wrong data. 12UPDATE t1 SET a = 'e' WHERE id = 2; 13DROP TABLE t1; 14