Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1(c1 INTEGER NULL);
3 CREATE TABLE t2(c1 INTEGER NULL);
4 SHOW TABLES;
5 Tables_in_test
6 t1
7 t2
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 RENAME TABLE t2 TO t1;
14 ERROR 42S01: Table 't1' already exists
15 RENAME TABLE t3 TO t1;
16 ERROR 42S01: Table 't1' already exists
17 RENAME TABLE t3 TO doesnotexist.t1;
18 ERROR 42000: Unknown database 'doesnotexist'
19 SHOW TABLES;
20 Tables_in_test
21 t1
22 t2
23 SHOW CREATE TABLE t1;
24 Table Create Table
25 t1 CREATE TABLE `t1` (
26 `c1` int DEFAULT NULL
27 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
28 SHOW CREATE TABLE t2;
29 Table Create Table
30 t2 CREATE TABLE `t2` (
31 `c1` int DEFAULT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 DROP TABLE t2;
34 SHOW TABLES;
35 Tables_in_test
36 t1
37 DROP TABLE t1;