Re: [sqlite] last_insert_rowid and FTS in 3.17

2017-03-16 Thread Hugo Beauzée-Luyssen
tter"); > sqlite> COMMIT; > sqlite> SELECT last_insert_rowid(); > 3 > sqlite> > sqlite> SELECT * FROM sqlite_sequence; > Foo|3 > sqlite> > sqlite> > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun

Re: [sqlite] last_insert_rowid and FTS in 3.17

2017-03-15 Thread Keith Medcalf
glists.sqlite.org] > On Behalf Of Richard Hipp > Sent: Wednesday, 15 March, 2017 18:01 > To: SQLite mailing list > Subject: Re: [sqlite] last_insert_rowid and FTS in 3.17 > > On 3/15/17, Hugo Beauzée-Luyssen <h...@beauzee.fr> wrote: > > Hi, I'm having some issues with l

Re: [sqlite] last_insert_rowid and FTS in 3.17

2017-03-15 Thread Richard Hipp
On 3/15/17, Hugo Beauzée-Luyssen wrote: > Hi, I'm having some issues with last_insert_rowid starting with 3.17 > Basically it seems to be returning the row inserted by a trigger, > instead of the explicitly inserted row. Please try the latest pre-release snapshot at