Hello,
In SQLite 3.5.9, this misbehavior occurs:
[EMAIL PROTECTED]:~$ sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> CREATE TABLE foo(foo TEXT);
sqlite> INSERT INTO foo VALUES ('a');
sqlite> INSERT INTO foo VALUES ('b');
sqlite> SELECT DISTINCT foo FROM foo WHERE foo IS NOT NULL;
a
b
sqlite> CREATE INDEX foo_foo ON foo(foo);
sqlite> SELECT DISTINCT foo FROM foo WHERE foo IS NOT NULL;
b
sqlite>
This appears to be fixed in a later release of SQLite. I'm trying to figure
out which release it was first fixed in and the revision or revisions in
which the fix was applied to trunk. The version of SQLite packaged in the
latest Ubuntu release is 3.5.9 and so includes this bug.
I spent quite a while looking through the issue tracker and the revision
history, but didn't manage to turn up anything. Can anyone give me any
pointers?
Jean-Paul
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
