diff options
Diffstat (limited to 'mysql-test/t/renamedb.test')
-rw-r--r-- | mysql-test/t/renamedb.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/renamedb.test b/mysql-test/t/renamedb.test new file mode 100644 index 00000000000..5cfb2ce0c12 --- /dev/null +++ b/mysql-test/t/renamedb.test @@ -0,0 +1,18 @@ +--disable_warnings +drop database if exists testdb1; +--enable_warnings + +create database testdb1 default character set latin2; +use testdb1; +create table t1 (a int); +insert into t1 values (1),(2),(3); +show create database testdb1; +show tables; +rename database testdb1 to testdb2; +--error 1049 +show create database testdb1; +show create database testdb2; +select database(); +show tables; +select a from t1 order by a; +drop database testdb2; |