Documentation Source Text

Check-in [787c316f3f]
Login

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.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 787c316f3f2f89c5333d8a31485157df1954f03f
User & Date: drh 2009-06-09 00:55:13.000
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
Unified Diff Ignore Whitespace Patch
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>