Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (
5 f1 VARCHAR(255) PRIMARY KEY
6 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
7 INSERT INTO t1 VALUES ('текст');
8 connection node_2;
9 SELECT f1 = 'текст' FROM t1;
10 f1 = 'текст'
11 1
12 connection node_1;
13 SET AUTOCOMMIT=OFF;
14 START TRANSACTION;
15 UPDATE t1 SET f1 = 'текст2';
16 connection node_2;
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 UPDATE t1 SET f1 = 'текст3';
20 connection node_1;
21 COMMIT;
22 connection node_2;
23 COMMIT;
24 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
25 SELECT f1 = 'текст2' FROM t1;
26 f1 = 'текст2'
27 1
28 SELECT f1 = 'текст2' FROM t1 WHERE f1 = 'текст2';
29 f1 = 'текст2'
30 1
31 connection node_2;
32 START TRANSACTION;
33 INSERT INTO t1 VALUES ('текст4');
34 connection node_1;
35 START TRANSACTION;
36 INSERT INTO t1 VALUES ('текст4');
37 connection node_2;
38 COMMIT;
39 connection node_1;
40 COMMIT;
41 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
42 COMMIT;
43 DROP TABLE t1;