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.
>
> >
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
--- 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
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
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
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
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
7 matches
Mail list logo