Debian Codegraph @

mysql-test/suite/innodb/t/rename_table.test

raw
1 --source include/have_innodb.inc
2 --source include/not_embedded.inc
3
4 call mtr.add_suppression("InnoDB: In RENAME TABLE table `test`.`t4` is referenced in foreign key constraints which are not compatible with the new table definition.");
5
6 CREATE DATABASE test_jfg;
7 CREATE DATABASE test_jfg2;
8 CREATE TABLE test_jfg.test (a int unsigned PRIMARY KEY) ENGINE=InnoDB;
9 RENAME TABLE test_jfg.test TO test_jfg2.test;
10
11 SELECT REPLACE(filename,'\\','/') path
12 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE filename LIKE '%test%';
13
14 DROP DATABASE test_jfg;
15
16 --source include/restart_mysqld.inc
17
18 DROP DATABASE test_jfg2;
19
20 CREATE DATABASE abc_def;
21 CREATE DATABASE abc_def2;
22
23 CREATE TABLE abc_def.test (a int unsigned PRIMARY KEY) ENGINE=InnoDB;
24 RENAME TABLE abc_def.test TO abc_def2.test1;
25
26 SELECT REPLACE(filename,'\\','/') path
27 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE filename LIKE '%test%';
28
29 DROP DATABASE abc_def;
30
31 --source include/restart_mysqld.inc
32
33 DROP DATABASE abc_def2;
34
35 call mtr.add_suppression("InnoDB: Cannot rename '.*t1.ibd' to '.*non_existing_db.*' because the target schema directory doesn't exist");
36
37 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
38 INSERT INTO t1 VALUES(100);
39 --replace_result "\\" "/"
40 --error ER_ERROR_ON_RENAME
41 RENAME TABLE t1 TO non_existing_db.t1;
42
43 --let SEARCH_PATTERN= \[ERROR\] InnoDB: Cannot rename '.*t1\.ibd' to '.*non_existing_db
44 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
45 --source include/search_pattern_in_file.inc
46
47 SET GLOBAL innodb_fast_shutdown=2;
48 --source include/restart_mysqld.inc
49
50 SELECT * FROM t1;
51 # Cleanup
52 DROP TABLE t1;
53
54 --echo #
55 --echo # MDEV-25509 Atomic DDL: Assertion `err != DB_DUPLICATE_KEY'
56 --echo # fails after previous error upon multi-RENAME
57 --echo #
58 SET FOREIGN_KEY_CHECKS= OFF;
59 CREATE TABLE t1 (pk INT PRIMARY KEY, f INT, FOREIGN KEY (f) REFERENCES t4 (x)) ENGINE=InnoDB;
60 ALTER TABLE t1 DROP KEY f;
61 CREATE TABLE t2 (a INT) ENGINE=InnoDB;
62 --error ER_ERROR_ON_RENAME
63 RENAME TABLE t1 TO t3, t3 TO t4;
64 RENAME TABLE t2 TO t3;
65 DROP TABLE t3, t1;
66 SET FOREIGN_KEY_CHECKS=DEFAULT;