From b468cd47493cb687ce38aad01ea19f719cd8491f Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Wed, 13 Nov 2013 12:43:39 +0100 Subject: MDEV-5284 Assertion `!(*expr)->fixed' fails in replace_where_subcondition with IN suquery --- mysql-test/r/subselect_debug.result | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'mysql-test/r/subselect_debug.result') 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; -- cgit v1.2.1