"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/697697.result" (6 May 2012, 715 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 CREATE TABLE t1 (t1i int);
    2 CREATE TABLE t2 (t2i int);
    3 CREATE TABLE t3 (t3i int);
    4 CREATE TABLE t4 (t4i int);
    5 INSERT INTO t1 VALUES (1);
    6 INSERT INTO t2 VALUES (1),(2);
    7 INSERT INTO t3 VALUES (1),(2);
    8 INSERT INTO t4 VALUES (1),(2);
    9 EXPLAIN 
   10 SELECT t1i
   11 FROM t1 JOIN t4 ON t1i=t4i  
   12 WHERE (t1i)  IN (  
   13 SELECT t2i
   14 FROM t2  
   15 WHERE (t2i)  IN (  
   16 SELECT t3i
   17 FROM t3  
   18 GROUP BY t3i
   19 )  
   20 );
   21 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   22 1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	1	Using where
   23 1	PRIMARY	t4	ALL	NULL	NULL	NULL	NULL	2	Using where; Using join buffer
   24 2	SUBQUERY	t2	ALL	NULL	NULL	NULL	NULL	2	Using where
   25 3	SUBQUERY	t3	ALL	NULL	NULL	NULL	NULL	2	Using temporary; Using filesort
   26 DROP TABLE t1,t2,t3,t4;