[Sqlalchemy-tickets] [sqlalchemy] #1423: query.filter(cond).filter_by() produces invalid SQL

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

#1423: query.filter(cond).filter_by() produces invalid SQL
--------------------+-------------------------------------------------------
 Reporter:  guest   |          Owner:  zzzeek                
     Type:  defect  |         Status:  new                   
 Priority:  low     |      Milestone:                        
Component:  orm     |       Severity:  no triage selected yet
 Keywords:          |   Status_field:  awaiting triage       
--------------------+-------------------------------------------------------
 session.filter(some_cond).filter_by(**kwargs).first() produces broken SQL
 when kwargs is empty dictionary: ... WHERE <some_cond> AND  ORDER BY ...

 Here is error message from my real-life project:
 {{{
 ProgrammingError: (ProgrammingError) (1064, "You have an error in your SQL
 syntax; check the
 manual that corresponds to your MySQL server version for the right syntax
 to use near 'ORDER BY
 `Doc`.date DESC \n LIMIT 0, 1' at line 3") u'SELECT `Doc`.id AS `Doc_id`,
 `Doc`.type AS
 `Doc_type`, `Doc`.date AS `Doc_date`, `Doc`.state AS `Doc_state`,
 `Doc`.place AS `Doc_place`,
 `Doc`.title AS `Doc_title` \nFROM `Doc` \nWHERE `Doc`.state = %s AND
 ORDER BY `Doc`.date DESC
 \n LIMIT 0, 1' [4]
 }}}

 Using SQLAlchemy 0.5.4p1. This is probably related to the
 [http://www.sqlalchemy.org/trac/ticket/1011 ticket #1011].

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1423>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python