diff options
| author | unknown <bar@mysql.com> | 2006-02-13 11:49:28 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2006-02-13 11:49:28 +0400 |
| commit | 3d608969e6ed05282dce90f2cb07cfd228d21c2c (patch) | |
| tree | 7556874a6f6490a8cd49f55fe0c7ed08d7f14167 /mysql-test/r/renamedb.result | |
| parent | 254ecc6a091dfe869680918f709e101d87baa3e7 (diff) | |
| download | mariadb-git-3d608969e6ed05282dce90f2cb07cfd228d21c2c.tar.gz | |
renamedb.test, renamedb.result:
new file
Many files:
WL#757 RENAME DATABASE
sql/mysql_priv.h:
WL#757 RENAME DATABASE
sql/mysqld.cc:
WL#757 RENAME DATABASE
sql/sql_db.cc:
WL#757 RENAME DATABASE
sql/sql_lex.h:
WL#757 RENAME DATABASE
sql/sql_parse.cc:
WL#757 RENAME DATABASE
sql/sql_rename.cc:
WL#757 RENAME DATABASE
sql/sql_table.cc:
WL#757 RENAME DATABASE
sql/sql_yacc.yy:
WL#757 RENAME DATABASE
Diffstat (limited to 'mysql-test/r/renamedb.result')
| -rw-r--r-- | mysql-test/r/renamedb.result | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/renamedb.result b/mysql-test/r/renamedb.result new file mode 100644 index 00000000000..26ae42e72aa --- /dev/null +++ b/mysql-test/r/renamedb.result @@ -0,0 +1,29 @@ +drop database if exists testdb1; +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; +Database Create Database +testdb1 CREATE DATABASE `testdb1` /*!40100 DEFAULT CHARACTER SET latin2 */ +show tables; +Tables_in_testdb1 +t1 +rename database testdb1 to testdb2; +show create database testdb1; +ERROR 42000: Unknown database 'testdb1' +show create database testdb2; +Database Create Database +testdb2 CREATE DATABASE `testdb2` /*!40100 DEFAULT CHARACTER SET latin2 */ +select database(); +database() +testdb2 +show tables; +Tables_in_testdb2 +t1 +select a from t1 order by a; +a +1 +2 +3 +drop database testdb2; |