Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a minor error in the datatype documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | a5590f5f81395b8f3a78d6b91cf23a66 |
| User & Date: | drh 2019-04-08 18:06:37 |
Context
|
2019-04-13
| ||
| 15:33 | Additional suggestions for defense against dark arts. check-in: b41d1c753f user: drh tags: trunk | |
|
2019-04-08
| ||
| 18:08 | Fix a minor error in the datatype documentation. Leaf check-in: 87bef3d123 user: drh tags: branch-3.27 | |
| 18:06 | Fix a minor error in the datatype documentation. check-in: a5590f5f81 user: drh tags: trunk | |
|
2019-04-05
| ||
| 21:18 | Remove an obsolete reference to the addopcodes.tcl script. check-in: efe862885f user: drh tags: trunk | |
Changes
Changes to pages/datatype3.in.
323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 |
<blockquote><pre>
CREATE TABLE t1(a INT, b TEXT, c REAL);
CREATE VIEW v1(x,y,z) AS SELECT b, a+c, 42 FROM t1 WHERE b!=11;
</pre></blockquote>
<p>The affinity of the v1.x column will be the same as the affinity
of t1.b (INTEGER), since v1.x maps directly into t1.b. But
columns v1.y and v1.z both have no affinity, since those columns
map into expression a+c and 42, and expressions always have no
affinity.
<p>When the [SELECT] statement that implements a [VIEW] or
FROM-clause subquery is a [compound SELECT] then the affinity of
each supposed column of the VIEW or subquery will
|
| |
323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 |
<blockquote><pre>
CREATE TABLE t1(a INT, b TEXT, c REAL);
CREATE VIEW v1(x,y,z) AS SELECT b, a+c, 42 FROM t1 WHERE b!=11;
</pre></blockquote>
<p>The affinity of the v1.x column will be the same as the affinity
of t1.b (TEXT), since v1.x maps directly into t1.b. But
columns v1.y and v1.z both have no affinity, since those columns
map into expression a+c and 42, and expressions always have no
affinity.
<p>When the [SELECT] statement that implements a [VIEW] or
FROM-clause subquery is a [compound SELECT] then the affinity of
each supposed column of the VIEW or subquery will
|