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: |
3103f83e9e216cf7fd3d56408ab047d9 |
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
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.
|