DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE t1(a INT KEY,B TEXT)ENGINE=InnoDB; explain extended select * FROM t1 x,t1 y where(x.a=2 or (x.a,x.b)in ((0,0),(5,0),(4,3))) and y.a=x.d and y.b=x.b;
DROP DATABASE test;CREATE DATABASE test;USE test; (5,0),( 4,3))) and y.a=x.d and y.b=x.b;
CREATE TABLE t1(a INT KEY,B TEXT)ENGINE=InnoDB;
explain extended select * FROM t1 x,t1 y where(x.a=2 or (x.a,x.b)in ((0,0),