third_party/sqlite/sqlite-src-3100200/ext/fts3/README.syntax - Issue 1610543003: [sql] Import reference version of SQLite 3.10.2.

Side by Side Diff

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Keyboard Shortcuts

	File
u :	up to issue
j / k :	jump to file after / before current file
J / K :	jump to next file with a comment after / before current file
	Side-by-side diff
i :	toggle intra-line diffs
e :	expand all comments
c :	collapse all comments
s :	toggle showing all comments
n / p :	next / previous diff chunk or comment
N / P :	next / previous comment
<Up> / <Down> :	next / previous line

	Issue
u :	up to list of issues
j / k :	jump to patch after / before current patch
o / <Enter> :	open current patch in side-by-side view
i :	open current patch in unified diff view

	Issue List
j / k :	jump to issue after / before current issue
o / <Enter> :	open current issue

Side by Side Diff: third_party/sqlite/sqlite-src-3100200/ext/fts3/README.syntax

Issue 1610543003: [sql] Import reference version of SQLite 3.10.2. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master

Patch Set: Created 4 years, 11 months ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

View unified diff | Download patch

« no previous file with comments | « third_party/sqlite/sqlite-src-3100200/ext/fts3/README.content ('k') | third_party/sqlite/sqlite-src-3100200/ext/fts3/README.tokenizers » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')

OLD	NEW
1	1

2 1. OVERVIEW	2 1. OVERVIEW

3	3

4 This README file describes the syntax of the arguments that may be passed to	4 This README file describes the syntax of the arguments that may be passed to

5 the FTS3 MATCH operator used for full-text queries. For example, if table	5 the FTS3 MATCH operator used for full-text queries. For example, if table

6 "t1" is an Fts3 virtual table, the following SQL query:	6 "t1" is an Fts3 virtual table, the following SQL query:

7	7

8 SELECT * FROM t1 WHERE <col> MATCH <full-text query>	8 SELECT * FROM t1 WHERE <col> MATCH <full-text query>

9	9

10 may be used to retrieve all rows that match a specified for full-text query.	10 may be used to retrieve all rows that match a specified for full-text query.

(...skipping 189 matching lines...) Expand 10 before \| Expand all \| Expand 10 after Loading...
200 Using the advanced syntax, it is possible to specify expressions enclosed	200 Using the advanced syntax, it is possible to specify expressions enclosed

201 in parenthesis as operands to the NOT, AND and OR operators. However both	201 in parenthesis as operands to the NOT, AND and OR operators. However both

202 the left and right hand side operands of NEAR operators must be either	202 the left and right hand side operands of NEAR operators must be either

203 tokens or phrases. Attempting the following query will return an error:	203 tokens or phrases. Attempting the following query will return an error:

204	204

205 <col> MATCH 'sqlite NEAR (fantastic OR impressive)'	205 <col> MATCH 'sqlite NEAR (fantastic OR impressive)'

206	206

207 Queries of this form must be re-written as:	207 Queries of this form must be re-written as:

208	208

209 <col> MATCH 'sqlite NEAR fantastic OR sqlite NEAR impressive'	209 <col> MATCH 'sqlite NEAR fantastic OR sqlite NEAR impressive'

OLD	NEW