EVOLUTION-MANAGER

Edit File: galera_nopk_large_varchar.result

CREATE TABLE t1 (f1 VARCHAR(8000)) ENGINE=InnoDB; INSERT INTO t1 VALUES (NULL),(CONCAT(REPEAT('x', 7999), 'a')); connection node_2; SELECT LENGTH(f1) FROM t1; LENGTH(f1) NULL 8000 DELETE FROM t1 WHERE f1 IS NULL; UPDATE t1 SET f1 = CONCAT(REPEAT('x', 7999), 'b') WHERE f1 = CONCAT(REPEAT('x', 7999), 'a'); connection node_1; SELECT COUNT(*) = 1 FROM t1; COUNT(*) = 1 1 SELECT LENGTH(f1) = 8000 FROM t1; LENGTH(f1) = 8000 1 SELECT f1 = CONCAT(REPEAT('x', 7999), 'b') FROM t1; f1 = CONCAT(REPEAT('x', 7999), 'b') 1 connection node_1; CREATE TABLE t2 (f1 BLOB) ENGINE=InnoDB; INSERT INTO t2 VALUES (CONCAT(REPEAT('x', 7999), 'a')); SET AUTOCOMMIT=OFF; START TRANSACTION; UPDATE t2 SET f1 = 'abc' WHERE f1 = CONCAT(REPEAT('x', 7999), 'a'); connection node_2; SET AUTOCOMMIT=OFF; START TRANSACTION; UPDATE t2 SET f1 = 'xyz' WHERE f1 = CONCAT(REPEAT('x', 7999), 'a'); connection node_1; COMMIT; connection node_2; COMMIT; ERROR 40001: Deadlock: wsrep aborted transaction DROP TABLE t1; DROP TABLE t2;