[sqlite] Documentation addition request for FTS3 / FTS4 phrase search

2019-08-30 Thread mailing lists
Hi, please add to the documentation that column limited phrase search is not supported by FTS3 and FTS4. Example: CREATE VIRTUAL TABLE FTSTable USING FTS3 (content,body); SELECT * FROM FTSTable WHERE FTSTable MATCH 'content:"one two"'; Does not result in an error but also returns no results.

Re: [sqlite] Documentation addition request

2013-11-13 Thread Richard Hipp
On Wed, Nov 13, 2013 at 10:41 AM, Simon Slavin wrote: > Can the text on these pages > > > > > have added a brief description of what differences are between all the > alternatives > > OR

[sqlite] Documentation addition request

2013-11-13 Thread Simon Slavin
Can the text on these pages have added a brief description of what differences are between all the alternatives OR ROLLBACK/ABORT/REPLACE/FAIL/IGNORE are, including which one is the default ? Thanks. Simon.