Documentation Source Text

Check-in [f1a1831162]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Updates so that documentation agrees with requirement marks.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: f1a1831162fdf5f6c8c85d744ad8389574040c2a6a639b2c47b401163a33e316
User & Date: drh 2019-09-27 17:55:32.045
Context
2019-09-28
19:02
Typo fixes. (check-in: 7a37431be5 user: drh tags: trunk)
2019-09-27
17:55
Updates so that documentation agrees with requirement marks. (check-in: f1a1831162 user: drh tags: trunk)
11:30
Merge fixes from the 3.20 branch. (check-in: de8b5d698b user: drh tags: trunk)
Changes
Unified Diff Show Whitespace Changes Patch
Changes to pages/lang.in.
2452
2453
2454
2455
2456
2457
2458
2459
2460
2461
2462
2463
2464
2465
2466
2467

<p>^A [SELECT] statement enclosed in parentheses is a subquery.
^All types of SELECT statement, including
aggregate and compound SELECT queries (queries with keywords like
UNION or EXCEPT) are allowed as scalar subqueries.
^The value of a subquery expression is the first row of the result
from the enclosed [SELECT] statement.
^In other words, an implied "LIMIT 1" is added to the subquery, overriding
an explicitly coded LIMIT.
^The value of a subquery expression is NULL if the enclosed
[SELECT] statement returns no rows.

<p>A subquery that returns a single column is a scalar subquery and can
be used most anywhere.
^A subquery that returns two or more columns is a [row value]
subquery and can only be used as the operand of a comparison operator.







<
<







2452
2453
2454
2455
2456
2457
2458


2459
2460
2461
2462
2463
2464
2465

<p>^A [SELECT] statement enclosed in parentheses is a subquery.
^All types of SELECT statement, including
aggregate and compound SELECT queries (queries with keywords like
UNION or EXCEPT) are allowed as scalar subqueries.
^The value of a subquery expression is the first row of the result
from the enclosed [SELECT] statement.


^The value of a subquery expression is NULL if the enclosed
[SELECT] statement returns no rows.

<p>A subquery that returns a single column is a scalar subquery and can
be used most anywhere.
^A subquery that returns two or more columns is a [row value]
subquery and can only be used as the operand of a comparison operator.
5413
5414
5415
5416
5417
5418
5419

5420
5421
5422
5423
5424
5425
5426
   EXCEPT
   EXCLUSIVE
   EXCLUDE
   EXISTS
   EXPLAIN
   FAIL
   FILTER

   FOLLOWING
   FOR
   FOREIGN
   FROM
   FULL
   GLOB
   GROUP







>







5411
5412
5413
5414
5415
5416
5417
5418
5419
5420
5421
5422
5423
5424
5425
   EXCEPT
   EXCLUSIVE
   EXCLUDE
   EXISTS
   EXPLAIN
   FAIL
   FILTER
   FIRST
   FOLLOWING
   FOR
   FOREIGN
   FROM
   FULL
   GLOB
   GROUP
5438
5439
5440
5441
5442
5443
5444

5445
5446
5447
5448
5449
5450
5451
5452
5453
5454

5455
5456
5457
5458
5459
5460
5461
   INSTEAD
   INTERSECT
   INTO
   IS
   ISNULL
   JOIN
   KEY

   LEFT
   LIKE
   LIMIT
   MATCH
   NATURAL
   NO
   NOT
   NOTHING
   NOTNULL
   NULL

   OF
   OFFSET
   ON
   OR
   ORDER
   OTHERS
   OUTER







>










>







5437
5438
5439
5440
5441
5442
5443
5444
5445
5446
5447
5448
5449
5450
5451
5452
5453
5454
5455
5456
5457
5458
5459
5460
5461
5462
   INSTEAD
   INTERSECT
   INTO
   IS
   ISNULL
   JOIN
   KEY
   LAST
   LEFT
   LIKE
   LIMIT
   MATCH
   NATURAL
   NO
   NOT
   NOTHING
   NOTNULL
   NULL
   NULLS
   OF
   OFFSET
   ON
   OR
   ORDER
   OTHERS
   OUTER