Bug#18775 - Temporary table from alter table visible to other threads

New test cases. Names with umlauts don't compare well on Windows.


mysql-test/r/alter_table.result:
  Bug#18775 - Temporary table from alter table visible to other threads
  New test results
mysql-test/r/backup.result:
  Bug#18775 - Temporary table from alter table visible to other threads
  New test results
mysql-test/t/alter_table.test:
  Bug#18775 - Temporary table from alter table visible to other threads
  New test case. Names with umlauts don't compare well on Windows.
mysql-test/t/backup.test:
  Bug#18775 - Temporary table from alter table visible to other threads
  New test case. Names with umlauts don't compare well on Windows.

1 files changed, 15 insertions, 24 deletions

diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test
index f6af92e0044..168d011a2ac 100644
--- a/mysql-test/t/alter_table.test
+++ b/mysql-test/t/alter_table.test
@@ -488,32 +488,26 @@ DROP TABLE t1;
 #
 # Bug#18775 - Temporary table from alter table visible to other threads
 #
-# Use a special database to avoid name clashes with user tables.
+# Check if special characters work and duplicates are detected.
 --disable_warnings
-DROP DATABASE IF EXISTS mysqltest;
+DROP TABLE IF EXISTS `t+1`, `t+2`;
 --enable_warnings
-CREATE DATABASE mysqltest;
-use mysqltest;
-#
-# Check if non-ASCII alphabetic characters work and duplicates are detected.
---disable_warnings
-DROP TABLE IF EXISTS `t1_nägel`, `t1_blüten`;
---enable_warnings
-CREATE TABLE `t1_nägel` (c1 INT);
-ALTER TABLE  `t1_nägel` RENAME `t1_blüten`;
-CREATE TABLE `t1_nägel` (c1 INT);
+CREATE TABLE `t+1` (c1 INT);
+ALTER TABLE  `t+1` RENAME `t+2`;
+CREATE TABLE `t+1` (c1 INT);
 --error ER_TABLE_EXISTS_ERROR
-ALTER TABLE  `t1_nägel` RENAME `t1_blüten`;
-DROP TABLE   `t1_nägel`, `t1_blüten`;
+ALTER TABLE  `t+1` RENAME `t+2`;
+DROP TABLE   `t+1`, `t+2`;
 #
 # Same for temporary tables though these names do not become file names.
-CREATE TEMPORARY TABLE `tt1_nägel` (c1 INT);
-ALTER TABLE  `tt1_nägel` RENAME `tt1_blüten`;
-CREATE TEMPORARY TABLE `tt1_nägel` (c1 INT);
+CREATE TEMPORARY TABLE `tt+1` (c1 INT);
+ALTER TABLE  `tt+1` RENAME `tt+2`;
+CREATE TEMPORARY TABLE `tt+1` (c1 INT);
 --error ER_TABLE_EXISTS_ERROR
-ALTER TABLE  `tt1_nägel` RENAME `tt1_blüten`;
-SHOW CREATE TABLE `tt1_blüten`;
-DROP TABLE   `tt1_nägel`, `tt1_blüten`;
+ALTER TABLE  `tt+1` RENAME `tt+2`;
+SHOW CREATE TABLE `tt+1`;
+SHOW CREATE TABLE `tt+2`;
+DROP TABLE   `tt+1`, `tt+2`;
 #
 # Check if special characters as in tmp_file_prefix work.
 CREATE TABLE `#sql1` (c1 INT);
@@ -538,10 +532,7 @@ ALTER TABLE `@0023sql2`  RENAME `#sql2`;
 SHOW TABLES;
 INSERT INTO `#sql2`      VALUES (1);
 INSERT INTO `@0023sql1`  VALUES (2);
+SHOW CREATE TABLE `#sql2`;
 SHOW CREATE TABLE `@0023sql1`;
 DROP TABLE `#sql2`, `@0023sql1`;
-#
-# Cleanup
-use test;
-DROP DATABASE mysqltest;