Debian Codegraph @

mysql-test/suite/s3/alter2.test

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