Debian Codegraph @

mysql-test/suite/rpl/r/rename.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # MDEV-16229 Replication aborts with ER_VIEW_SELECT_TMPTABLE after
5 # half-failed RENAME
6 #
7 CREATE TABLE t1 (a INT);
8 CREATE TEMPORARY TABLE t1 (b INT);
9 RENAME TABLE t1 TO tmp, tmp TO t1;
10 SHOW CREATE TABLE t1;
11 Table Create Table
12 t1 CREATE TEMPORARY TABLE `t1` (
13 `b` int(11) DEFAULT NULL
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
15 CREATE VIEW v AS SELECT * FROM t1;
16 ERROR HY000: View's SELECT refers to a temporary table 't1'
17 RENAME TABLE t1 TO tmp, t1 TO t2;
18 SHOW CREATE TABLE tmp;
19 Table Create Table
20 tmp CREATE TEMPORARY TABLE `tmp` (
21 `b` int(11) DEFAULT NULL
22 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
23 SHOW CREATE TABLE t2;
24 Table Create Table
25 t2 CREATE TABLE `t2` (
26 `a` int(11) DEFAULT NULL
27 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
28 CREATE VIEW v AS SELECT * FROM tmp;
29 ERROR HY000: View's SELECT refers to a temporary table 'tmp'
30 CREATE VIEW v AS SELECT * FROM t2;
31 connection slave;
32 connection master;
33 DROP VIEW v;
34 DROP TABLE tmp;
35 DROP TABLE t2;
36 include/rpl_end.inc