[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/subselect.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 22 matching lines @@
     INSERT INTO t1 VALUES(5,6);
   }
   execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
 } {3 4}
 
 # Try a select with more than one result column.
 #
 do_test subselect-1.2 {
   set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
   lappend v $msg
-} {1 {only a single result allowed for a SELECT that is part of an expression}}
+} {1 {row value misused}}
 
 # A subselect without an aggregate.
 #
 do_test subselect-1.3a {
   execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
 } {2}
 do_test subselect-1.3b {
   execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
 } {4}
 do_test subselect-1.3c {
@@ skipping 147 matching lines @@
     SELECT a FROM t4 WHERE b IN (SELECT b FROM t4 ORDER BY b LIMIT 1);
   }
 } {a}
 do_test subselect-4.3 {
   execsql {
     SELECT a FROM t4 WHERE b IN (SELECT b FROM t4 ORDER BY b DESC LIMIT 1);
   }
 } {c}
 
 finish_test