[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/e_select.test

 # 2010 July 16
 #
 # 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 1234 matching lines @@
   4.2 "SELECT DISTINCT x FROM h1, h2 ON (x=b)" {One Four}
 } 
 
 # EVIDENCE-OF: R-02054-15343 For the purposes of detecting duplicate
 # rows, two NULL values are considered to be equal.
 #
 do_select_tests e_select-5.5 {
   1  "SELECT DISTINCT d FROM h3" {{} 2 2,3 2,4 3}
 }
 
-# EVIDENCE-OF: R-58359-52112 The normal rules for selecting a collation
-# sequence to compare text values with apply.
+# EVIDENCE-OF: R-47709-27231 The usual rules apply for selecting a
+# collation sequence to compare text values.
 #
 do_select_tests e_select-5.6 {
   1  "SELECT DISTINCT b FROM h1"                  {one I i four IV iv}
   2  "SELECT DISTINCT b COLLATE nocase FROM h1"   {one I four IV}
   3  "SELECT DISTINCT x FROM h2"                  {One Two Three Four}
   4  "SELECT DISTINCT x COLLATE binary FROM h2"   {
     One Two Three Four one two three four
   }
 }
 
@@ skipping 899 matching lines @@
 
   8  { SELECT b FROM f1 ORDER BY a LIMIT 20, 10 } {u v w x y z}
   9  { SELECT a FROM f1 ORDER BY a DESC LIMIT 18+4, 100 } {4 3 2 1}
 
   10 { SELECT b FROM f1 ORDER BY a LIMIT -1, 5 } {a b c d e}
   11 { SELECT b FROM f1 ORDER BY a LIMIT -500, 5 } {a b c d e}
   12 { SELECT b FROM f1 ORDER BY a LIMIT 0, 5 } {a b c d e}
 }
 
 finish_test