| 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; |