Debian Codegraph @

mysql-test/suite/maria/lock.test

raw
1 #
2 # Testing of potential problems in Aria with locking
3 #
4
5 -- source include/have_maria.inc
6
7 drop table if exists t1,t2;
8
9 #
10 # Test for Bug#973039
11 # Assertion `share->in_trans == 0' failed in maria_close on DROP TABLE
12 # under LOCK
13 #
14
15 # Test DROP TABLE
16
17 CREATE TABLE t1 (i INT) ENGINE=Aria;
18 CREATE TABLE t2 (i INT) ENGINE=Aria;
19 LOCK TABLE t1 WRITE, t2 WRITE;
20 # Also fails with FLUSH TABLE t1 and with REPAIR TABLE t1 USE_FRM
21 DROP TABLE t1;
22 UNLOCK TABLES;
23 DROP TABLE t2;
24
25 #Test FLUSH TABLE
26
27 CREATE TABLE t1 (i INT) ENGINE=Aria;
28 CREATE TABLE t2 (i INT) ENGINE=Aria;
29 LOCK TABLE t1 WRITE, t2 WRITE;
30 FLUSH TABLE t1;
31 select * from t1;
32 unlock tables;
33 drop table t1,t2;
34
35 # Test REPAIR ... USE_FRM and unlock tables last
36
37 CREATE TABLE t1 (i INT) ENGINE=Aria;
38 CREATE TABLE t2 (i INT) ENGINE=Aria;
39 LOCK TABLE t1 WRITE, t2 WRITE;
40 repair table t1 use_frm;
41 select * from t1;
42 drop table t2;
43 unlock tables;
44 drop table t1;
45
46 #
47 # MDEV-366: lock table twice with LOCK TABLES and then drop it
48 #
49
50 CREATE TABLE t1 (i INT) ENGINE=Aria;
51 LOCK TABLES t1 WRITE, t1 AS t1a WRITE;
52 DROP TABLE t1;
53
54 --echo #
55 --echo # MDEV-8200 aria bug with insert select when select is a aria table
56 --echo # (wrong result or assertion failure:
57 --echo # `table->file->stats.records > 0 || error')
58 --echo #
59
60 CREATE TABLE t1 (f1 INT) ENGINE=Aria;
61 SHOW CREATE TABLE t1;
62 INSERT INTO t1 VALUES (1);
63 CREATE TABLE t2 (f2 INT) ENGINE=MyISAM;
64 CREATE TABLE tmp (f3 INT) engine=Aria;
65 LOCK TABLE t2 WRITE, tmp WRITE, tmp AS tmp_alias WRITE, t1 WRITE;
66 INSERT INTO tmp SELECT f1 FROM t1;
67 INSERT INTO t2 SELECT f3 FROM tmp AS tmp_alias;
68 select * from t2;
69 unlock tables;
70 DROP TABLE t1,t2,tmp;
71
72 --echo #
73 --echo # Same without transactional
74 --echo #
75
76 CREATE TABLE t1 (f1 INT) transactional=0 ENGINE=Aria;
77 SHOW CREATE TABLE t1;
78 INSERT INTO t1 VALUES (2);
79 CREATE TABLE t2 (f2 INT) ENGINE=MyISAM;
80 CREATE TABLE tmp (f3 INT) transactional=0 engine=Aria;
81 LOCK TABLE t2 WRITE, tmp WRITE, tmp AS tmp_alias WRITE, t1 WRITE;
82 INSERT INTO tmp SELECT f1 FROM t1;
83 INSERT INTO t2 SELECT f3 FROM tmp AS tmp_alias;
84 select * from t2;
85 unlock tables;
86 DROP TABLE t1,t2,tmp;
87
88 --echo #
89 --echo # Using spatical keys (disables versioning)
90 --echo #
91
92 CREATE TABLE t1 (f1 INT, c1 geometry NOT NULL, SPATIAL KEY i1 (c1)) transactional=1 ENGINE=Aria;
93 SHOW CREATE TABLE t1;
94 INSERT INTO t1 VALUES (3,
95 PolygonFromText('POLYGON((-18.6086111000 -66.9327777000,
96 -18.6055555000 -66.8158332999,
97 -18.7186111000 -66.8102777000,
98 -18.7211111000 -66.9269443999,
99 -18.6086111000 -66.9327777000))'));
100 CREATE TABLE t2 (f2 INT) ENGINE=MyISAM;
101 CREATE TABLE tmp (f3 INT, c1 geometry NOT NULL, SPATIAL KEY i1 (c1)) transactional=1 ENGINE=Aria;
102 LOCK TABLE t2 WRITE, tmp WRITE, tmp AS tmp_alias WRITE, t1 WRITE;
103 INSERT INTO tmp SELECT f1,c1 FROM t1;
104 INSERT INTO t2 (f2) SELECT f3 FROM tmp AS tmp_alias;
105 select * from t2;
106 unlock tables;
107 DROP TABLE t1,t2,tmp;
108
109 --echo #
110 --echo # MDEV-10378 Assertion `trn' failed in virtual int ha_maria::start_stmt
111 --echo #
112
113 CREATE TABLE t1 (f1 VARCHAR(3), f2 INT, pk INT, PRIMARY KEY (pk)) ENGINE=Aria;
114 INSERT INTO t1 VALUES ('foo',10,1), ('foo',1,2);
115 LOCK TABLE t1 WRITE;
116 --error ER_DUP_ENTRY
117 ALTER TABLE t1 ADD UNIQUE KEY (f1);
118 ALTER TABLE t1 ADD KEY (f2);
119 DROP TABLE t1;
120
121
122 --echo #
123 --echo # MDEV-10748 Server crashes in ha_maria::implicit_commit upon ALTER TABLE
124 --echo #
125
126 CREATE TABLE t1 (a INT, b INT) ENGINE=Aria;
127 SELECT * FROM t1;
128 CREATE TABLE t2 (c INT) ENGINE=Aria;
129
130 LOCK TABLE t2 READ, t1 WRITE;
131 --error ER_DUP_FIELDNAME
132 ALTER TABLE t1 CHANGE b a INT;
133
134 # Cleanup
135 UNLOCK TABLES;
136 DROP TABLE t1, t2;
137
138 --echo #
139 --echo # MDEV-10748 Server crashes in ha_maria::implicit_commit upon ALTER TABLE
140 --echo #
141
142 CREATE TABLE t1 (a INT) ENGINE=Aria;
143 CREATE TABLE t2 (b INT) ENGINE=Aria;
144
145 LOCK TABLES t1 WRITE, t2 AS t2a WRITE, t2 WRITE;
146 ALTER TABLE t2 CHANGE b c VARBINARY(30000), ALGORITHM=COPY;
147 UNLOCK TABLES;
148 DROP TABLE t1, t2;
149
150 --echo # More complex test, from RQG
151
152 CREATE TABLE t1 (a INT) ENGINE=Aria;
153 CREATE TABLE t2 (b INT) ENGINE=Aria;
154 CREATE OR REPLACE VIEW v2 AS SELECT * FROM t2 ;
155
156 LOCK TABLES t1 WRITE, t2 AS t2a WRITE, v2 WRITE CONCURRENT, t2 WRITE;
157
158 ALTER TABLE t1 FORCE;
159 --error ER_ALTER_OPERATION_NOT_SUPPORTED
160 ALTER TABLE t2 CHANGE b c VARBINARY(30000), ALGORITHM=INPLACE;
161 ALTER TABLE t2 CHANGE b c VARBINARY(30000), ALGORITHM=COPY;
162
163 UNLOCK TABLES;
164 DROP VIEW v2;
165 DROP TABLE t1, t2;
166
167 --echo # End of 10.2 tests
168
169 --echo #
170 --echo # MDEV-14669 Assertion `file->trn == trn' failed in ha_maria::start_stmt
171 --echo #
172
173 CREATE TABLE t1 (i INT) ENGINE=Aria;
174 INSERT INTO t1 VALUES (1),(2);
175 CREATE TABLE t2 (c CHAR(1)) ENGINE=Aria;
176 INSERT INTO t2 VALUES ('a'),('b');
177 --connect (con1,localhost,root,,test)
178 LOCK TABLE t1 WRITE;
179 OPTIMIZE TABLE t1;
180 --connection default
181 DELETE FROM t2 WHERE c < 1;
182 --connection con1
183 OPTIMIZE TABLE t1;
184 # Cleanup
185 --disconnect con1
186 --connection default
187 DROP TABLE t1, t2;
188
189 --echo #
190 --echo # MDEV-22829 SIGSEGV in _ma_reset_history on LOCK
191 --echo #
192
193 CREATE TABLE t1 (f1 INT) ENGINE=Aria;
194 CREATE TABLE t2 (f2 INT) ENGINE=Aria;
195 LOCK TABLES t2 WRITE, t1 WRITE;
196 INSERT INTO t1 VALUES (1);
197 --error ER_BAD_FIELD_ERROR
198 CREATE TRIGGER ai AFTER INSERT ON t1 FOR EACH ROW UPDATE t1 SET v=1 WHERE b=new.a;
199 UNLOCK TABLES;
200 DROP TABLE t1, t2;