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 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 support REPLACE, or is this a bug? -PQ
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------