Documentation Source Text

Check-in [d170aa6e3f]
Login

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

Overview
Comment:Update the syntax diagram for CREATE VIRTUAL TABLE to show the optional IF NOT EXISTS clause.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d170aa6e3fa36c9f4d1513a174096fb8f85159a4
User & Date: drh 2012-01-28 19:42:28
Context
2012-01-28
19:47
Update the changelog to mention IF NOT EXISTS on virtual tables. check-in: b0db418b5a user: drh tags: trunk
19:42
Update the syntax diagram for CREATE VIRTUAL TABLE to show the optional IF NOT EXISTS clause. check-in: d170aa6e3f user: drh tags: trunk
18:37
Create the version 3.7.11 change log. check-in: eb1a6182af user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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

   196    196     create-view-stmt {
   197    197       stack
   198    198          {line CREATE {or {} TEMP TEMPORARY} VIEW {opt IF NOT EXISTS}}
   199    199          {line {optx /database-name .} /view-name AS select-stmt}
   200    200     }
   201    201     create-virtual-table-stmt {
   202    202       stack
   203         -       {line CREATE VIRTUAL TABLE {optx /database-name .} /table-name}
          203  +       {line CREATE VIRTUAL TABLE {opt IF NOT EXISTS}}
          204  +       {line {optx /database-name .} /table-name}
   204    205          {line USING /module-name {optx ( {loop /module-argument ,} )}}
   205    206     }
   206    207     delete-stmt {
   207    208       line DELETE FROM qualified-table-name {optx WHERE expr}
   208    209     }
   209    210     delete-stmt-limited {
   210    211       stack

Changes to art/syntax/create-virtual-table-stmt.gif.

cannot compute difference between binary files