Hi
I have the following table:
CREATE TABLE x ('col1', 'col2', 'col3')
Create col1index on x ('col1')
When I run this query: "select * from x where col1 is null" I see the index on
x is used.
When I run this query: "select * from x where col1 is NOT null" I see the index
on x is not used.
How
Thanks. It is indeed a problem with a temp file - I set the temporary directory
with an uninitialized value.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi
We are building a Windows application using a read-only Sqlite database. When
executing many queries in a short time, we sometimes get SQLITE_CANTOPEN from
sqlite3_step. Checking GetLastError gives us error code 123: The filename,
directory name, or volume label syntax is incorrect. If we op
Hi
What is the most efficient way to sort a result set from an FTS table?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
4 matches
Mail list logo