Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | An extra sentence of clarification on explicit collating sequences on an IN operator. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
568e2f047e0e807ac2245d10d866711e |
User & Date: | drh 2020-05-20 16:59:42.635 |
Context
2020-05-20
| ||
17:42 | Documentation updates based on code review. (check-in: 0bdeed702c user: drh tags: trunk) | |
16:59 | An extra sentence of clarification on explicit collating sequences on an IN operator. (check-in: 568e2f047e user: drh tags: trunk) | |
15:02 | Update the change log. (check-in: 18e8d6c077 user: drh tags: trunk) | |
Changes
Changes to pages/datatype3.in.
︙ | ︙ | |||
673 674 675 676 677 678 679 680 681 682 683 684 685 686 | ^The expression "x BETWEEN y and z" is logically equivalent to two comparisons "x >= y AND x <= z" and works with respect to collating functions as if it were two separate comparisons. ^(The expression "x IN (SELECT y ...)" is handled in the same way as the expression "x = y" for the purposes of determining the collating sequence.)^ ^(The collating sequence used for expressions of the form "x IN (y, z, ...)" is the collating sequence of x.)^ </p> <p> ^Terms of the ORDER BY clause that is part of a [SELECT] statement may be assigned a collating sequence using the [COLLATE operator], in which case the specified collating function is used for sorting. | > > > | 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 | ^The expression "x BETWEEN y and z" is logically equivalent to two comparisons "x >= y AND x <= z" and works with respect to collating functions as if it were two separate comparisons. ^(The expression "x IN (SELECT y ...)" is handled in the same way as the expression "x = y" for the purposes of determining the collating sequence.)^ ^(The collating sequence used for expressions of the form "x IN (y, z, ...)" is the collating sequence of x.)^ If an explicit collating sequence is required on an IN operator it should be applied to the left operand, like this: "x COLLATE nocase IN (y,z, ...)". </p> <p> ^Terms of the ORDER BY clause that is part of a [SELECT] statement may be assigned a collating sequence using the [COLLATE operator], in which case the specified collating function is used for sorting. |
︙ | ︙ |