Documentation Source Text

Check-in [2d23316bb5]
Login

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

Overview
Comment:Updates to the generated column documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 2d23316bb5f2bb47d5ad20e9b1eb96e2b7b129cf79f2af1ee09f5fda4a4c6aae
User & Date: drh 2020-01-22 17:13:56.229
Context
2020-01-22
17:49
Fix documentation typos. (check-in: 1894a02a1f user: drh tags: trunk)
17:13
Updates to the generated column documentation. (check-in: 2d23316bb5 user: drh tags: trunk)
2020-01-21
20:14
Update the speed-and-size spreadsheet. (check-in: 6639a1d518 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/gencol.in.
︙︙
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

specified by the expression that follows the "AS" keyword.

<li><p>
^Generated columns may not be used as part of the [PRIMARY KEY].
(Future versions of SQLite might relax this constraint for STORED columns.)

<li><p>
^The expression of a generated column has the same restrictions as the
expression of a [CHECK constraint]: The expression may only reference
constant literals and columns within the same row, and may only use
scalar [deterministic functions].  ^The expression may not use subqueries,
aggregate functions, window functions, or table-valued functions.

<li><p>
^The expression of a generated column may refer to other generated columns
in the same row, but no generated column can depend upon itself, either








|
<








103
104
105
106
107
108
109
110

111
112
113
114
115
116
117

specified by the expression that follows the "AS" keyword.

<li><p>
^Generated columns may not be used as part of the [PRIMARY KEY].
(Future versions of SQLite might relax this constraint for STORED columns.)

<li><p>
^The expression of a generated column may only reference

constant literals and columns within the same row, and may only use
scalar [deterministic functions].  ^The expression may not use subqueries,
aggregate functions, window functions, or table-valued functions.

<li><p>
^The expression of a generated column may refer to other generated columns
in the same row, but no generated column can depend upon itself, either
︙︙