Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (
4 f1 VARCHAR(255),
5 KEY (f1)
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 DROP TABLE t1;