Import SQLite 3.8.7.4.

third_party/sqlite/src/test/in.test

 # 2001 September 15
 #
 # 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 240 matching lines @@
 do_test in-7.4 {
   execsql {
     SELECT a FROM t1 WHERE a IN (5) AND b IN ();
   }
 } {}
 do_test in-7.5 {
   execsql {
     SELECT a FROM t1 WHERE a IN (5) AND b NOT IN ();
   }
 } {5}
-do_test in-7.6 {
+do_test in-7.6.1 {
   execsql {
     SELECT a FROM ta WHERE a IN ();
   }
 } {}
+do_test in-7.6.2 {
+  db status step
+} {0}
 do_test in-7.7 {
   execsql {
     SELECT a FROM ta WHERE a NOT IN ();
   }
 } {1 2 3 4 6 8 10}
 
+do_test in-7.8.1 {
+  execsql {
+    SELECT * FROM ta LEFT JOIN tb ON (ta.b=tb.b) WHERE ta.a IN ();
+  }
+} {}
+do_test in-7.8.2 {
+  db status step
+} {0}
+
 do_test in-8.1 {
   execsql {
     SELECT b FROM t1 WHERE a IN ('hello','there')
   }
 } {world}
 do_test in-8.2 {
   execsql {
     SELECT b FROM t1 WHERE a IN ("hello",'there')
   }
 } {world}
@@ skipping 31 matching lines @@
       CHECK( a IN (111,222,333) )
     );
     INSERT INTO t5 VALUES(111);
     SELECT * FROM t5;
   }
 } {111}
 do_test in-10.2 {
   catchsql {
     INSERT INTO t5 VALUES(4);
   }
-} {1 {constraint failed}}
+} {1 {CHECK constraint failed: t5}}
 
 # Ticket #1821
 #
 # Type affinity applied to the right-hand side of an IN operator.
 #
 do_test in-11.1 {
   execsql {
     CREATE TABLE t6(a,b NUMERIC);
     INSERT INTO t6 VALUES(1,2);
     INSERT INTO t6 VALUES(2,3);
@@ skipping 90 matching lines @@
 } {1 {SELECTs to the left and right of EXCEPT do not have the same number of result columns}}
 do_test in-12.9 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
       SELECT a, b FROM t3 INTERSECT SELECT a FROM t2
     );
   }
 } {1 {SELECTs to the left and right of INTERSECT do not have the same number of result columns}}
 }
 
+ifcapable compound {
 do_test in-12.10 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
       SELECT a FROM t3 UNION ALL SELECT a, b FROM t2
     );
   }
 } {1 {only a single result allowed for a SELECT that is part of an expression}}
 do_test in-12.11 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
       SELECT a FROM t3 UNION SELECT a, b FROM t2
     );
   }
 } {1 {only a single result allowed for a SELECT that is part of an expression}}
 do_test in-12.12 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
       SELECT a FROM t3 EXCEPT SELECT a, b FROM t2
     );
   }
 } {1 {only a single result allowed for a SELECT that is part of an expression}}
 do_test in-12.13 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
       SELECT a FROM t3 INTERSECT SELECT a, b FROM t2
     );
   }
 } {1 {only a single result allowed for a SELECT that is part of an expression}}
+}; #ifcapable compound
 
 
 #------------------------------------------------------------------------
 # The following tests check that NULL is handled correctly when it 
 # appears as part of a set of values on the right-hand side of an
 # IN or NOT IN operator.
 #
 # When it appears in such a set, NULL is handled as an "unknown value".
 # If, because of the unknown value in the set, the result of the expression 
 # cannot be determined, then it itself evaluates to NULL.
@@ skipping 128 matching lines @@
     SELECT * FROM a WHERE id NOT IN (SELECT id FROM b);
   }
 } {}
 
 
 do_test in-13.X {
   db nullvalue ""
 } {}
 
 finish_test