Re: [Sqlalchemy-tickets] [sqlalchemy] #2948: better replacement of columns w bound values on "local" side for lazy load

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

#2948: better replacement of columns w bound values on "local" side for lazy load
------------------------------+-------------------------------
      Reporter:  mkadin       |      Owner:  zzzeek
          Type:  defect       |     Status:  new
      Priority:  high         |  Milestone:  0.9.3
     Component:  orm          |   Severity:  major - 1-3 hours
    Resolution:               |   Keywords:
Progress State:  in progress  |
------------------------------+-------------------------------

Comment (by zzzeek):

 hmmm nope, all the way back to 0.6.9 it still renders "FROM persons,
 cities WHERE ? = persons.city_id AND cities.deleted_at IS NULL", so this
 would be a new behavior.

 the new query is:

 {{{
 SELECT persons.id AS persons_id, persons.name AS persons_name,
 persons.deleted_at AS persons_deleted_at, persons.city_id AS
 persons_city_id
 FROM persons
 WHERE ? = persons.city_id AND ? IS NULL

 2014-02-09 14:24:18,009 INFO sqlalchemy.engine.base.Engine (1, '2014-02-09
 14:24:18.006459')
 }}}

 so whatever that second "?" is determines what we are comparing to NULL.

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