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