"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/t/697697.test" (6 May 2012, 468 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 
    6 INSERT INTO t1 VALUES (1); # Note: t1 must be const table
    7 INSERT INTO t2 VALUES (1),(2);
    8 INSERT INTO t3 VALUES (1),(2);
    9 INSERT INTO t4 VALUES (1),(2);
   10 
   11 EXPLAIN 
   12 SELECT t1i
   13 FROM t1 JOIN t4 ON t1i=t4i  
   14 WHERE (t1i)  IN (  
   15    SELECT t2i
   16    FROM t2  
   17    WHERE (t2i)  IN (  
   18      SELECT t3i
   19      FROM t3  
   20      GROUP BY t3i
   21      )  
   22  );
   23 
   24 DROP TABLE t1,t2,t3,t4;
   25