On Mon, 31 Jan 2011 12:34:24 -0500, Samuel Adam <[email protected]>
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 <[email protected]>
763 Montgomery Road
Hillsborough, NJ 08844-1304 • United States
http://certifound.com/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
