Re: [Sqlalchemy-tickets] [sqlalchemy] #1452: can't construct update with order by

[sqlalchemy <mi...@zz...>]

#1452: can't construct update with order by
-----------------------------------------+----------------------------------
    Reporter:  guest                     |       Owner:  zzzeek              
        Type:  enhancement               |      Status:  new                 
    Priority:  low                       |   Milestone:  0.6.xx              
   Component:  sql                       |    Severity:  minor - half an hour
  Resolution:                            |    Keywords:                      
Status_field:  needs questions answered  |  
-----------------------------------------+----------------------------------
Changes (by zzzeek):

  * status_field:  awaiting triage => needs questions answered
  * component:  orm => sql
  * severity:  no triage selected yet => minor - half an hour
  * milestone:  => 0.6.xx

Comment:

 i seriously doubt "UPDATE...ORDER BY" is standard SQL (although if it is,
 please let me know since that will allow it as a core feature).
 therefore just use a `text()` clause for this, or construct your own
 variant of `update()` using the recipe at
 http://www.sqlalchemy.org/docs/05/reference/ext/compiler.html .

 I also wonder why this issue is not raised by common "nested sets"
 tutorials such as celko's ?

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1452#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python