Documentation Source Text

Check-in [cfd3eb70b4]
Login

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

Overview
Comment:Fix spelling error in the previous check-in.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: cfd3eb70b4897780261511770b7f8708f8278f35428f1973501e64af49c6f739
User & Date: drh 2019-03-29 16:41:31
Context
2019-04-01
14:45
Merge changes from the 3.27 branch. check-in: 50513b6f28 user: drh tags: trunk
2019-03-29
16:41
Fix spelling error in the previous check-in. check-in: cfd3eb70b4 user: drh tags: trunk
16:40
Mention the ON parsing ambiguity of UPSERT on the UPSERT documentation page. check-in: c3bcaaf1e5 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

  3559   3559   takes its values from a [SELECT] statement, there is a potential
  3560   3560   parsing ambiguity.  The parser might not be able to tell if the
  3561   3561   "ON" keyword is introducing the UPSERT or if it is the ON clause
  3562   3562   of a join.  To work around this, the SELECT statement should always
  3563   3563   include a WHERE clause, even if that WHERE clause is just
  3564   3564   "WHERE true".
  3565   3565   
  3566         -<p>Ambiguious use of ON:
         3566  +<p>Ambiguous use of ON:
  3567   3567   
  3568   3568   <blockquote><pre>
  3569   3569   INSERT INTO t1 SELECT * FROM t2
  3570   3570   ON CONFLICT(x) DO UPDATE SET y=excluded.y;
  3571   3571   </pre></blockquote>
  3572   3572   
  3573   3573   <p>Ambiguity resolved using a WHERE clause: