diff options
| author | monty@mysql.com <> | 2004-06-25 20:13:05 +0300 |
|---|---|---|
| committer | monty@mysql.com <> | 2004-06-25 20:13:05 +0300 |
| commit | b1d08ba2b423bd6d88aaa0efaba1807f7e792a47 (patch) | |
| tree | 983268d5f30394d4fa4ffdd75cd095f6227e5170 /mysql-test/t/lowercase_table2.test | |
| parent | f6765146c1b97bbb71f79adbd275dc2b6ca79333 (diff) | |
| parent | c3eb93604085134940f89c7d12366d431ced9ea9 (diff) | |
| download | mariadb-git-b1d08ba2b423bd6d88aaa0efaba1807f7e792a47.tar.gz | |
Merge with 4.0 to get the latest bug patches to 4.1
Diffstat (limited to 'mysql-test/t/lowercase_table2.test')
| -rw-r--r-- | mysql-test/t/lowercase_table2.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_table2.test b/mysql-test/t/lowercase_table2.test index 5c479391916..a4eaeac4ef4 100644 --- a/mysql-test/t/lowercase_table2.test +++ b/mysql-test/t/lowercase_table2.test @@ -89,3 +89,14 @@ SELECT LOCATION FROM T1 WHERE EVENT_ID=2 UNION ALL SELECT LOCATION FROM T1 WHER SELECT LOCATION FROM T1 WHERE EVENT_ID=2 UNION ALL SELECT LOCATION FROM T1 WHERE EVENT_ID=3; SELECT LOCATION FROM T1 WHERE EVENT_ID=2 UNION ALL SELECT LOCATION FROM T1 WHERE EVENT_ID=3; drop table T1; + +# +# Test name conversion with ALTER TABLE / CREATE INDEX (Bug #3109) +# + +create table T1 (A int); +alter table T1 add index (A); +show tables like 'T1%'; +alter table t1 add index (A); +show tables like 't1%'; +drop table t1; |