From 36a0a13da780412c17ce6ad71cd8e76a1868f7df Mon Sep 17 00:00:00 2001
From: unknown <bar@mysql.com>
Date: Fri, 17 Feb 2006 13:19:26 +0400
Subject: upgrade.result, upgrade.test:   new file:   Adding a test case for
 "Migration tool for 5.1 table name encoding"

---
 mysql-test/t/upgrade.test | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 mysql-test/t/upgrade.test

(limited to 'mysql-test/t/upgrade.test')

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`;
-- 
cgit v1.2.1