Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 VARCHAR(767) PRIMARY KEY) ENGINE=InnoDB CHARSET=latin1;
4 CREATE UNIQUE INDEX i63 ON t1(f1);
5 CREATE UNIQUE INDEX i62 ON t1(f1);
6 CREATE UNIQUE INDEX i61 ON t1(f1);
7 CREATE UNIQUE INDEX i60 ON t1(f1);
8 CREATE UNIQUE INDEX i59 ON t1(f1);
9 CREATE UNIQUE INDEX i58 ON t1(f1);
10 CREATE UNIQUE INDEX i57 ON t1(f1);
11 CREATE UNIQUE INDEX i56 ON t1(f1);
12 CREATE UNIQUE INDEX i55 ON t1(f1);
13 CREATE UNIQUE INDEX i54 ON t1(f1);
14 CREATE UNIQUE INDEX i53 ON t1(f1);
15 CREATE UNIQUE INDEX i52 ON t1(f1);
16 CREATE UNIQUE INDEX i51 ON t1(f1);
17 CREATE UNIQUE INDEX i50 ON t1(f1);
18 CREATE UNIQUE INDEX i49 ON t1(f1);
19 CREATE UNIQUE INDEX i48 ON t1(f1);
20 CREATE UNIQUE INDEX i47 ON t1(f1);
21 CREATE UNIQUE INDEX i46 ON t1(f1);
22 CREATE UNIQUE INDEX i45 ON t1(f1);
23 CREATE UNIQUE INDEX i44 ON t1(f1);
24 CREATE UNIQUE INDEX i43 ON t1(f1);
25 CREATE UNIQUE INDEX i42 ON t1(f1);
26 CREATE UNIQUE INDEX i41 ON t1(f1);
27 CREATE UNIQUE INDEX i40 ON t1(f1);
28 CREATE UNIQUE INDEX i39 ON t1(f1);
29 CREATE UNIQUE INDEX i38 ON t1(f1);
30 CREATE UNIQUE INDEX i37 ON t1(f1);
31 CREATE UNIQUE INDEX i36 ON t1(f1);
32 CREATE UNIQUE INDEX i35 ON t1(f1);
33 CREATE UNIQUE INDEX i34 ON t1(f1);
34 CREATE UNIQUE INDEX i33 ON t1(f1);
35 CREATE UNIQUE INDEX i32 ON t1(f1);
36 CREATE UNIQUE INDEX i31 ON t1(f1);
37 CREATE UNIQUE INDEX i30 ON t1(f1);
38 CREATE UNIQUE INDEX i29 ON t1(f1);
39 CREATE UNIQUE INDEX i28 ON t1(f1);
40 CREATE UNIQUE INDEX i27 ON t1(f1);
41 CREATE UNIQUE INDEX i26 ON t1(f1);
42 CREATE UNIQUE INDEX i25 ON t1(f1);
43 CREATE UNIQUE INDEX i24 ON t1(f1);
44 CREATE UNIQUE INDEX i23 ON t1(f1);
45 CREATE UNIQUE INDEX i22 ON t1(f1);
46 CREATE UNIQUE INDEX i21 ON t1(f1);
47 CREATE UNIQUE INDEX i20 ON t1(f1);
48 CREATE UNIQUE INDEX i19 ON t1(f1);
49 CREATE UNIQUE INDEX i18 ON t1(f1);
50 CREATE UNIQUE INDEX i17 ON t1(f1);
51 CREATE UNIQUE INDEX i16 ON t1(f1);
52 CREATE UNIQUE INDEX i15 ON t1(f1);
53 CREATE UNIQUE INDEX i14 ON t1(f1);
54 CREATE UNIQUE INDEX i13 ON t1(f1);
55 CREATE UNIQUE INDEX i12 ON t1(f1);
56 CREATE UNIQUE INDEX i11 ON t1(f1);
57 CREATE UNIQUE INDEX i10 ON t1(f1);
58 CREATE UNIQUE INDEX i9 ON t1(f1);
59 CREATE UNIQUE INDEX i8 ON t1(f1);
60 CREATE UNIQUE INDEX i7 ON t1(f1);
61 CREATE UNIQUE INDEX i6 ON t1(f1);
62 CREATE UNIQUE INDEX i5 ON t1(f1);
63 CREATE UNIQUE INDEX i4 ON t1(f1);
64 CREATE UNIQUE INDEX i3 ON t1(f1);
65 CREATE UNIQUE INDEX i2 ON t1(f1);
66 CREATE UNIQUE INDEX i1 ON t1(f1);
67 INSERT INTO t1 VALUES (REPEAT('a', 767));
68 connection node_2;
69 SELECT COUNT(*) = 1 FROM t1;
70 COUNT(*) = 1
71 1
72 SELECT LENGTH(f1) = 767 FROM t1;
73 LENGTH(f1) = 767
74 1
75 EXPLAIN SELECT COUNT(*) = 1 FROM t1 FORCE KEY (PRIMARY) WHERE f1 = REPEAT('a', 767);
76 id select_type table type possible_keys key key_len ref rows Extra
77 1 SIMPLE t1 const PRIMARY PRIMARY 769 const 1
78 SELECT COUNT(*) = 1 FROM t1 FORCE KEY (PRIMARY) WHERE f1 = REPEAT('a', 767);
79 COUNT(*) = 1
80 1
81 EXPLAIN SELECT COUNT(*) = 1 FROM t1 FORCE KEY (i1) WHERE f1 = REPEAT('a', 767);
82 id select_type table type possible_keys key key_len ref rows Extra
83 1 SIMPLE t1 const i1 i1 769 const 1 Using index
84 SELECT COUNT(*) = 1 FROM t1 FORCE KEY (i1) WHERE f1 = REPEAT('a', 767);
85 COUNT(*) = 1
86 1
87 EXPLAIN SELECT COUNT(*) = 1 FROM t1 FORCE KEY (i63) WHERE f1 = REPEAT('a', 767);
88 id select_type table type possible_keys key key_len ref rows Extra
89 1 SIMPLE t1 const i63 i63 769 const 1 Using index
90 SELECT COUNT(*) = 1 FROM t1 FORCE KEY (i63) WHERE f1 = REPEAT('a', 767);
91 COUNT(*) = 1
92 1
93 INSERT INTO t1 VALUES (REPEAT('b', 767));
94 ANALYZE TABLE t1;
95 Table Op Msg_type Msg_text
96 test.t1 analyze status Engine-independent statistics collected
97 test.t1 analyze status OK
98 connection node_1;
99 SELECT COUNT(*) = 2 FROM t1;
100 COUNT(*) = 2
101 1
102 ANALYZE TABLE t1;
103 Table Op Msg_type Msg_text
104 test.t1 analyze status Engine-independent statistics collected
105 test.t1 analyze status OK
106 DELETE FROM t1 WHERE f1 = REPEAT('b', 767);
107 connection node_1;
108 SET AUTOCOMMIT=OFF;
109 START TRANSACTION;
110 SELECT COUNT(*) = 1 FROM t1;
111 COUNT(*) = 1
112 1
113 INSERT INTO t1 (f1) VALUES (REPEAT('c', 767));
114 ROLLBACK;
115 SELECT COUNT(*) = 1 FROM t1;
116 COUNT(*) = 1
117 1
118 connection node_2;
119 START TRANSACTION;
120 SET AUTOCOMMIT=OFF;
121 SELECT COUNT(*) = 1 FROM t1;
122 COUNT(*) = 1
123 1
124 connection node_1;
125 START TRANSACTION;
126 connection node_2;
127 START TRANSACTION;
128 connection node_1;
129 UPDATE t1 SET f1 = REPEAT('e', 767);
130 connection node_2;
131 UPDATE t1 SET f1 = REPEAT('f', 767);
132 connection node_1;
133 COMMIT;
134 connection node_2;
135 COMMIT;
136 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
137 DROP TABLE t1;