Debian Codegraph @

mysql-test/suite/ndbcluster/check_constraints.result

raw
1 #-----------------------------------------------------------------------
2 # Bug#29706621 - CHECK CONSTRAINT COMPARING COLUMNS IS NOT ALWAYS
3 # ENFORCED WITH UPDATE QUERIES.
4 #-----------------------------------------------------------------------
5 CREATE TABLE t1 (id INT PRIMARY KEY,
6 a CHAR(10) NOT NULL,
7 b LONGTEXT NOT NULL,
8 CHECK (LOCATE(a, b) != 0)) ENGINE=NDBCLUSTER;
9 INSERT 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.
12 UPDATE t1 SET a = 'e' WHERE id = 2;
13 DROP TABLE t1;