Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_rename_across_database.result

raw
1 DROP TABLE IF EXISTS t1,t2,t3;
2 CREATE TABLE t1(c1 INTEGER NULL);
3 CREATE DATABASE d1;
4 CREATE TABLE d1.t2(c1 INTEGER NULL);
5 SHOW TABLES;
6 Tables_in_test
7 t1
8 SHOW CREATE TABLE t1;
9 Table Create Table
10 t1 CREATE TABLE `t1` (
11 `c1` int DEFAULT NULL
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 SHOW CREATE TABLE d1.t2;
14 Table Create Table
15 t2 CREATE TABLE `t2` (
16 `c1` int DEFAULT NULL
17 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
18 RENAME TABLE t1 TO d1.t3;
19 SHOW TABLES;
20 Tables_in_test
21 USE d1;
22 SHOW TABLES;
23 Tables_in_d1
24 t2
25 t3
26 SHOW CREATE TABLE t3;
27 Table Create Table
28 t3 CREATE TABLE `t3` (
29 `c1` int DEFAULT NULL
30 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
31 SHOW CREATE TABLE t2;
32 Table Create Table
33 t2 CREATE TABLE `t2` (
34 `c1` int DEFAULT NULL
35 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
36 DROP TABLE t2,t3;
37 SHOW TABLES;
38 Tables_in_d1
39 DROP DATABASE d1;