Documentation Source Text

Check-in [3103f83e9e]
Login

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

Overview
Comment:Tighten the requirement so that every table must have at least one non-generated column. A STORED column does not count.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 3103f83e9e216cf7fd3d56408ab047d949dfa0512ada62415c3babe0e8f8989a
User & Date: drh 2019-10-29 03:35:58.952
Context
2019-10-29
09:03
Fix typo in the generated columns description. (check-in: eaa1cd343f user: drh tags: trunk)
03:35
Tighten the requirement so that every table must have at least one non-generated column. A STORED column does not count. (check-in: 3103f83e9e user: drh tags: trunk)
01:24
Begin adding documentation for generated columns. (check-in: a558a79107 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/gencol.in.
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99

<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
directly or indirectly.

<li><p>
Every table must have at least one non-VIRTUAL column.
</ol>

<h1>Compatibility</h1>

<p>Generated column support was added with SQLite version 3.31.0
([dateof:3.31.0]).  If an earlier version of SQLite attempts to read
a database file that contains a generated column in its schema, then







|







85
86
87
88
89
90
91
92
93
94
95
96
97
98
99

<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
directly or indirectly.

<li><p>
Every table must have at least one non-generated column.
</ol>

<h1>Compatibility</h1>

<p>Generated column support was added with SQLite version 3.31.0
([dateof:3.31.0]).  If an earlier version of SQLite attempts to read
a database file that contains a generated column in its schema, then