Infinite loop calling in_() with PGArray column

[Former user]

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.

[Mike Bayer]

agh this is that __getitem__() thing again! where we used to raise an exception on __iter__() to prevent this, but then someone complained about that, now what was the problem with that....

[Mike Bayer]

yes it was you! #2726 !

[Former user]

Agh, my arch-nemesis: last-year-me! : )

[Mike Bayer]

alrighty, just more checks in in_() for now

b87935ed4409cb57a88d5e84d4280d8f97be13ee 0.8

036cb93abfb44f4ab7fdb125eaaf2597a95a0187 0.9

[Mike Bayer]

Removing milestone: 0.8.xx (automated comment)