Re: [sqlite] Re: FTS does not support REPLACE

2007-04-11 Thread Scott Hess
On 4/11/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: On Tue, 2007-04-10 at 09:26 -0700, Scott Hess wrote: > On 4/10/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: > > I checked the code and conflict handling mechanisms (OR ERROR, > > OR ABORT, OR REPLACE) do not apply to virtual tables. > > >

Re: [sqlite] Re: FTS does not support REPLACE

2007-04-11 Thread Dan Kennedy
On Tue, 2007-04-10 at 09:26 -0700, Scott Hess wrote: > On 4/10/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: > > I checked the code and conflict handling mechanisms (OR ERROR, > > OR ABORT, OR REPLACE) do not apply to virtual tables. > > > Something to think about anyhow... Do we want conflict

Re: [sqlite] Re: FTS does not support REPLACE

2007-04-10 Thread Joe Wilson
--- Dan Kennedy <[EMAIL PROTECTED]> wrote: > I checked the code and conflict handling mechanisms (OR ERROR, > OR ABORT, OR REPLACE) do not apply to virtual tables. ... > Something to think about anyhow... Do we want conflict handling > for FTS (and other virtual modules)? It would be nice if

Re: [sqlite] Re: FTS does not support REPLACE

2007-04-10 Thread Scott Hess
On 4/10/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: I checked the code and conflict handling mechanisms (OR ERROR, OR ABORT, OR REPLACE) do not apply to virtual tables. Something to think about anyhow... Do we want conflict handling for FTS (and other virtual modules)? I think OR REPLACE

Re: [sqlite] Re: FTS does not support REPLACE

2007-04-10 Thread Dan Kennedy
On Mon, 2007-04-09 at 13:02 -0700, Scott Hess wrote: > Thanks for the concise report. I'm going to take a look at this > today, to see if it's an fts1/2 problem. If it's _not_, I'll still > look at it, but perhaps with less eventual success :-). I checked the code and conflict handling

Re: [sqlite] Re: FTS does not support REPLACE

2007-04-09 Thread Scott Hess
Thanks for the concise report. I'm going to take a look at this today, to see if it's an fts1/2 problem. If it's _not_, I'll still look at it, but perhaps with less eventual success :-). -scott On 4/9/07, Paul Quinn <[EMAIL PROTECTED]> wrote: Very simple to replicate: CREATE VIRTUAL

[sqlite] Re: FTS does not support REPLACE

2007-04-09 Thread Paul Quinn
Very simple to replicate: CREATE VIRTUAL TABLE fts_table USING fts2(text); INSERT OR REPLACE INTO fts_table (rowid, text) VALUES (1, 'text1'); INSERT OR REAPLCE INTO fts_table (rowid, text) VALUES (1, 'text2'); The first insert succeeds, the second fails. Is FTS not supposed to