Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Correct the description on how short_column_names and full_column_names interact. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
787c316f3f2f89c5333d8a31485157df |
| User & Date: | drh 2009-06-09 00:55:13 |
Context
|
2009-06-09
| ||
| 00:55 | Correct the description on how short_column_names and full_column_names interact. check-in: 787c316f3f user: drh tags: trunk | |
| 00:52 | Fill in a couple of missing details wrt balance_nonroot (balance-siblings). check-in: 273d1c6fee user: dan tags: trunk | |
|
2009-06-08
| ||
| 12:30 | Add extra details on balance-siblings algorithm to btreemodule.html. check-in: 9e047c0045 user: dan tags: trunk | |
Changes
Changes to pages/pragma.in.
270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 |
<li><p>If the result is a general expression, not a just the name of
a source table column,
then the name of the result is a copy of the expression text.</p></li>
<li><p>If the [short_column_names] pragma is ON, then the name of the
result is the name of the source table column without the
source table name prefix: COLUMN.</p></li>
<li><p>If both pragmas [short_column_names] and [full_column_names]
are OFF then
case (2) applies for simple queries and case (5) applies for joins.
</p></li>
<li><p>The name of the result column is a combination of the source table
and source column name: TABLE.COLUMN</p></li>
</ol>
</li>
<tcl>Subsection fullfsync</tcl>
|
| < |
270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 |
<li><p>If the result is a general expression, not a just the name of
a source table column,
then the name of the result is a copy of the expression text.</p></li>
<li><p>If the [short_column_names] pragma is ON, then the name of the
result is the name of the source table column without the
source table name prefix: COLUMN.</p></li>
<li><p>If both pragmas [short_column_names] and [full_column_names]
are OFF then case (2) applies.
</p></li>
<li><p>The name of the result column is a combination of the source table
and source column name: TABLE.COLUMN</p></li>
</ol>
</li>
<tcl>Subsection fullfsync</tcl>
|