recursion bug when filtering with .in_() on a mapped property

The (attached, also partially quoted below) test case results in:

RuntimeError: maximum recursion depth exceeded

This appears to have something to do with filtering a query using .in() when what is being tested is a mapped property. I'm not sure if the ability to filter in this particular way is meant to be supported at this time or not, but it seemed worth submitting since in general SA seems to work toward making mapped properties behave as much as possible like ordinary python properties.

Thanks! - Eric

nodes = Table('nodes', metadata,
    Column('id', Integer, primary_key=True),
    Column('parent_id', Integer, ForeignKey('nodes.id'))
)
fribbits = Table('fribbits', metadata,
                 Column('id', Integer, primary_key=True),
                 Column('node_id', Integer, ForeignKey('nodes.id'))
)
class Node(object):
    def list_to_root(self):
        if self.parent_id == None:
            return [       else:
            result = [](]
)
            result.append(self)
            return result + self.parent.list_to_root()

mapper(Node, nodes, properties={
        'parent': relation(Node, uselist=False, remote_side=[nodes.c.id](nodes.c.id))
        })
mapper(Fribbit, fribbits, properties={
    'node': relation(Node, uselist=False)
    })

f = session.query(Fribbit).get(4444)
n = f.node
l = n.list_to_root()

print "*working case* here are all Fribbits whose nodes are in that ancestry:",
y = map(lambda item:item.id, l)
t = session.query(Fribbit).filter(Fribbit.node_id.in_(y)).all()
print t

print "**broken case** here are all Fribbits whose nodes are in that ancestry:",
z = session.query(Fribbit).filter(Fribbit.node.in_(l)).all()
print z

Comments (4)