Debian Codegraph @

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

raw
1 --source include/big_test.inc
2 --source include/galera_cluster.inc
3 --source include/have_innodb.inc
4
5 if (!`SELECT @@open_files_limit >= 1024`){
6 skip Need at least an open file limit of 1000;
7 }
8
9 #
10 # This test forces 100 tables without a PK to participate in a single
11 # transaction.
12 #
13
14 #
15 # First, create 100 tables
16 #
17
18 --connection node_1
19
20 --let $count = 100
21 while ($count)
22 {
23 --disable_query_log
24 --let $ddl_var = `SELECT CONCAT("CREATE TABLE t", $count, " (f1 INTEGER) ENGINE=InnoDB")`
25 --eval $ddl_var
26 --enable_query_log
27 --dec $count
28 }
29
30 --let $count = 100
31 while ($count)
32 {
33 --disable_query_log
34 --let $ddl_var = `SELECT CONCAT("INSERT INTO t", $count, " VALUES (1234)")`
35 --eval $ddl_var
36 --enable_query_log
37 --dec $count
38 }
39
40 #
41 # Second, perform 100 updates
42 #
43
44 SET AUTOCOMMIT=OFF;
45 START TRANSACTION;
46
47 --let $count = 100
48 while ($count)
49 {
50 --disable_query_log
51 --let $ddl_var = `SELECT CONCAT("UPDATE t", $count, " SET f1 = 1")`
52 --eval $ddl_var
53 --enable_query_log
54 --dec $count
55 }
56
57 COMMIT;
58
59 # Third, confirm that all the inserts have arrived on the second node
60 #
61
62 --connection node_2
63 CREATE TABLE sum_table (f1 INTEGER);
64
65 --let $count = 100
66 while ($count)
67 {
68 --disable_query_log
69 --let $ddl_var = `SELECT CONCAT("INSERT INTO sum_table SELECT COUNT(*) FROM t", $count)`
70 --eval $ddl_var
71 --enable_query_log
72 --dec $count
73 }
74
75 SELECT SUM(f1) = 100 FROM sum_table;
76
77 #
78 # Fourth, create a deadlock
79 #
80
81 --connection node_1
82 SET AUTOCOMMIT=OFF;
83 START TRANSACTION;
84
85 --let $count = 100
86 while ($count)
87 {
88 --disable_query_log
89 --let $ddl_var = `SELECT CONCAT("UPDATE t", $count, " SET f1 = 2")`
90 --eval $ddl_var
91 --enable_query_log
92 --dec $count
93 }
94
95 --connection node_2
96 SET AUTOCOMMIT=OFF;
97 START TRANSACTION;
98 UPDATE t100 SET f1 = 3;
99
100 --connection node_1
101 COMMIT;
102
103 --connection node_2
104 --error ER_LOCK_DEADLOCK
105 COMMIT;
106
107 DROP SCHEMA test;
108 CREATE SCHEMA test;