/ File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of test/resolver01.test

2015-04-23
13:37
Fix a faulty assert() in the "AS" alias resolution logic of the parser. file: [f4022aca] check-in: [b5e43602] user: drh branch: trunk, size: 6151
2014-06-10
20:18
Proposed change to the fix for ticket [1c69be2dafc28b] such that legacy applications that were exploiting the older buggy behavior in SQLite continue to work. file: [677dd35b] check-in: [401a0ca3] user: drh branch: group-by-name-resolution, size: 6786
2013-08-15
22:40
Make sure that GROUP BY terms select input column names in preference to output column names, in compliance with the SQL standard. Ticket [1c69be2dafc28]. file: [33abf37f] check-in: [f2d175f9] user: drh branch: trunk, size: 5923
20:24
Bare identifiers in ORDER BY clauses bind more tightly to output column name, but identifiers in expressions bind more tightly to input column names. This is a compromise between SQL92 and SQL99 behavior and is what PostgreSQL and MS-SQL do. Ticket [f617ea3125e9c]. file: [a98ed8a2] check-in: [c78b357c] user: drh branch: trunk, size: 4221
2013-04-13
19:59
Only consider AS names from the result set as candidates for resolving identifiers in the WHERE clause if there are no other matches. In the ORDER BY clause, AS names take priority over any column names. Candidate fix for ticket [2500cdb9be]. file: [d1b487fc] check-in: [ad53924d] user: drh branch: tkt-2500cdb9be, size: 1012 Added