On Mon, 31 Jan 2011 12:34:24 -0500, Samuel Adam <a...@certifound.com> wrote:
> According to the docs, results from those queries should be reversed. I > suspect that Mr. da Silveira’s different platforms actually have > different SQLite versions, and that one version is consistent with the > docs whereas the other is not. But this thread has already seen the > dangers of speculation. Mr. da Silveira, can you confirm whether *all* > your platforms use 3.6.22 and have a proper FTS3 baked in? My version hypothesis was flat-out incorrect. Repeating all tests in 3.6.22, the results are exactly the same as I showed with 3.7.2. First, showing my compile options (this is on Windows): sqlite-3.6.22>cl /nologo /Ox /fp:strict /Fesqlite3.6.22.exe /DSQLITE_DEFAULT_FILE_FORMAT=4 /DSQLITE_DEFAULT_RECURSIVE_TRIGGERS /DSQLITE_ENABLE_STAT2 /DSQLITE_ENABLE_FTS3 /DSQLITE_ENABLE_FTS3_PARENTHESIS /DSQLITE_ENABLE_UNLOCK_NOTIFY /DSQLITE_ENABLE_COLUMN_METADATA /DSQLITE_SOUNDEX=1 /DSQLITE_ENABLE_MEMORY_MANAGEMENT /DSQLITE_ENABLE_RTREE shell.c sqlite3.c shell.c sqlite3.c Generating Code... sqlite-3.6.22>.\sqlite3.6.22.exe SQLite version 3.6.22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .mode line sqlite> SELECT sqlite_source_id(); sqlite_source_id() = 2010-01-05 15:30:36 28d0d7710761114a44a1a3a425a6883c661f06e7 sqlite> CREATE VIRTUAL TABLE "Test" USING fts3( ...> "id" INTEGER PRIMARY KEY, ...> "Content" TEXT, ...> "count" INTEGER); sqlite> INSERT INTO "Test" ("id", "Content", "count") VALUES( ...> 101, ...> 'This is a test.', ...> 999); sqlite> SELECT "rowid" FROM "Test" WHERE "id" = 101; rowid = 1 sqlite> SELECT typeof("id"), typeof("Content"), typeof("count") FROM "Test"; typeof("id") = integer typeof("Content") = text typeof("count") = integer sqlite> SELECT * FROM "Test" WHERE "id" = 101; id = 101 Content = This is a test. count = 999 sqlite> SELECT * FROM "Test" WHERE "id" = '101'; sqlite> Very truly, Samuel Adam <a...@certifound.com> 763 Montgomery Road Hillsborough, NJ 08844-1304 • United States http://certifound.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users