Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | In datatypes explainer, note that "Determination of Column Affinity" section does not apply to STRICT tables. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
bbba322a094b19d9af041c01ab1d1b0e |
| User & Date: | larrybr 2022-04-12 00:22:10.386 |
| Original Comment: | In datatypes explainer, note that "Determination of Column Affinity" section does apply to STRICT tables. |
Context
|
2022-04-27
| ||
| 09:17 | Cherry-pick minor documentation fixes from trunk. (check-in: c869cc4a55 user: drh tags: branch-3.38) | |
|
2022-04-13
| ||
| 13:11 | Update the change log, syntax diagrams, and SELECT documentation to describe RIGHT and FULL JOIN. More work to be done on this. (check-in: 7dc766ebe1 user: drh tags: trunk) | |
|
2022-04-12
| ||
| 00:22 | In datatypes explainer, note that "Determination of Column Affinity" section does not apply to STRICT tables. (check-in: bbba322a09 user: larrybr tags: trunk) | |
|
2022-04-10
| ||
| 15:38 | Add poor locking to the reasons to avoid DB-over-network. (check-in: c1e2fd15ff user: larrybr tags: trunk) | |
Changes
Changes to pages/datatype3.in.
| ︙ | ︙ | |||
194 195 196 197 198 199 200 |
<p>^A column with affinity BLOB does not prefer one storage class over
another and no attempt is made to coerce data from one storage class into
another.</p>
<tcl>hd_fragment affname {rules for determining column affinity}</tcl>
<h2>Determination Of Column Affinity</h2>
| > | | 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 |
<p>^A column with affinity BLOB does not prefer one storage class over
another and no attempt is made to coerce data from one storage class into
another.</p>
<tcl>hd_fragment affname {rules for determining column affinity}</tcl>
<h2>Determination Of Column Affinity</h2>
<p>For tables not declared as [STRICT],
^(the affinity of a column is determined by the declared type
of the column, according to the following rules in the order shown:)^</p>
<ol>
<li><p>^If the declared type contains the string "INT" then it
is assigned INTEGER affinity.</p>
<li><p>^If the declared type of the column contains any of the strings
|
| ︙ | ︙ |