diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2005-01-25 10:58:30 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2005-01-25 10:58:30 +0400 |
| commit | b7b042689c566fc91a0c1ef2a2345ce964e6d191 (patch) | |
| tree | 8a0fd8ee71f16e499906da7bb2014823ccde471a /mysql-test/r/lowercase_table2.result | |
| parent | 9f7f6ed2c94d2e44bf5c5adf620a2b9e39887d67 (diff) | |
| download | mariadb-git-b7b042689c566fc91a0c1ef2a2345ce964e6d191.tar.gz | |
Test case (bug #7261: Alter table loses temp table with lower_case_table_names=2).
Diffstat (limited to 'mysql-test/r/lowercase_table2.result')
| -rw-r--r-- | mysql-test/r/lowercase_table2.result | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/mysql-test/r/lowercase_table2.result b/mysql-test/r/lowercase_table2.result index 3be73f6cc6a..cfd8f78a77c 100644 --- a/mysql-test/r/lowercase_table2.result +++ b/mysql-test/r/lowercase_table2.result @@ -1,4 +1,4 @@ -DROP TABLE IF EXISTS t1,t2,T1,T2,t3,T3; +DROP TABLE IF EXISTS t1,t2,T1,T2,t3,T3,tT; DROP DATABASE IF EXISTS `TEST_$1`; DROP DATABASE IF EXISTS `test_$1`; CREATE TABLE T1 (a int); @@ -131,3 +131,13 @@ show tables like 't1%'; Tables_in_test (t1%) t1 drop table t1; +create temporary table tT(a int(11), b varchar(8)); +insert into tT values (1, 'abc'); +select * from tT; +a b +1 abc +alter table tT add index (a); +select * from tT; +a b +1 abc +drop table tT; |