Import SQLite 3.8.7.4.

third_party/sqlite/src/test/analyze4.test

 # 2011 January 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.
 #
 #***********************************************************************
@@ skipping 20 matching lines @@
     INSERT INTO t1 SELECT a+4, b FROM t1;
     INSERT INTO t1 SELECT a+8, b FROM t1;
     INSERT INTO t1 SELECT a+16, b FROM t1;
     INSERT INTO t1 SELECT a+32, b FROM t1;
     INSERT INTO t1 SELECT a+64, b FROM t1;
     ANALYZE;
   }
 
   # Should choose the t1a index since it is more specific than t1b.
   db eval {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE a=5 AND b IS NULL}
-} {0 0 0 {SEARCH TABLE t1 USING INDEX t1a (a=?) (~1 rows)}}
+} {0 0 0 {SEARCH TABLE t1 USING INDEX t1a (a=?)}}
 
 # Verify that the t1b index shows that it does not narrow down the
 # search any at all.
 #
 do_test analyze4-1.1 {
   db eval {
     SELECT idx, stat FROM sqlite_stat1 WHERE tbl='t1' ORDER BY idx;
   }
 } {t1a {128 1} t1b {128 128}}
 
@@ skipping 50 matching lines @@
     INSERT INTO t2 VALUES(5, 'aBc', 'aBc', 'aBc');
     INSERT INTO t2 VALUES(6, 'aBC', 'aBC', 'aBC');
     INSERT INTO t2 VALUES(7, 'aBc ', 'aBc ', 'aBc ');
     INSERT INTO t2 VALUES(8, 'aBC ', 'aBC ', 'aBC ');
     ANALYZE;
     SELECT idx, stat FROM sqlite_stat1 WHERE tbl='t2' ORDER BY idx;
   }
 } {t2a {8 4} t2b {8 2} t2c {8 1} t2c2 {8 4} t2c3 {8 2}}
 
 finish_test