Import SQLite 3.8.7.4.

third_party/sqlite/src/test/selectD.test

 # 2012 December 19
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 154 matching lines @@
   SELECT * 
    FROM t41
    LEFT JOIN (SELECT count(*) AS cnt, x1.d
                 FROM (t42 INNER JOIN t43 ON d=g) AS x1
                WHERE x1.d>5
                GROUP BY x1.d) AS x2
                   ON t41.b=x2.d;
 } {/.*SEARCH SUBQUERY 1 AS x2 USING AUTOMATIC.*/}
 
 finish_test