summaryrefslogtreecommitdiff
path: root/mysql-test/t/derived.test
diff options
context:
space:
mode:
authorSinisa@sinisa.nasamreza.org <>2003-04-10 21:05:28 +0300
committerSinisa@sinisa.nasamreza.org <>2003-04-10 21:05:28 +0300
commit47f67214d98c854f05b31bde72e0ec57440e8561 (patch)
tree5124388a4487f309bc776ce29a80ffd8b3d94ad1 /mysql-test/t/derived.test
parent3cef0070f9529b281d6380f27fa1a3c9f863b8a0 (diff)
downloadmariadb-git-47f67214d98c854f05b31bde72e0ec57440e8561.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;