Debian Codegraph @

mysql-test/suite/galera/t/galera_nopk_unicode.test

raw
1 #
2 # Test non-ascii data in table without a PK
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (
9 f1 VARCHAR(255),
10 KEY (f1)
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
13 INSERT INTO t1 VALUES ('текст');
14
15 --connection node_2
16 SELECT f1 = 'текст' FROM t1;
17
18 #
19 # Provoke a conflict
20 #
21
22 --connection node_1
23 SET AUTOCOMMIT=OFF;
24 START TRANSACTION;
25 UPDATE t1 SET f1 = 'текст2';
26
27 --connection node_2
28 SET AUTOCOMMIT=OFF;
29 START TRANSACTION;
30 UPDATE t1 SET f1 = 'текст3';
31
32 --connection node_1
33 COMMIT;
34
35 --connection node_2
36 --error ER_LOCK_DEADLOCK
37 COMMIT;
38
39 SELECT f1 = 'текст2' FROM t1;
40 SELECT f1 = 'текст2' FROM t1 WHERE f1 = 'текст2';
41
42 DROP TABLE t1;