[Sqlalchemy-tickets] [sqlalchemy] #2957: Infinite loop calling in_() with PGArray column

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

#2957: Infinite loop calling in_() with PGArray column
----------------------+-----------------------------------------
 Reporter:  gthb      |           Owner:  zzzeek
     Type:  defect    |          Status:  new
 Priority:  medium    |       Milestone:
Component:  postgres  |        Severity:  no triage selected yet
 Keywords:            |  Progress State:  awaiting triage
----------------------+-----------------------------------------
 This enters an infinite loop calling `in_()`:

 {{{
 from sqlalchemy import Column, Integer, Table, MetaData, literal
 from sqlalchemy.dialects.postgresql.base import PGArray

 tbl = Table('foo', MetaData(), Column('bar', PGArray(Integer)))
 literal('3').in_(tbl.c.bar)
 }}}

 An array as the right side of an `IN` operator isn't valid in PostgreSQL
 of course, but an infinite loop is still a bit too drastic.

 Happens in 0.8.4 as well as on the bleeding edge.

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