Import SQLite 3.10.2.

third_party/sqlite/src/test/select1.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 289 matching lines @@
   lappend v $msg
 } {0 {33 11}}
 do_test select1-4.3 {
   set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
   lappend v $msg
 } {0 {11 33}}
 do_test select1-4.4 {
   set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
   lappend v $msg
 } {1 {misuse of aggregate: min()}}
+do_catchsql_test select1-4.5 {
+  INSERT INTO test1(f1) SELECT f1 FROM test1 ORDER BY min(f1);
+} {1 {misuse of aggregate: min()}}
 
 # The restriction not allowing constants in the ORDER BY clause
 # has been removed.  See ticket #1768
 #do_test select1-4.5 {
 #  catchsql {
 #    SELECT f1 FROM test1 ORDER BY 8.4;
 #  }
 #} {1 {ORDER BY terms must not be non-integer constants}}
 #do_test select1-4.6 {
 #  catchsql {
@@ skipping 745 matching lines @@
   do_test select1-15.3 {
     execsql { SELECT 2 IN (SELECT a FROM t1) }
   } {1}
 }
 
 # Crash bug reported on the mailing list on 2012-02-23
 #
 do_test select1-16.1 {
   catchsql {SELECT 1 FROM (SELECT *)}
 } {1 {no tables specified}}
+
+# 2015-04-17:  assertion fix.
+do_catchsql_test select1-16.2 {
+  SELECT 1 FROM sqlite_master LIMIT 1,#1;
+} {1 {near "#1": syntax error}}
   
 finish_test