Re: [Sqlalchemy-tickets] [sqlalchemy] #2538: LIMIT/OFFSET workaround for mssql loses auto-correlati
Brought to you by:
zzzeek
From: sqlalchemy <mi...@zz...> - 2012-08-31 02:32:48
|
#2538: LIMIT/OFFSET workaround for mssql loses auto-correlation for the ORDER BY clause ------------------------------+---------------------------------- Reporter: sayap | Owner: Type: defect | Status: new Priority: medium | Milestone: 0.7.9 Component: mssql | Severity: minor - half an hour Resolution: | Keywords: Progress State: in progress | ------------------------------+---------------------------------- Comment (by sayap): The extra parens added by my original diff breaks ORDER BY with DESC, as it generate clauses such as `ROW_NUMBER() OVER (ORDER BY (xxx.id DESC))`. I have attached another diff without this problem. -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2538#comment:5> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |