[sqlite] Change in index optimizer bug with FTS3 between 3.6.21 and 3.6.22?

Not sure if this is intentional, but it looks like the wrong index is being selected on fts tables when a rowid is involved. Given a table: CREATE VIRTUAL TABLE MessagesFts USING fts3(Message); Explain query plan using sqlite 3.6.21: sqlite> EXPLAIN QUERY PLAN SELECT * FROM MessagesFts WHERE do

Re: [sqlite] Change in index optimizer bug with FTS3 between 3.6.21 and 3.6.22?

On Feb 5, 2010, at 6:03 AM, Nasron Cheong wrote: > Not sure if this is intentional, but it looks like the wrong index > is being > selected on fts tables when a rowid is involved. > > Given a table: > > CREATE VIRTUAL TABLE MessagesFts USING fts3(Message); > > Explain query plan using sqlite 3.