Import SQLite 3.7.6.3.

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 386 matching lines @@
 do_test in-12.5 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
       SELECT a, b FROM t3 INTERSECT SELECT a, b FROM t2
     );
   }
 } {1 {only a single result allowed for a SELECT that is part of an expression}}
 do_test in-12.6 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
-      SELECT a FROM t3 UNION ALL SELECT a, b FROM t2
+      SELECT a, b FROM t3 UNION ALL SELECT a FROM t2
     );
   }
 } {1 {SELECTs to the left and right of UNION ALL do not have the same number of result columns}}
 do_test in-12.7 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
-      SELECT a FROM t3 UNION SELECT a, b FROM t2
+      SELECT a, b FROM t3 UNION SELECT a FROM t2
     );
   }
 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
 do_test in-12.8 {
   catchsql {
     SELECT * FROM t2 WHERE a IN (
-      SELECT a FROM t3 EXCEPT SELECT a, b FROM t2
+      SELECT a, b FROM t3 EXCEPT SELECT a FROM t2
     );
   }
 } {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 FROM t3 INTERSECT SELECT a, b FROM t2
+      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}}
 }
 
+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}}
+
 
 #------------------------------------------------------------------------
 # 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 127 matching lines @@
     SELECT * FROM a WHERE id NOT IN (SELECT id FROM b);
   }
 } {}
 
 
 do_test in-13.X {
   db nullvalue ""
 } {}
 
 finish_test