Index: third_party/sqlite/src/test/in.test |
diff --git a/third_party/sqlite/src/test/in.test b/third_party/sqlite/src/test/in.test |
index 515e598c12e3edbba004967eb46aa7bcc286a840..3a42e84b9ab8b026620affb664a3b9a9bb53f385 100644 |
--- a/third_party/sqlite/src/test/in.test |
+++ b/third_party/sqlite/src/test/in.test |
@@ -450,28 +450,42 @@ do_test in-12.10 { |
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}} |
+} {1 {SELECTs to the left and right of UNION ALL do not have the same number of result columns}} |
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}} |
+} {1 {SELECTs to the left and right of UNION do not have the same number of result columns}} |
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}} |
+} {1 {SELECTs to the left and right of EXCEPT do not have the same number of result columns}} |
do_test in-12.13 { |
catchsql { |
SELECT * FROM t2 WHERE a IN ( |
SELECT a FROM t3 INTERSECT SELECT a, b FROM t2 |
); |
} |
+} {1 {SELECTs to the left and right of INTERSECT do not have the same number of result columns}} |
+do_test in-12.14 { |
+ catchsql { |
+ SELECT * FROM t2 WHERE a IN ( |
+ SELECT a, b 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.15 { |
+ catchsql { |
+ SELECT * FROM t2 WHERE a IN ( |
+ 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}} |
}; #ifcapable compound |
@@ -615,6 +629,12 @@ do_test in-13.14 { |
} |
} {} |
+do_test in-13.15 { |
+ catchsql { |
+ SELECT 0 WHERE (SELECT 0,0) OR (0 IN (1,2)); |
+ } |
+} {1 {only a single result allowed for a SELECT that is part of an expression}} |
+ |
do_test in-13.X { |
db nullvalue "" |