Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Remove the tags from a couple of untestable statements in lang_select.html. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
0df9f2d38140ae2f82cf06f4abb16798 |
| User & Date: | dan 2010-09-18 15:03:00 |
Context
|
2010-09-18
| ||
| 18:52 | Tweaks to lang_insert.html. (check-in: 15cc2204a5 user: dan tags: trunk) | |
| 15:03 | Remove the tags from a couple of untestable statements in lang_select.html. (check-in: 0df9f2d381 user: dan tags: trunk) | |
|
2010-09-17
| ||
| 19:52 | Update the syntax diagram GIF files. (check-in: 2adf0c0cca user: drh tags: trunk) | |
Changes
Changes to art/syntax/bubble-generator-data.tcl.
210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 ... 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 ... 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 |
}
delete-stmt-limited {
stack
{line DELETE FROM qualified-table-name {optx WHERE expr}}
{optx
{stack
{optx ORDER BY {loop ordering-term ,}}
{line LIMIT /expression {optx {or OFFSET ,} /expression}}
}
}
}
detach-stmt {
line DETACH {optx DATABASE} /database-name
}
drop-index-stmt {
................................................................................
}
}
}
select-stmt {
stack
{loop {line select-core nil} {nil compound-operator nil}}
{optx ORDER BY {loop ordering-term ,}}
{optx LIMIT /expression {optx {or OFFSET ,} /expression}}
}
select-core {
stack
{line SELECT {or nil DISTINCT ALL} {loop result-column ,}}
{optx FROM join-source}
{optx WHERE expr}
{optx GROUP BY {loop ordering-term ,} {optx HAVING expr}}
................................................................................
stack
{line UPDATE {opt OR {or ROLLBACK ABORT REPLACE FAIL IGNORE}}
qualified-table-name}
{line SET {loop {line /column-name = expr} ,} {optx WHERE expr}}
{optx
{stack
{optx ORDER BY {loop ordering-term ,}}
{line LIMIT /expression {optx {or OFFSET ,} /expression}}
}
}
}
qualified-table-name {
line {optx /database-name .} /table-name
{or nil {line INDEXED BY /index-name} {line NOT INDEXED}}
}
|
| | | |
210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 ... 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 ... 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 |
}
delete-stmt-limited {
stack
{line DELETE FROM qualified-table-name {optx WHERE expr}}
{optx
{stack
{optx ORDER BY {loop ordering-term ,}}
{line LIMIT /expr {optx {or OFFSET ,} /expr}}
}
}
}
detach-stmt {
line DETACH {optx DATABASE} /database-name
}
drop-index-stmt {
................................................................................
}
}
}
select-stmt {
stack
{loop {line select-core nil} {nil compound-operator nil}}
{optx ORDER BY {loop ordering-term ,}}
{optx LIMIT /expr {optx {or OFFSET ,} /expr}}
}
select-core {
stack
{line SELECT {or nil DISTINCT ALL} {loop result-column ,}}
{optx FROM join-source}
{optx WHERE expr}
{optx GROUP BY {loop ordering-term ,} {optx HAVING expr}}
................................................................................
stack
{line UPDATE {opt OR {or ROLLBACK ABORT REPLACE FAIL IGNORE}}
qualified-table-name}
{line SET {loop {line /column-name = expr} ,} {optx WHERE expr}}
{optx
{stack
{optx ORDER BY {loop ordering-term ,}}
{line LIMIT /expr {optx {or OFFSET ,} /expr}}
}
}
}
qualified-table-name {
line {optx /database-name .} /table-name
{or nil {line INDEXED BY /index-name} {line NOT INDEXED}}
}
|
Changes to pages/lang.in.
2590
2591
2592
2593
2594
2595
2596
2597
2598
2599
2600
2601
2602
2603
2604
....
2623
2624
2625
2626
2627
2628
2629
2630
2631
2632
2633
2634
2635
2636
2637
|
BubbleDiagram join-op BubbleDiagram join-constraint BubbleDiagram ordering-term BubbleDiagram compound-operator </tcl> <p>The SELECT statement is used to query the database. ^The result of a SELECT is zero or more rows of data where each row has a fixed number of columns. <p>The SELECT statement is the most complicated command in the SQL language. To make the description easier to follow, some of the passages below describe the way the data returned by a SELECT statement is determined as a series of steps. It is important to keep in mind that this is purely illustrative - ................................................................................ The set of result rows is computed by aggregating the data according to any GROUP BY clause and calculating the result-set expressions for the rows of the filtered input dataset. <li> <p>[DISTINCT|DISTINCT/ALL keyword] processing: If the query is a "SELECT DISTINCT" query, duplicate rows are removed from the set of result rows. </ol> <p>^There are two types of simple SELECT statement - aggregate and non-aggregate queries. ^A simple SELECT statement is an aggregate query if it contains either a GROUP BY clause or one or more aggregate functions in the result-set. ^Otherwise, if a simple SELECT contains no aggregate functions or a GROUP BY clause, it is a non-aggregate query. <p><b>1. Determination of input data (FROM clause processing).</b> <tcl>hd_fragment fromclause</tcl> |
|
|
|
2590
2591
2592
2593
2594
2595
2596
2597
2598
2599
2600
2601
2602
2603
2604
....
2623
2624
2625
2626
2627
2628
2629
2630
2631
2632
2633
2634
2635
2636
2637
|
BubbleDiagram join-op
BubbleDiagram join-constraint
BubbleDiagram ordering-term
BubbleDiagram compound-operator
</tcl>
<p>The SELECT statement is used to query the database. The
result of a SELECT is zero or more rows of data where each row
has a fixed number of columns.
<p>The SELECT statement is the most complicated command in the SQL language.
To make the description easier to follow, some of the passages below describe
the way the data returned by a SELECT statement is determined as a series of
steps. It is important to keep in mind that this is purely illustrative -
................................................................................
The set of result rows is computed by aggregating the data according to
any GROUP BY clause and calculating the result-set expressions for the
rows of the filtered input dataset.
<li> <p>[DISTINCT|DISTINCT/ALL keyword] processing: If the query is a "SELECT
DISTINCT" query, duplicate rows are removed from the set of result rows.
</ol>
<p>There are two types of simple SELECT statement - aggregate and
non-aggregate queries. ^A simple SELECT statement is an aggregate query if
it contains either a GROUP BY clause or one or more aggregate functions
in the result-set. ^Otherwise, if a simple SELECT contains no aggregate
functions or a GROUP BY clause, it is a non-aggregate query.
<p><b>1. Determination of input data (FROM clause processing).</b>
<tcl>hd_fragment fromclause</tcl>
|