[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/analyzeD.test

-# 2005 July 22
+# 2014-10-04
 #
 # 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.
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.
 # This file implements tests for the ANALYZE command.
 #
-# $Id: analyze.test,v 1.9 2008/08/11 18:44:58 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
 set ::testprefix analyzeD
 
 ifcapable {!stat4} {
   finish_test
   return
 }
 
@@ skipping 43 matching lines @@
   0 0 0 {SEARCH TABLE t1 USING INDEX t1_c (c=?)}
 }
 
 do_test 1.3 {
   execsql { DELETE FROM sqlite_stat1 }
   db close
   sqlite3 db test.db
 } {}
 
 # Without stat1, because 3001 is larger than all samples in the stat4
-# table, SQLite things that a=3001 matches just 1 row. So it (incorrectly)
+# table, SQLite thinks that a=3001 matches just 1 row. So it (incorrectly)
 # chooses it over the c=150 index (5 rows). Even with stat1 data, things
 # worked this way before commit [e6f7f97dbc].
 #
 do_eqp_test 1.4 {
   SELECT * FROM t1 WHERE a=3001 AND c=150;
 } {
   0 0 0 {SEARCH TABLE t1 USING INDEX t1_ab (a=?)}
 }
 
 do_test 1.5 {
@@ skipping 18 matching lines @@
 # Same test as 1.4, except this time the 7 rows that match the a=? condition 
 # do not feature larger values than all rows in the stat4 table. So SQLite
 # gets this right, even without stat1 data.
 do_eqp_test 1.8 {
   SELECT * FROM t1 WHERE a=13 AND c=150;
 } {
   0 0 0 {SEARCH TABLE t1 USING INDEX t1_c (c=?)}
 }
 
 finish_test
-