diff options
Diffstat (limited to 'mysql-test/suite/galera/r/MW-328D.result')
-rw-r--r-- | mysql-test/suite/galera/r/MW-328D.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/MW-328D.result b/mysql-test/suite/galera/r/MW-328D.result new file mode 100644 index 00000000..43e1cefe --- /dev/null +++ b/mysql-test/suite/galera/r/MW-328D.result @@ -0,0 +1,22 @@ +connection node_2; +connection node_1; +CREATE TABLE t1 (i INT) ENGINE = InnoDB; +INSERT INTO t1 (i) VALUES(1); +CREATE TABLE t2 (i INT) ENGINE = InnoDB; +connection node_1; +SET AUTOCOMMIT=OFF; +START TRANSACTION; +SELECT * FROM t1 WHERE i = 1 LOCK IN SHARE MODE; +i +1 +connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1; +connection node_1a; +SET AUTOCOMMIT=OFF; +START TRANSACTION; +INSERT IGNORE INTO t2 SELECT * FROM t1 WHERE i = 1 FOR UPDATE;; +connection node_1; +DELETE FROM t1 WHERE i = 1; +COMMIT; +connection node_1a; +ERROR 40001: Deadlock found when trying to get lock; try restarting transaction +DROP TABLE t1, t2; |