Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Augment the affinity rules to state that the affinity of a COLLATE operator is the same as the affinity of its left-hand side. Ticket https://www.sqlite.org/src/tktview/d60b3cd7cb |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
722f0828b3074e894cb57cb886b17e12 |
| User & Date: | drh 2019-06-11 02:59:27 |
Context
|
2019-06-11
| ||
| 13:40 | Clarify how mathematical operators function given string or blob operands. Ticket https://www.sqlite.org/src/tktview/1819598c09 (check-in: e0f700bb6c user: drh tags: trunk) | |
| 02:59 | Augment the affinity rules to state that the affinity of a COLLATE operator is the same as the affinity of its left-hand side. Ticket https://www.sqlite.org/src/tktview/d60b3cd7cb (check-in: 722f0828b3 user: drh tags: trunk) | |
|
2019-05-23
| ||
| 19:37 | Add a row for 3.29.0 to the speed-and-size chart. (check-in: 7502249d01 user: drh tags: trunk) | |
Changes
Changes to pages/datatype3.in.
| ︙ | ︙ | |||
303 304 305 306 307 308 309 310 311 312 313 314 315 316 |
always has no affinity. Hence even if X and Y.Z are column names, the
expressions +X and +Y.Z are not column names and have no affinity.)^
</ul>
<li><p>^(An expression of the form "CAST(<i>expr</i> AS <i>type</i>)"
has an affinity that is the same as a column with a declared
type of "<i>type</i>".)^
<li><p>^Otherwise, an expression has no affinity.
</ul>
<tcl>hd_fragment affview {rules for determining column affinity in VIEWs}</tcl>
<h2>Column Affinity For Views And Subqueries</h2>
| > > | 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 |
always has no affinity. Hence even if X and Y.Z are column names, the
expressions +X and +Y.Z are not column names and have no affinity.)^
</ul>
<li><p>^(An expression of the form "CAST(<i>expr</i> AS <i>type</i>)"
has an affinity that is the same as a column with a declared
type of "<i>type</i>".)^
<li><p>^A COLLATE operator has the same affinity as its left-hand side operand.
<li><p>^Otherwise, an expression has no affinity.
</ul>
<tcl>hd_fragment affview {rules for determining column affinity in VIEWs}</tcl>
<h2>Column Affinity For Views And Subqueries</h2>
|
| ︙ | ︙ |