Debian Codegraph @

mysql-test/suite/galera/r/galera_many_columns.result

raw
1 connection node_2;
2 connection node_1;
3 INSERT INTO t1 (f1) VALUES (DEFAULT);
4 connection node_2;
5 SELECT f1 = 'ABC', f1017 = 'ABC' FROM t1;
6 f1 = 'ABC' f1017 = 'ABC'
7 1 1
8 UPDATE t1 SET f1 = 'XYZ', f1017 = 'XYZ' ;
9 connection node_1;
10 SELECT f1 = 'XYZ', f1017 = 'XYZ' FROM t1 WHERE f1 = 'XYZ' AND f1017 = 'XYZ';
11 f1 = 'XYZ' f1017 = 'XYZ'
12 1 1
13 connection node_1;
14 SET AUTOCOMMIT=OFF;
15 START TRANSACTION;
16 UPDATE t1 SET f2 = 'KLM' WHERE f1 = 'XYZ' AND f1017 = 'XYZ';
17 connection node_2;
18 SET AUTOCOMMIT=OFF;
19 START TRANSACTION;
20 UPDATE t1 SET f2 = 'CDE' WHERE f1 = 'XYZ' AND f1017 = 'XYZ';
21 COMMIT;
22 connection node_1;
23 COMMIT;
24 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
25 ROLLBACK;
26 connection node_2;
27 ROLLBACK;
28 connection node_1;
29 START TRANSACTION;
30 INSERT INTO t1 (f1, f1017) VALUES ('BCE','BCE');
31 INSERT INTO t1 (f1, f1017) VALUES ('CED','CED');
32 INSERT INTO t1 (f1, f1017) VALUES ('EDF','EDF');
33 INSERT INTO t1 (f1, f1017) VALUES ('FED','FED');
34 ROLLBACK;
35 SELECT COUNT(*) = 1 FROM t1;
36 COUNT(*) = 1
37 1
38 connection node_2;
39 SELECT COUNT(*) = 1 FROM t1;
40 COUNT(*) = 1
41 1
42 DROP TABLE t1;