diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-11-13 12:43:39 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-11-13 12:43:39 +0100 |
| commit | b468cd47493cb687ce38aad01ea19f719cd8491f (patch) | |
| tree | 59cb0a5ab5ca566c6ae71c436588746941bbfba3 /mysql-test | |
| parent | 441192bfb0e620b49cb58eaef96132151531fc54 (diff) | |
| download | mariadb-git-b468cd47493cb687ce38aad01ea19f719cd8491f.tar.gz | |
MDEV-5284 Assertion `!(*expr)->fixed' fails in replace_where_subcondition with IN suquery
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect_debug.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/subselect_debug.test | 10 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_debug.result b/mysql-test/r/subselect_debug.result index 54610d51d78..e3b5ff657b2 100644 --- a/mysql-test/r/subselect_debug.result +++ b/mysql-test/r/subselect_debug.result @@ -11,3 +11,10 @@ REVERSE(EXISTS(SELECT RAND() FROM t1)) 0 SET GLOBAL debug=@orig_debug; DROP TABLE t1; +create table t1 (i int); +insert into t1 values (1),(2); +select * from t1 where (i < 200 or i = 300) and i in (select i from t1); +i +1 +2 +drop table t1; diff --git a/mysql-test/t/subselect_debug.test b/mysql-test/t/subselect_debug.test index ee515733afa..3c9d8e80da8 100644 --- a/mysql-test/t/subselect_debug.test +++ b/mysql-test/t/subselect_debug.test @@ -15,3 +15,13 @@ SELECT SUM(EXISTS(SELECT RAND() FROM t1)) FROM t1; SELECT REVERSE(EXISTS(SELECT RAND() FROM t1)); SET GLOBAL debug=@orig_debug; DROP TABLE t1; + +# +# MDEV-5284 Assertion `!(*expr)->fixed' fails in replace_where_subcondition with IN suquery +# + +create table t1 (i int); +insert into t1 values (1),(2); +select * from t1 where (i < 200 or i = 300) and i in (select i from t1); +drop table t1; + |