Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 CREATE TABLE t1 (f1 VARCHAR(767) PRIMARY KEY) ENGINE=InnoDB CHARSET=latin1;
5
6 # MySQL complains about multiple identical indexes on the same column
7 --disable_warnings
8
9 --let $count = 63
10 while ($count)
11 {
12 --disable_query_log
13 --eval SET @ddl_var1 = CONCAT("CREATE UNIQUE INDEX i", $count, " ON t1(f1)")
14 --let $ddl_var = `SELECT @ddl_var1`
15 --enable_query_log
16 --eval $ddl_var
17 --dec $count
18 }
19 --enable_warnings
20
21 INSERT INTO t1 VALUES (REPEAT('a', 767));
22 --connection node_2
23 SELECT COUNT(*) = 1 FROM t1;
24 SELECT LENGTH(f1) = 767 FROM t1;
25
26 EXPLAIN SELECT COUNT(*) = 1 FROM t1 FORCE KEY (PRIMARY) WHERE f1 = REPEAT('a', 767);
27 SELECT COUNT(*) = 1 FROM t1 FORCE KEY (PRIMARY) WHERE f1 = REPEAT('a', 767);
28
29 EXPLAIN SELECT COUNT(*) = 1 FROM t1 FORCE KEY (i1) WHERE f1 = REPEAT('a', 767);
30 SELECT COUNT(*) = 1 FROM t1 FORCE KEY (i1) WHERE f1 = REPEAT('a', 767);
31
32 EXPLAIN SELECT COUNT(*) = 1 FROM t1 FORCE KEY (i63) WHERE f1 = REPEAT('a', 767);
33 SELECT COUNT(*) = 1 FROM t1 FORCE KEY (i63) WHERE f1 = REPEAT('a', 767);
34
35 INSERT INTO t1 VALUES (REPEAT('b', 767));
36 ANALYZE TABLE t1;
37
38 --connection node_1
39 SELECT COUNT(*) = 2 FROM t1;
40 ANALYZE TABLE t1;
41 DELETE FROM t1 WHERE f1 = REPEAT('b', 767);
42
43 # Rollback
44 --connection node_1
45 SET AUTOCOMMIT=OFF;
46 START TRANSACTION;
47 SELECT COUNT(*) = 1 FROM t1;
48 INSERT INTO t1 (f1) VALUES (REPEAT('c', 767));
49 ROLLBACK;
50 SELECT COUNT(*) = 1 FROM t1;
51
52 --connection node_2
53 START TRANSACTION;
54 SET AUTOCOMMIT=OFF;
55 SELECT COUNT(*) = 1 FROM t1;
56
57 # Deadlock
58 --connection node_1
59 START TRANSACTION;
60 --connection node_2
61 START TRANSACTION;
62
63 --connection node_1
64 UPDATE t1 SET f1 = REPEAT('e', 767);
65 --connection node_2
66 UPDATE t1 SET f1 = REPEAT('f', 767);
67
68 --connection node_1
69 COMMIT;
70 --connection node_2
71 --error ER_LOCK_DEADLOCK
72 COMMIT;
73
74 DROP TABLE t1;