Debian Codegraph @

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

raw
1 #
2 # Test non-ascii data in table where the PK is unicode
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 --connection node_1
9 # Mare sure both nodes are in the cluster
10 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
11 --source include/wait_condition.inc
12
13 CREATE TABLE t1 (
14 f1 VARCHAR(255) PRIMARY KEY
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
16
17 INSERT INTO t1 VALUES ('текст');
18
19 --connection node_2
20 # Mare sure that DLL has replicated and insert has replicated
21 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'
22 --source include/wait_condition.inc
23 --let $wait_condition = SELECT COUNT(*) = 1 FROM t1
24 --source include/wait_condition.inc
25
26 SELECT f1 = 'текст' FROM t1;
27
28 #
29 # Provoke a conflict
30 #
31
32 --connection node_1
33 SET AUTOCOMMIT=OFF;
34 START TRANSACTION;
35 UPDATE t1 SET f1 = 'текст2';
36
37 --connection node_2
38 SET AUTOCOMMIT=OFF;
39 START TRANSACTION;
40 UPDATE t1 SET f1 = 'текст3';
41
42 --connection node_1
43 COMMIT;
44
45 --connection node_2
46 --error ER_LOCK_DEADLOCK
47 COMMIT;
48
49 SELECT f1 = 'текст2' FROM t1;
50 SELECT f1 = 'текст2' FROM t1 WHERE f1 = 'текст2';
51
52 #
53 # Provoke a duplicate key error
54 #
55
56 --connection node_2
57 START TRANSACTION;
58 INSERT INTO t1 VALUES ('текст4');
59
60 --connection node_1
61 START TRANSACTION;
62 INSERT INTO t1 VALUES ('текст4');
63
64 --connection node_2
65 COMMIT;
66
67 --connection node_1
68 --error ER_LOCK_DEADLOCK
69 COMMIT;
70
71 # Work around for mysql-wsrep#29 'Spurious deadlock error on a DROP TABLE'
72 --error 0,ER_LOCK_DEADLOCK
73 COMMIT;
74
75 DROP TABLE t1;