diff options
| author | unknown <bar@mysql.com> | 2006-02-17 13:19:26 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2006-02-17 13:19:26 +0400 |
| commit | 36a0a13da780412c17ce6ad71cd8e76a1868f7df (patch) | |
| tree | a47a6635f1860c55851d3e7a687582bbf16fd53c | |
| parent | 83c1f257ece386c8038fb59b4abed8ad25325a9d (diff) | |
| download | mariadb-git-36a0a13da780412c17ce6ad71cd8e76a1868f7df.tar.gz | |
upgrade.result, upgrade.test:
new file:
Adding a test case for "Migration tool for 5.1 table name encoding"
| -rw-r--r-- | mysql-test/r/upgrade.result | 43 | ||||
| -rw-r--r-- | mysql-test/t/upgrade.test | 28 |
2 files changed, 71 insertions, 0 deletions
diff --git a/mysql-test/r/upgrade.result b/mysql-test/r/upgrade.result new file mode 100644 index 00000000000..f7c8e8cdfa0 --- /dev/null +++ b/mysql-test/r/upgrade.result @@ -0,0 +1,43 @@ +drop database if exists `testdb1`; +drop database if exists `testdb-1`; +drop database if exists `#mysql50#testdb-1`; +create database `testdb1`; +create database `#mysql50#testdb-1`; +create table `testdb1`.`t1` (a int); +create table `testdb1`.`#mysql50#t-1` (a int); +create table `#mysql50#testdb-1`.`t1` (a int); +create table `#mysql50#testdb-1`.`#mysql50#t-1` (a int); +show create database `testdb1`; +Database Create Database +testdb1 CREATE DATABASE `testdb1` /*!40100 DEFAULT CHARACTER SET latin1 */ +show create database `testdb-1`; +ERROR 42000: Unknown database 'testdb-1' +show create database `#mysql50#testdb-1`; +Database Create Database +#mysql50#testdb-1 CREATE DATABASE `#mysql50#testdb-1` /*!40100 DEFAULT CHARACTER SET latin1 */ +show tables in `testdb1`; +Tables_in_testdb1 +#mysql50#t-1 +t1 +show tables in `#mysql50#testdb-1`; +Tables_in_#mysql50#testdb-1 +#mysql50#t-1 +t1 +show create database `testdb1`; +Database Create Database +testdb1 CREATE DATABASE `testdb1` /*!40100 DEFAULT CHARACTER SET latin1 */ +show create database `testdb-1`; +Database Create Database +testdb-1 CREATE DATABASE `testdb-1` /*!40100 DEFAULT CHARACTER SET latin1 */ +show create database `#mysql50#testdb-1`; +ERROR 42000: Unknown database '#mysql50#testdb-1' +show tables in `testdb1`; +Tables_in_testdb1 +t1 +t-1 +show tables in `testdb-1`; +Tables_in_testdb-1 +t1 +t-1 +drop database `testdb1`; +drop database `testdb-1`; diff --git a/mysql-test/t/upgrade.test b/mysql-test/t/upgrade.test new file mode 100644 index 00000000000..826f486e4c0 --- /dev/null +++ b/mysql-test/t/upgrade.test @@ -0,0 +1,28 @@ +--disable_warnings +drop database if exists `testdb1`; +drop database if exists `testdb-1`; +drop database if exists `#mysql50#testdb-1`; +--enable_warnings +create database `testdb1`; +create database `#mysql50#testdb-1`; +create table `testdb1`.`t1` (a int); +create table `testdb1`.`#mysql50#t-1` (a int); +create table `#mysql50#testdb-1`.`t1` (a int); +create table `#mysql50#testdb-1`.`#mysql50#t-1` (a int); +show create database `testdb1`; +--error 1049 +show create database `testdb-1`; +show create database `#mysql50#testdb-1`; +show tables in `testdb1`; +show tables in `#mysql50#testdb-1`; + +--exec $MYSQL_CHECK --all-databases --fix-db-names --fix-table-names + +show create database `testdb1`; +show create database `testdb-1`; +--error 1049 +show create database `#mysql50#testdb-1`; +show tables in `testdb1`; +show tables in `testdb-1`; +drop database `testdb1`; +drop database `testdb-1`; |