SQLite

View Ticket
Login
Ticket Hash: 2500cdb9be05bca950d64428ad14dba971736e9f
Title: COLLATE in ORDER BY clause breaks name resolution
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2013-04-14 23:51:40
Version Found In: 3.7.16.2
User Comments:
drh added on 2013-04-12 16:44:22:

In the following SQL, the first query works but the second query (the one with the COLLATE clause) gives a parsing error:

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;

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].