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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: f1a1831162fdf5f6c8c85d744ad8389574040c2a6a639b2c47b401163a33e316
User & Date: drh 2019-09-27 17:55:32
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

  2452   2452   
  2453   2453   <p>^A [SELECT] statement enclosed in parentheses is a subquery.
  2454   2454   ^All types of SELECT statement, including
  2455   2455   aggregate and compound SELECT queries (queries with keywords like
  2456   2456   UNION or EXCEPT) are allowed as scalar subqueries.
  2457   2457   ^The value of a subquery expression is the first row of the result
  2458   2458   from the enclosed [SELECT] statement.
  2459         -^In other words, an implied "LIMIT 1" is added to the subquery, overriding
  2460         -an explicitly coded LIMIT.
  2461   2459   ^The value of a subquery expression is NULL if the enclosed
  2462   2460   [SELECT] statement returns no rows.
  2463   2461   
  2464   2462   <p>A subquery that returns a single column is a scalar subquery and can
  2465   2463   be used most anywhere.
  2466   2464   ^A subquery that returns two or more columns is a [row value]
  2467   2465   subquery and can only be used as the operand of a comparison operator.
................................................................................
  5413   5411      EXCEPT
  5414   5412      EXCLUSIVE
  5415   5413      EXCLUDE
  5416   5414      EXISTS
  5417   5415      EXPLAIN
  5418   5416      FAIL
  5419   5417      FILTER
         5418  +   FIRST
  5420   5419      FOLLOWING
  5421   5420      FOR
  5422   5421      FOREIGN
  5423   5422      FROM
  5424   5423      FULL
  5425   5424      GLOB
  5426   5425      GROUP
................................................................................
  5438   5437      INSTEAD
  5439   5438      INTERSECT
  5440   5439      INTO
  5441   5440      IS
  5442   5441      ISNULL
  5443   5442      JOIN
  5444   5443      KEY
         5444  +   LAST
  5445   5445      LEFT
  5446   5446      LIKE
  5447   5447      LIMIT
  5448   5448      MATCH
  5449   5449      NATURAL
  5450   5450      NO
  5451   5451      NOT
  5452   5452      NOTHING
  5453   5453      NOTNULL
  5454   5454      NULL
         5455  +   NULLS
  5455   5456      OF
  5456   5457      OFFSET
  5457   5458      ON
  5458   5459      OR
  5459   5460      ORDER
  5460   5461      OTHERS
  5461   5462      OUTER