Debian Codegraph @

mysql-test/suite/ndbcluster/check_constraints.test

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