Re: [sqlite] fts3b-4.9 fails - FTS3 docid updates now possible with latest version?

2009-12-03 Thread Ralf Junker 
On 02.12.2009 20:00, Dan Kennedy wrote:

> On Dec 2, 2009, at 3:07 PM, Ralf Junker wrote:
>
>> * Is it now intentionally possible to update FTS3 DOCIDs?
>
> It is. The failing sqlite test case has been replaced.

Thanks you, Dan! I had already noticed!

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

Re: [sqlite] fts3b-4.9 fails - FTS3 docid updates now possible with latest version?

2009-12-02 Thread Dan Kennedy 

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

[sqlite] fts3b-4.9 fails - FTS3 docid updates now possible with latest version?

2009-12-02 Thread Ralf Junker 
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?
* Should I modify my tests accordingly?

Thanks,

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