Documentation Source Text

Check-in [8b88f8f240]
Login

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

Overview
Comment:Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | branch-3.31
Files: files | file ages | folders
SHA3-256: 8b88f8f240dfe0ca22f59e8f82c0fac08186e574689edf24a65e794ac1479db6
User & Date: drh 2020-05-20 01:27:02
Context
2020-05-21
19:16
Fix typo in the query planner documentation. Leaf check-in: c3875b77fa user: drh tags: branch-3.31
2020-05-20
01:27
Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause. check-in: 8b88f8f240 user: drh tags: branch-3.31
01:24
Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause. check-in: e42edf1dd3 user: drh tags: trunk
2020-05-18
14:37
Fix a minor typo in the rtree documentation. check-in: f073620ff2 user: drh tags: branch-3.31
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to art/syntax/bubble-generator-data.tcl.

323
324
325
326
327
328
329
330
331
332
333
334

335
336
337
338
339
340
341
              {line INSERT OR IGNORE}
          }
          INTO
       }
       {line {optx /schema-name .} /table-name
             {opt AS /alias}
             {optx ( {loop /column-name ,} )}}
       {line {or
           {line VALUES {loop {line ( {loop expr ,} )} ,}}
           select-stmt
           {line DEFAULT VALUES}
         } {opt upsert-clause}}

  }
  upsert-clause {
    stack
      {line ON CONFLICT {opt ( {loop indexed-column ,} ) {opt WHERE expr} } DO } 
      {or
         NOTHING
         {line UPDATE SET 







|
|
|
|
<
>







323
324
325
326
327
328
329
330
331
332
333

334
335
336
337
338
339
340
341
              {line INSERT OR IGNORE}
          }
          INTO
       }
       {line {optx /schema-name .} /table-name
             {opt AS /alias}
             {optx ( {loop /column-name ,} )}}
       {line {or {line {or
                        {line VALUES {loop {line ( {loop expr ,} )} ,}}
                        {line select-stmt}} {opt upsert-clause}}
                 {line DEFAULT VALUES}}

         }
  }
  upsert-clause {
    stack
      {line ON CONFLICT {opt ( {loop indexed-column ,} ) {opt WHERE expr} } DO } 
      {or
         NOTHING
         {line UPDATE SET 

Changes to art/syntax/insert-stmt.gif.

cannot compute difference between binary files