[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/analyze9.test

 # 2013 August 3
 #
 # 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 1162 matching lines @@
 # The analyzer knows that any (z=?) expression matches 20 rows. So it
 # will use index "t1z" if the estimate of hits for (x=10000 AND y<50)
 # is greater than 20 rows.
 #
 # And it should be. The analyzer has a stat4 sample as follows:
 #
 #   sample=(x=10000, y=100) nLt=(10000 10099)
 #
 # There should be no other samples that start with (x=10000). So it knows 
 # that (x=10000 AND y<50) must match somewhere between 0 and 99 rows, but
-# know more than that. Guessing less than 20 is therefore unreasonable.
+# no more than that. Guessing less than 20 is therefore unreasonable.
 #
 # At one point though, due to a problem in whereKeyStats(), the planner was
 # estimating that (x=10000 AND y<50) would match only 2 rows.
 #
 do_eqp_test 26.1.4 {
   SELECT * FROM t1 WHERE x = 10000 AND y < 50 AND z = 444;
 } {
   0 0 0 {SEARCH TABLE t1 USING INDEX t1z (z=?)}
 }
 
@@ skipping 43 matching lines @@
 }
 
 do_eqp_test 26.2.2 {
   SELECT * FROM t1 WHERE x='B' AND y>25 AND z=?;
 } {
   0 0 0 {SEARCH TABLE t1 USING INDEX i1 (x=? AND y>?)}
 }
 
 
 finish_test
-
-
-