summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect_innodb.test
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2012-06-04 17:26:11 +0200
committerSergei Golubchik <sergii@pisem.net>2012-06-04 17:26:11 +0200
commit3e3606d21deec2a7508d47740ab7a7a7f5b9b698 (patch)
tree5e041eb2fc7ca4f15ff97bfc3dba62840ab802fc /mysql-test/t/subselect_innodb.test
parentafedd72e225654225b20a91b072b012e4c57a9d4 (diff)
parent25ada13db06d06050f0361bc434fe2b58303b5f2 (diff)
downloadmariadb-git-3e3606d21deec2a7508d47740ab7a7a7f5b9b698.tar.gz
merge with 5.3.
Take only test cases from MDEV-136 Non-blocking "set read_only"
Diffstat (limited to 'mysql-test/t/subselect_innodb.test')
-rw-r--r--mysql-test/t/subselect_innodb.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_innodb.test b/mysql-test/t/subselect_innodb.test
index e390c9e2211..3af8f31062c 100644
--- a/mysql-test/t/subselect_innodb.test
+++ b/mysql-test/t/subselect_innodb.test
@@ -365,4 +365,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;