Daniel Kamil Kozar wrote: > I'd like to ask why using a IS NULL or IS NOT NULL constraint in a > query made to a virtual table does not result in these constraints > being present in the sqlite3_index_info structure passed to the > virtual table's xBestIndex.
Because there is no SQLITE_INDEX_CONSTRAINT_IS. > I could only find one thread which also deals with this issue : > http://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg62850.html As shown there, "x IS NOT NULL" originally ended up as the constraint "x > NULL", but this whan then considered a bug. The FTS and R-tree virtual tables do not contain NULL values, so I guess it was never seen as necessary. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users