(text/x-fossil-wiki)
In the following SQL, the first query works but the second query (the one
with the COLLATE clause) gives a parsing error:
<blockquote><verbatim>
CREATE TABLE t1(x, y); INSERT INTO t1 VALUES(11,22);
CREATE TABLE t2(y, z); INSERT INTO t2 VALUES(33,44);
SELECT 1 AS y FROM t1, t2 ORDER BY y;
SELECT 2 AS y FROM t1, t2 ORDER BY y COLLATE nocase;
</verbatim></blockquote>
This problem appears to have been introduced in version 3.7.15 by
check-in [8542e6180d4321d45] which was a fix for another problem
described by ticket [71e333e7d2e642af].
|