Import SQLite 3.10.2.

third_party/sqlite/src/test/limit.test

 # 2001 November 6
 #
 # 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 233 matching lines @@
 } {}
 do_test limit-6.8 {
   execsql {
     SELECT * FROM t6 LIMIT 0 OFFSET 1
   }
 } {}
 
 # Make sure LIMIT works well with compound SELECT statements.
 # Ticket #393
 #
+# EVIDENCE-OF: R-13512-64012 In a compound SELECT, only the last or
+# right-most simple SELECT may contain a LIMIT clause.
+#
+# EVIDENCE-OF: R-03782-50113 In a compound SELECT, the LIMIT clause
+# applies to the entire compound, not just the final SELECT.
+#
 ifcapable compound {
 do_test limit-7.1.1 {
   catchsql {
     SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
   }
 } {1 {LIMIT clause should come after UNION ALL not before}}
 do_test limit-7.1.2 {
   catchsql {
     SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
   }
@@ skipping 366 matching lines @@
 } {}
 do_execsql_test limit-14.6 {
   SELECT 123 LIMIT -1 OFFSET 0
 } {123}
 do_execsql_test limit-14.7 {
   SELECT 123 LIMIT -1 OFFSET 1
 } {}
 
 
 finish_test