Documentation Source Text

Check-in [e42edf1dd3]
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 | trunk
Files: files | file ages | folders
SHA3-256: e42edf1dd3d0b3e1df6614e6dfa343ee7ba7deaf27ff5515dd22dd50941623b2
User & Date: drh 2020-05-20 01:24:12
Context
2020-05-20
15:02
Update the change log. check-in: 18e8d6c077 user: drh tags: trunk
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-19
19:37
Improvements to the CVE page. check-in: 1cb2a5b6bc user: drh tags: trunk
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