AryaWu/sqlite

1# 2007 Sep 122#3# The author disclaims copyright to this source code. In place of4# a legal notice, here is a blessing:5#6#    May you do good and not evil.7#    May you find forgiveness for yourself and forgive others.8#    May you share freely, never taking more than you give.9#10#***********************************************************************11#12# This file is to test that ticket #2643 has been fixed.13#14# $Id: tkt2643.test,v 1.1 2007/09/13 17:54:41 drh Exp $15#16 17# The problem in ticket #2643 has to do with the query optimizer18# making bad assumptions about index cost when data from ANALYZE19# is available.20 21set testdir [file dirname $argv0]22source $testdir/tester.tcl23 24do_test tkt2643-1.1 {25  execsql {26    CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE, c);27    INSERT INTO t1 VALUES(1,2,3);28    INSERT INTO t1 VALUES(2,3,4);29    ANALYZE;30  }31  db close32  sqlite3 db test.db33  execsql {34    CREATE INDEX i1 ON t1(c);35    SELECT count(*) FROM t1 WHERE c IS NOT NULL36  }37} {2}38 39finish_test40