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: |
1495fead09f48103124156ef93956437 |
| 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
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