Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | State that the COLLATE operator does not change affinity. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | mistake |
Files: | files | file ages | folders |
SHA3-256: |
5395fed295aee03e17f57aefe54e08f9 |
User & Date: | drh 2019-06-11 02:51:24.092 |
Context
2019-06-11
| ||
02:51 | State that the COLLATE operator does not change affinity. (Leaf check-in: 5395fed295 user: drh tags: mistake) | |
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.
︙ | ︙ | |||
294 295 296 297 298 299 300 | real table (not a [VIEW] or subquery) then the expression has the same affinity as the table column. <ul> <li><p>^(Parentheses around the column name are ignored. Hence if X and Y.Z are column names, then (X) and (Y.Z) are also considered column names and have the affinity of the corresponding columns.)^ <li><p> | | > | | 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 | real table (not a [VIEW] or subquery) then the expression has the same affinity as the table column. <ul> <li><p>^(Parentheses around the column name are ignored. Hence if X and Y.Z are column names, then (X) and (Y.Z) are also considered column names and have the affinity of the corresponding columns.)^ <li><p> ^(Any operator applied to column names, including the no-op unary "+" operator but excluding the "COLLATE" operator, converts the column name into an expression which 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>".)^ |
︙ | ︙ |