Debian Codegraph @

mysql-test/suite/merge/merge_innodb.test

raw
1 # t/merge_innodb.test
2 #
3 # Tests with MERGE tables over InnoDB tables
4 #
5
6 --source include/have_innodb.inc
7
8 --disable_warnings
9 DROP TABLE IF EXISTS t1, t2, t3, t4, t5;
10 --enable_warnings
11
12 #
13 # Bug#30491 - MERGE doesn't report error when one table is Innodb
14 #
15 CREATE TABLE t1 (c1 varchar(100)) ENGINE=MyISAM;
16 CREATE TABLE t2 (c1 varchar(100)) ENGINE=MyISAM;
17 CREATE TABLE t3 (c1 varchar(100)) ENGINE=InnoDB;
18 INSERT INTO t1 VALUES ('Ann'), ('Alice');
19 INSERT INTO t2 VALUES ('Bob'), ('Brian');
20 INSERT INTO t3 VALUES ('Chris'), ('Charlie');
21 CREATE TABLE t4 (c1 varchar(100)) ENGINE=MRG_MYISAM UNION=(t1,t2)
22 INSERT_METHOD=LAST;
23 CREATE TABLE t5 (c1 varchar(100)) ENGINE=MRG_MYISAM UNION=(t1,t3)
24 INSERT_METHOD=LAST;
25 --error ER_WRONG_MRG_TABLE
26 SELECT * FROM t5;
27 SELECT * FROM t4;
28 ALTER TABLE t2 ENGINE=InnoDB;
29 --error ER_WRONG_MRG_TABLE
30 SELECT * FROM t4;
31 DELETE FROM t2 LIMIT 1;
32 --error ER_WRONG_MRG_TABLE
33 SELECT * FROM t4;
34 --error ER_WRONG_MRG_TABLE
35 INSERT INTO t4 VALUES ('Beware');
36 --error ER_WRONG_MRG_TABLE
37 SELECT * FROM t4;
38 SELECT * FROM t2;
39 SELECT * FROM t1;
40 DROP TABLE t1, t2, t3, t4, t5;
41
42 #
43 # Bug#20691429 temporary merge over view under lock tables
44 #
45 create table t1 (c1 varchar(100));
46 create table t2 (c1 varchar(100));
47 create view t3 as select * from t1;
48 insert into t1 values ('ann'), ('alice');
49 insert into t2 values ('bob'), ('brian');
50 create temporary table t4 (c1 varchar(100)) engine=MERGE union=(t2, t1);
51 create temporary table t5 (c1 varchar(100)) engine=MERGE union=(t3, t1);
52 --error ER_WRONG_MRG_TABLE
53 select * from t5;
54 lock tables t1 read, t2 read, t3 read, t4 read;
55 --error ER_WRONG_MRG_TABLE
56 select * from t5;
57 select * from t4;
58 unlock tables;
59 drop table t2;
60 create view t2 as select * from t1;
61 --error ER_WRONG_MRG_TABLE
62 select * from t4;
63 lock tables t1 read, t2 read, t3 read;
64 --error ER_WRONG_MRG_TABLE
65 select * from t4;
66 --error ER_WRONG_MRG_TABLE
67 select * from t4;
68 --error ER_WRONG_MRG_TABLE
69 select * from t4;
70 unlock tables;
71 drop view t2, t3;
72 drop table t1;