diff options
author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-04-10 21:05:28 +0300 |
---|---|---|
committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-04-10 21:05:28 +0300 |
commit | c11f200890dd1e28320a7b7b26f7b3972cf6a786 (patch) | |
tree | 5124388a4487f309bc776ce29a80ffd8b3d94ad1 /mysql-test/t/derived.test | |
parent | 9a86ad60afb6079444ebdd37f90b514a5ef64f6e (diff) | |
download | mariadb-git-c11f200890dd1e28320a7b7b26f7b3972cf6a786.tar.gz |
A fix for a crashing bug in EXPLAIN on derived tables with a join.
Diffstat (limited to 'mysql-test/t/derived.test')
-rw-r--r-- | mysql-test/t/derived.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test index 8b8d9e4d1a2..2ce90c93bd9 100644 --- a/mysql-test/t/derived.test +++ b/mysql-test/t/derived.test @@ -41,6 +41,7 @@ CREATE TABLE t2 (a int not null); insert into t2 values(1); select * from (select * from t1 where t1.a=(select a from t2 where t2.a=t1.a)) a; select * from (select * from t1 where t1.a=(select t2.a from t2 where t2.a=t1.a) union select t1.a, t1.b from t1) a; +explain select * from (select * from t1,t2 where t1.a=t2.a) t1; drop table t1, t2; create table t1(a int not null, t char(8), index(a)); disable_query_log; |