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 | SQL archive |
| Timelines: | family | ancestors | mistake |
| Files: | files | file ages | folders |
| SHA3-256: |
5395fed295aee03e17f57aefe54e08f9 |
| User & Date: | drh 2019-06-11 02:51:24 |
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 301 302 303 304 305 306 307 308 309 |
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 operators applied to column names, including the no-op unary "+" operator, convert 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>".)^ |
| > | |
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>".)^ |