Debian Codegraph @

mysql-test/suite/s3/alter2.result

raw
1 #
2 # MDEV-19575 Assertion `page_st == 1' failed upon SELECT from S3
3 # table which is being converted into Aria
4 #
5 CREATE TABLE t1 (f INT);
6 insert into t1 values (1),(2);
7 ALTER TABLE t1 ENGINE=S3;
8 select * from t1;
9 f
10 1
11 2
12 connect con1,localhost,root,,$database;
13 ALTER TABLE t1 ENGINE=Aria;
14 connection default;
15 SELECT * FROM t1;
16 f
17 1
18 2
19 connection con1;
20 disconnect con1;
21 connection default;
22 DROP TABLE t1;
23 #
24 # MDEV-20302 Server hangs upon concurrent SELECT from partitioned S3
25 # table
26 #
27 CREATE TABLE t1 (
28 pk INT AUTO_INCREMENT,
29 c CHAR(12),
30 PRIMARY KEY(pk),
31 KEY(c)
32 ) ENGINE=Aria
33 PARTITION BY KEY(pk) PARTITIONS 2;
34 CREATE VIEW v1 AS SELECT * FROM t1;
35 INSERT INTO t1 VALUES (NULL,'ill'),(NULL,'loop');
36 ALTER TABLE t1 ENGINE=S3;
37 connect con1,localhost,root,,$database;
38 SELECT * FROM t1 WHERE c BETWEEN 'bar' AND 'foo';
39 connection default;
40 SELECT pk FROM v1;
41 pk
42 1
43 2
44 connection con1;
45 pk c
46 disconnect con1;
47 connection default;
48 DROP VIEW v1;
49 DROP TABLE t1;