summaryrefslogtreecommitdiff
path: root/mysql-test/t/derived.test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2003-04-10 21:05:28 +0300
committerunknown <Sinisa@sinisa.nasamreza.org>2003-04-10 21:05:28 +0300
commitc11f200890dd1e28320a7b7b26f7b3972cf6a786 (patch)
tree5124388a4487f309bc776ce29a80ffd8b3d94ad1 /mysql-test/t/derived.test
parent9a86ad60afb6079444ebdd37f90b514a5ef64f6e (diff)
downloadmariadb-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.test1
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;