EVOLUTION-MANAGER

Edit File: commit_index_end_1.result

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;