summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect_debug.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/subselect_debug.result')
-rw-r--r--mysql-test/r/subselect_debug.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_debug.result b/mysql-test/r/subselect_debug.result
index 1d54369530b..9be53ae0473 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_dbug=@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;