diff options
| author | monty@mysql.com <> | 2003-12-17 17:35:34 +0200 |
|---|---|---|
| committer | monty@mysql.com <> | 2003-12-17 17:35:34 +0200 |
| commit | e0cc6799ecc831d296c568c5068947c1421fcaa5 (patch) | |
| tree | 93924b5aab311e02a0f0931cf91e67cdfad04bdf /mysql-test/r/lowercase_table.result | |
| parent | 0462f48b344633c7d88d12d9667f4bd50b91c552 (diff) | |
| parent | 30e318311b35b109d230f7184fe0be1b6e29f02b (diff) | |
| download | mariadb-git-e0cc6799ecc831d296c568c5068947c1421fcaa5.tar.gz | |
Merge with 4.0.17
Diffstat (limited to 'mysql-test/r/lowercase_table.result')
| -rw-r--r-- | mysql-test/r/lowercase_table.result | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/mysql-test/r/lowercase_table.result b/mysql-test/r/lowercase_table.result index 9c6b212a4b6..0ba4a4be945 100644 --- a/mysql-test/r/lowercase_table.result +++ b/mysql-test/r/lowercase_table.result @@ -1,6 +1,8 @@ -drop table if exists t1,t2,t3; +drop table if exists t1,t2,t3,t4,T1; create table T1 (id int primary key, Word varchar(40) not null, Index(Word)); +create table t4 (id int primary key, Word varchar(40) not null); INSERT INTO T1 VALUES (1, 'a'), (2, 'b'), (3, 'c'); +INSERT INTO T4 VALUES(1,'match'); SELECT * FROM t1; id Word 1 a @@ -12,6 +14,9 @@ id SELECT T2.id from t1 as T2 LIMIT 1; id 1 +SELECT * from t1 left join t4 on (test.t1.id= TEST.t4.id) where TEST.t1.id >= test.t4.id; +id Word id Word +1 a 1 match SELECT T2.id from t1 as t2 LIMIT 1; id 1 @@ -21,7 +26,8 @@ ALTER TABLE T2 RENAME T3; show tables like 't_'; Tables_in_test (t_) t3 -drop table t3; +t4 +drop table t3,t4; create table t1 (a int); select count(*) from T1; count(*) |