EVOLUTION-MANAGER

Edit File: galera_nopk_blob.test

# # This checks that even tables with a single BLOB column and no FK are replicated properly # --source include/galera_cluster.inc --source include/have_innodb.inc CREATE TABLE t1 (f1 BLOB) ENGINE=InnoDB; INSERT INTO t1 VALUES (NULL),('abc'); --connection node_2 SELECT f1 FROM t1; DELETE FROM t1 WHERE f1 IS NULL; UPDATE t1 SET f1 = 'xyz' WHERE f1 = 'abc'; --connection node_1 SELECT COUNT(*) = 1 FROM t1; SELECT f1 = 'abc' FROM t1; # # Provoke a conflict # --connection node_1 CREATE TABLE t2 (f1 BLOB) ENGINE=InnoDB; INSERT INTO t2 VALUES (NULL); SET AUTOCOMMIT=OFF; START TRANSACTION; UPDATE t2 SET f1 = 'abc' WHERE f1 IS NULL; --connection node_2 SET AUTOCOMMIT=OFF; START TRANSACTION; UPDATE t2 SET f1 = 'xyz' WHERE f1 IS NULL; --connection node_1 COMMIT; --connection node_2 --error ER_LOCK_DEADLOCK COMMIT; DROP TABLE t1; DROP TABLE t2;