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, 30 insertions, 25 deletions

diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result
index 3095d5337ed..d3657d84678 100644
--- a/mysql-test/r/alter_table.result
+++ b/mysql-test/r/alter_table.result
@@ -657,43 +657,45 @@ SELECT * FROM t1;
 v	b
 abc	5
 DROP TABLE t1;
-DROP DATABASE IF EXISTS mysqltest;
-CREATE DATABASE mysqltest;
-use mysqltest;
-DROP TABLE IF EXISTS `t1_nägel`, `t1_blüten`;
-CREATE TABLE `t1_nägel` (c1 INT);
-ALTER TABLE  `t1_nägel` RENAME `t1_blüten`;
-CREATE TABLE `t1_nägel` (c1 INT);
-ALTER TABLE  `t1_nägel` RENAME `t1_blüten`;
-ERROR 42S01: Table 't1_blЭten' already exists
-DROP TABLE   `t1_nägel`, `t1_blüten`;
-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);
-ALTER TABLE  `tt1_nägel` RENAME `tt1_blüten`;
-ERROR 42S01: Table 'tt1_blЭten' already exists
-SHOW CREATE TABLE `tt1_blüten`;
+DROP TABLE IF EXISTS `t+1`, `t+2`;
+CREATE TABLE `t+1` (c1 INT);
+ALTER TABLE  `t+1` RENAME `t+2`;
+CREATE TABLE `t+1` (c1 INT);
+ALTER TABLE  `t+1` RENAME `t+2`;
+ERROR 42S01: Table 't+2' already exists
+DROP TABLE   `t+1`, `t+2`;
+CREATE TEMPORARY TABLE `tt+1` (c1 INT);
+ALTER TABLE  `tt+1` RENAME `tt+2`;
+CREATE TEMPORARY TABLE `tt+1` (c1 INT);
+ALTER TABLE  `tt+1` RENAME `tt+2`;
+ERROR 42S01: Table 'tt+2' already exists
+SHOW CREATE TABLE `tt+1`;
+Table	Create Table
+tt+1	CREATE TEMPORARY TABLE `tt+1` (
+  `c1` int(11) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1
+SHOW CREATE TABLE `tt+2`;
 Table	Create Table
-tt1_blüten	CREATE TEMPORARY TABLE `tt1_blüten` (
+tt+2	CREATE TEMPORARY TABLE `tt+2` (
   `c1` int(11) DEFAULT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
-DROP TABLE   `tt1_nägel`, `tt1_blüten`;
+DROP TABLE   `tt+1`, `tt+2`;
 CREATE TABLE `#sql1` (c1 INT);
 CREATE TABLE `@0023sql2` (c1 INT);
 SHOW TABLES;
-Tables_in_mysqltest
+Tables_in_test
 #sql1
 @0023sql2
 RENAME TABLE `#sql1`     TO `@0023sql1`;
 RENAME TABLE `@0023sql2` TO `#sql2`;
 SHOW TABLES;
-Tables_in_mysqltest
+Tables_in_test
 #sql2
 @0023sql1
 ALTER TABLE `@0023sql1`  RENAME `#sql-1`;
 ALTER TABLE `#sql2`      RENAME `@0023sql-2`;
 SHOW TABLES;
-Tables_in_mysqltest
+Tables_in_test
 #sql-1
 @0023sql-2
 INSERT INTO `#sql-1`     VALUES (1);
@@ -702,18 +704,21 @@ DROP TABLE `#sql-1`, `@0023sql-2`;
 CREATE TEMPORARY TABLE `#sql1` (c1 INT);
 CREATE TEMPORARY TABLE `@0023sql2` (c1 INT);
 SHOW TABLES;
-Tables_in_mysqltest
+Tables_in_test
 ALTER TABLE `#sql1`      RENAME `@0023sql1`;
 ALTER TABLE `@0023sql2`  RENAME `#sql2`;
 SHOW TABLES;
-Tables_in_mysqltest
+Tables_in_test
 INSERT INTO `#sql2`      VALUES (1);
 INSERT INTO `@0023sql1`  VALUES (2);
+SHOW CREATE TABLE `#sql2`;
+Table	Create Table
+#sql2	CREATE TEMPORARY TABLE `#sql2` (
+  `c1` int(11) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1
 SHOW CREATE TABLE `@0023sql1`;
 Table	Create Table
 @0023sql1	CREATE TEMPORARY TABLE `@0023sql1` (
   `c1` int(11) DEFAULT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
 DROP TABLE `#sql2`, `@0023sql1`;
-use test;
-DROP DATABASE mysqltest;