summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb_bugs/r/commit_index_end_1.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/r/commit_index_end_1.result')
-rw-r--r--storage/tokudb/mysql-test/tokudb_bugs/r/commit_index_end_1.result15
1 files changed, 15 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/commit_index_end_1.result b/storage/tokudb/mysql-test/tokudb_bugs/r/commit_index_end_1.result
new file mode 100644
index 00000000000..7e63c6a8a73
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb_bugs/r/commit_index_end_1.result
@@ -0,0 +1,15 @@
+drop table if exists t1,t2,t3;
+SET NAMES latin1;
+CREATE TABLE t1 (a INT) ENGINE=TokuDB;
+INSERT INTO t1 VALUES (1),(2);
+CREATE TABLE t2 (b INT) ENGINE=TokuDB;
+INSERT INTO t2 VALUES (3),(4);
+CREATE TABLE t3 (c VARCHAR(3), INDEX(c)) ENGINE=TokuDB;
+INSERT INTO t3 VALUES ('foo'),('bar');
+EXPLAIN SELECT * FROM t1
+WHERE a IN ( SELECT b FROM t2 ) OR ( 'qux' ) IN ( SELECT c FROM t3 );
+id select_type table type possible_keys key key_len ref rows Extra
+1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where
+3 SUBQUERY t3 index_subquery c c 6 const 0 Using index; Using where
+2 MATERIALIZED t2 ALL NULL NULL NULL NULL 2
+drop table if exists t1,t2,t3;