subject:"\[sqlite\] BUG in SQLite\? Still the rowid question"

Re: [sqlite] BUG in SQLite? Still the rowid question

2009-08-30 Thread Wanadoo Hartwig

Am 30.08.2009 um 17:56 schrieb Kit: > 2009/8/29 Wanadoo Hartwig : >> The largest and last row id is 4. Why is SQLite returning 5? I think >> it has to do with the FTS3 module but still the trigger statement >> should shield the row ids from the trigger statement, or?

Re: [sqlite] BUG in SQLite? Still the rowid question

2009-08-30 Thread Kit

2009/8/29 Wanadoo Hartwig : > The largest and last row id is 4. Why is SQLite returning 5? I think > it has to do with the FTS3 module but still the trigger statement > should shield the row ids from the trigger statement, or? > Hartwig CREATE TABLE Simple (ID integer