diff options
Diffstat (limited to 'mysql-test/t/subselect_innodb.test')
| -rw-r--r-- | mysql-test/t/subselect_innodb.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_innodb.test b/mysql-test/t/subselect_innodb.test index a0c52196412..26ff1072e30 100644 --- a/mysql-test/t/subselect_innodb.test +++ b/mysql-test/t/subselect_innodb.test @@ -356,4 +356,16 @@ WHERE f2 >= ( drop table t1, t2, t3; +--echo # +--echo # LP BUG#1006231 crash in select_describe +--echo # + +create table t1(a1 int) ENGINE=InnoDB; +insert into t1 values (1); +explain +select 1 from t1 where 1 like (select 1 from t1 where 1 <=> (select 1 from t1 group by a1)); +select 1 from t1 where 1 like (select 1 from t1 where 1 <=> (select 1 from t1 group by a1)); +drop table t1; + + set optimizer_switch=@subselect_innodb_tmp; |