Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Fix a recently introduced error regarding collation sequences and compounds SELECT statements.|
|Timelines:||family | ancestors | descendants | both | trunk|
|Files:||files | file ages | folders|
|User & Date:||dan 2010-09-14 18:57:40|
|19:10||Adding additional comparison operators to the list in datatype3.html. check-in: a43ee1e871 user: drh tags: trunk|
|18:57||Fix a recently introduced error regarding collation sequences and compounds SELECT statements. check-in: 8d9fe20890 user: dan tags: trunk|
|13:25||Add <> to the list of comparison operators in datatype3.html. check-in: 838bd2b455 user: drh tags: trunk|
Changes to pages/lang.in.
2853 2853 right SELECTs. ^The EXCEPT operator returns the subset of rows returned by the 2854 2854 left SELECT that are not also returned by the right-hand SELECT. ^Duplicate 2855 2855 rows are removed from the results of INTERSECT and EXCEPT operators before the 2856 2856 result set is returned. 2857 2857 2858 2858 <p>^For the purposes of determining duplicate rows for the results of compound 2859 2859 SELECT operators, NULL values are considered equal to other NULL values and 2860 -distinct from all non-NULL values. ^The collation sequences to compare text 2861 -values values are determined as if the columns of the left and right-hand 2860 +distinct from all non-NULL values. ^The collation sequence used to compare 2861 +two text values is determined as if the columns of the left and right-hand 2862 2862 SELECT statements were the left and right-hand operands of the equals (=) 2863 -operator. ^No affinity transformations are applied to any values when 2864 -comparing rows as part of a compound SELECT. 2863 +operator, except that greater precedence is not assigned to a collation 2864 +sequence specified with the postfix COLLATE operator. ^No affinity 2865 +transformations are applied to any values when comparing rows as part of a 2866 +compound SELECT. 2865 2867 2866 2868 <p>^(When three or more simple SELECTs are connected into a compound SELECT, 2867 2869 they group from left to right. In other words, if "A", "B" and "C" are all 2868 2870 simple SELECT statements, (A op B op C) is processed as ((A op B) op C).)^ 2869 2871 2870 2872 </p> 2871 2873