Import SQLite 3.8.7.4.

third_party/sqlite/src/test/selectC.test

 # 2008 September 16
 #
 # 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 133 matching lines @@
 do_test selectC-1.14.2 {
   execsql {
     SELECT uppercaseconversionfunctionwithaverylongname(b) AS x
       FROM t1
      ORDER BY x DESC
   }
 } {CCC AAA AAA}
 
 # The following query used to leak memory.  Verify that has been fixed.
 #
-ifcapable trigger {
+ifcapable trigger&&compound {
   do_test selectC-2.1 {
     catchsql {
       CREATE TABLE t21a(a,b);
       INSERT INTO t21a VALUES(1,2);
       CREATE TABLE t21b(n);
       CREATE TRIGGER r21 AFTER INSERT ON t21b BEGIN
         SELECT a FROM t21a WHERE a>new.x UNION ALL
         SELECT b FROM t21a WHERE b>new.x ORDER BY 1 LIMIT 2;
       END;
       INSERT INTO t21b VALUES(6);
@@ skipping 62 matching lines @@
 
 do_execsql_test selectC-4.2 {
   select a from (select distinct a, b from t_distinct_bug)
 } {1 1 1}
 
 do_execsql_test selectC-4.3 {
   select a, udf() from (select distinct a, b from t_distinct_bug)
 } {1 1 1 2 1 3}
 
 finish_test