[sqlite] [BUG] 3.11.0: FTS3/4 index emptied by 'optimize' inside transaction

On 03/09/2016 11:35 PM, Tomash Brechko wrote: > Hello, > > With 3.11.0 if you run the following SQL you will get no result (which is > wrong): > > -- cut -- > BEGIN; > CREATE VIRTUAL TABLE fts USING fts4 (t); > INSERT INTO fts (rowid, t) VALUES (1, 'test'); > INSERT INTO fts (fts) VALUES

[sqlite] [BUG] 3.11.0: FTS3/4 index emptied by 'optimize' inside transaction

Hello, With 3.11.0 if you run the following SQL you will get no result (which is wrong): -- cut -- BEGIN; CREATE VIRTUAL TABLE fts USING fts4 (t); INSERT INTO fts (rowid, t) VALUES (1, 'test'); INSERT INTO fts (fts) VALUES ('optimize'); COMMIT; SELECT rowid FROM fts WHERE fts MATCH 'test'; --