Documentation Source Text

Check-in [1495fead09]
Login

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

Overview
Comment:Additional clarifications to the syntax diagrams.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 1495fead09f48103124156ef93956437d57c3516
User & Date: drh 2009-02-16 16:16:26
Context
2009-02-16
17:42
Documentation updates in preparation for version 3.6.11. check-in: f647c36e45 user: drh tags: trunk
16:16
Additional clarifications to the syntax diagrams. check-in: 1495fead09 user: drh tags: trunk
2009-02-14
19:00
Tweaks to the syntax diagrams to make them more readable. check-in: b28d410e7d user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

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

320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
...
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
...
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
             {line {optx /database-name .}
                 {tailbranch /table-name /index-name}
             }
          }
  }
  select-stmt {
    stack
       {loop {line nil select-core nil} {nil compound-operator nil}}
       {optx ORDER BY {loop ordering-term ,}}
       {optx LIMIT /integer {optx {or OFFSET ,} /integer}}
  }
  select-core {
     stack
       {line SELECT {or nil DISTINCT ALL} {loop result-column ,}}
       {optx FROM join-source}
................................................................................
        *
        {line /table-name . *}
        {line expr {optx {optx AS} /column-alias}}
  }
  join-source {
     line
        single-source
        {optx {loop {line join-op single-source join-constraint} nil}}
  }
  single-source {
     or
       {line
          {optx /database-name .} /table-name
          {optx {optx AS} /table-alias}
          {or nil {line INDEXED BY /index-name} {line NOT INDEXED}}
................................................................................
  join-constraint {
     or
        {line ON expr}
        {line USING ( {loop /column-name ,} )}
        nil
  }
  ordering-term {
      line expr {optx COLLATE /collation-name} {or ASC DESC nil} 
  }
  compound-operator {
     or {line UNION {optx ALL}} INTERSECT EXCEPT
  }
  update-stmt {
     stack
        {line UPDATE {opt OR {or ROLLBACK ABORT REPLACE FAIL IGNORE}}







|







 







|







 







|







320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
...
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
...
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
             {line {optx /database-name .}
                 {tailbranch /table-name /index-name}
             }
          }
  }
  select-stmt {
    stack
       {loop {line select-core nil} {nil compound-operator nil}}
       {optx ORDER BY {loop ordering-term ,}}
       {optx LIMIT /integer {optx {or OFFSET ,} /integer}}
  }
  select-core {
     stack
       {line SELECT {or nil DISTINCT ALL} {loop result-column ,}}
       {optx FROM join-source}
................................................................................
        *
        {line /table-name . *}
        {line expr {optx {optx AS} /column-alias}}
  }
  join-source {
     line
        single-source
        {opt {loop {line nil join-op single-source join-constraint nil} {}}}
  }
  single-source {
     or
       {line
          {optx /database-name .} /table-name
          {optx {optx AS} /table-alias}
          {or nil {line INDEXED BY /index-name} {line NOT INDEXED}}
................................................................................
  join-constraint {
     or
        {line ON expr}
        {line USING ( {loop /column-name ,} )}
        nil
  }
  ordering-term {
      line expr {opt COLLATE /collation-name} {or nil ASC DESC} 
  }
  compound-operator {
     or {line UNION {optx ALL}} INTERSECT EXCEPT
  }
  update-stmt {
     stack
        {line UPDATE {opt OR {or ROLLBACK ABORT REPLACE FAIL IGNORE}}

Changes to art/syntax/join-source.gif.

cannot compute difference between binary files

Changes to art/syntax/ordering-term.gif.

cannot compute difference between binary files

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

cannot compute difference between binary files