/ All files named "test/resolver01.test"
Login

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

History for test/resolver01.test

2015-04-23
13:37
[f4022aca] part of check-in [b5e43602] Fix a faulty assert() in the "AS" alias resolution logic of the parser. (check-in: [b5e43602] user: drh branch: trunk, size: 6151)
2014-06-10
20:18
[677dd35b] part of check-in [401a0ca3] Proposed change to the fix for ticket [1c69be2dafc28b] such that legacy applications that were exploiting the older buggy behavior in SQLite continue to work. (check-in: [401a0ca3] user: drh branch: group-by-name-resolution, size: 6786)
2013-08-15
22:40
[33abf37f] part of check-in [f2d175f9] Make sure that GROUP BY terms select input column names in preference to output column names, in compliance with the SQL standard. Ticket [1c69be2dafc28]. (check-in: [f2d175f9] user: drh branch: trunk, size: 5923)
20:24
[a98ed8a2] part of check-in [c78b357c] 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]. (check-in: [c78b357c] user: drh branch: trunk, size: 4221)
2013-04-13
19:59
Added: [d1b487fc] part of check-in [ad53924d] 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]. (check-in: [ad53924d] user: drh branch: tkt-2500cdb9be, size: 1012)