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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 2d23316bb5f2bb47d5ad20e9b1eb96e2b7b129cf79f2af1ee09f5fda4a4c6aae
User & Date: drh 2020-01-22 17:13:56
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
Hide Diffs Unified Diffs 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