[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/select7.test

 # 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.
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing compute SELECT statements and nested
@@ skipping 96 matching lines @@
 }
 
 # ticket #2347
 #
 ifcapable {subquery && compound} {
   do_test select7-5.1 {
     catchsql {
       CREATE TABLE t2(a,b);
       SELECT 5 IN (SELECT a,b FROM t2);
     }
-  } [list 1 \
-     {only a single result allowed for a SELECT that is part of an expression}]
+  } {1 {sub-select returns 2 columns - expected 1}}
   do_test select7-5.2 {
     catchsql {
       SELECT 5 IN (SELECT * FROM t2);
     }
-  } [list 1 \
-     {only a single result allowed for a SELECT that is part of an expression}]
+  } {1 {sub-select returns 2 columns - expected 1}}
   do_test select7-5.3 {
     catchsql {
       SELECT 5 IN (SELECT a,b FROM t2 UNION SELECT b,a FROM t2);
     }
-  } [list 1 \
-     {only a single result allowed for a SELECT that is part of an expression}]
+  } {1 {sub-select returns 2 columns - expected 1}}
   do_test select7-5.4 {
     catchsql {
       SELECT 5 IN (SELECT * FROM t2 UNION SELECT * FROM t2);
     }
-  } [list 1 \
-     {only a single result allowed for a SELECT that is part of an expression}]
+  } {1 {sub-select returns 2 columns - expected 1}}
 }
 
 # Verify that an error occurs if you have too many terms on a
 # compound select statement.
 #
 if {[clang_sanitize_address]==0} {
   ifcapable compound {
     if {$SQLITE_MAX_COMPOUND_SELECT>0} {
       set sql {SELECT 0}
       set result 0
@@ skipping 66 matching lines @@
   ) WHERE y=1
 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
 
 do_catchsql_test 8.2 {
   CREATE VIEW v0 as SELECT x, y FROM t01 UNION SELECT x FROM t02;
   EXPLAIN QUERY PLAN SELECT * FROM v0 WHERE x='0' OR y;
 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
 
 
 finish_test
-
-