On Dec 2, 2009, at 3:07 PM, Ralf Junker wrote:

> With the latest FTS3 changes, fts3b-4.9 no longer passes. This short  
> SQL
> emulates the test:
>
>   DROP TABLE IF EXISTS t4;
>   CREATE VIRTUAL TABLE t4 USING fts3(c);
>   INSERT INTO t4 (docid, c) VALUES (12, 'still testing');
>   UPDATE t4 SET docid = 14 WHERE docid = 12;
>
> Note that SQLite 3.6.20 chokes with "SQL logic error or missing
> database" on the last line.
>
> Everything runs fine with the latest FTS3. I can even query
>
>   SELECT docid, * FROM t4 WHERE t4 MATCH 'still';
>
> and it happily returns that the updated docid equals 14.
>
> Questions:
>
> * Is it now intentionally possible to update FTS3 DOCIDs?

It is. The failing sqlite test case has been replaced.

Dan.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to