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