I'm using sqlite 3.6.23.1.
I have a FTS3 table created using:
CREATE VIRTUAL TABLE EntryHeaders USING FTS3( Paragraph, Title,
tokenize=porter );
The following individual queries work and return rows:
SELECT rowid FROM EntryHeaders eh WHERE ( eh.Paragraph MATCH '91' )
SELECT rowid FROM
But I'm not getting any results when I combine these using OR:
SELECT rowid FROM EntryHeaders eh WHERE ( eh.Paragraph MATCH '91' ) OR (
eh.Title MATCH 'civil' )
See http://www.sqlite.org/fts3.html#section_3 . Your query should be more like:
SELECT rowid FROM EntryHeaders WHERE EntryHeaders