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