Re: [sqlite] last_insert_rowid reproducible bug with triggers and FTS2 and 3

2008-05-20 Thread Bram de Jong
Hello, On Tue, May 20, 2008 at 10:26 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > So it is not at all clear to me whether this behavior is a bug or a > feature. SQLite is doing what the documentation says it ought to do. > The question is, should the specification of what SQLite ought to do >

[sqlite] last_insert_rowid reproducible bug with triggers and FTS2 and 3

2008-05-20 Thread Bram de Jong
Hello all, I have found a bug which happens in both FTS2 and FTS3. The bug happens when a trigger updates an FTS table: the insert ID gets trashed: <<< create table one ( id integer not null primary key autoincrement, value text not null d