diff options
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.result | 15 |
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; |