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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 3103f83e9e216cf7fd3d56408ab047d949dfa0512ada62415c3babe0e8f8989a
User & Date: drh 2019-10-29 03:35:58
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/gencol.in.

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

<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
that earlier version will perceive the generated column syntax as an
error and will report that the database schema is corrupt.







|









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

<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
that earlier version will perceive the generated column syntax as an
error and will report that the database schema is corrupt.