Re: [Sqlalchemy-tickets] [sqlalchemy] #2780: str() call in make_proxy can get in the way w/ dialect specific operators

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

#2780: str() call in make_proxy can get in the way w/ dialect specific operators
------------------------------+-------------------------------
      Reporter:  zzzeek       |      Owner:  zzzeek
          Type:  defect       |     Status:  new
      Priority:  highest      |  Milestone:  0.8.xx
     Component:  sql          |   Severity:  major - 1-3 hours
    Resolution:               |   Keywords:
Progress State:  in progress  |
------------------------------+-------------------------------

Comment (by zzzeek):

 My guess as to how the original poster only uses the index operator in
 order_by and still sees this is because the eager load is trying to stick
 that column in the columns clause so that it can order the enclosing query
 the same way.   so for our purposes the bug is just this:

 {{{
 from sqlalchemy.dialects.postgresql import ARRAY

 from sqlalchemy import Integer
 from sqlalchemy.sql import table, column, select

 t = table('t', column('x', ARRAY(Integer)))

 s = select([t, t.c.x[5]])

 s.corresponding_column(t.c.x)
 }}}

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