# caused by

r = Resource()
Session.save(r)
# Session.flush()
list(Session.query(Charge).join("allocation").filter(Allocation.resource==r)

# Problem disappears with r4184, or if Session.flush() is uncommented


2008-03-03 13:15:20,186 INFO sqlalchemy.engine.base.Engine.0x..b0 BEGIN
2008-03-03 13:15:20,187 INFO sqlalchemy.engine.base.Engine.0x..b0 SELECT resources.id AS resources_id 
FROM resources 
WHERE resources.id = %s ORDER BY resources.id 
 LIMIT 0, 2
2008-03-03 13:15:20,187 INFO sqlalchemy.engine.base.Engine.0x..b0 [4L]
2008-03-03 13:15:20,199 INFO sqlalchemy.engine.base.Engine.0x..b0 INSERT INTO resources (id) VALUES (%s)
2008-03-03 13:15:20,199 INFO sqlalchemy.engine.base.Engine.0x..b0 [4L]
2008-03-03 13:15:20,213 INFO sqlalchemy.engine.base.Engine.0x..b0 SELECT charges.comment AS charges_comment, charges.amount AS charges_amount, charges.id AS charges_id, charges.datetime AS charges_datetime, charges.allocation_id AS charges_allocation_id 
FROM charges INNER JOIN allocations ON allocations.id = charges.allocation_id 
WHERE %s = allocations.resource_id ORDER BY charges.id
2008-03-03 13:15:20,213 INFO sqlalchemy.engine.base.Engine.0x..b0 [<object object at 0xf7fb6470>]
Traceback (most recent call last):
  File "recur_cl_test.py", line 8, in ?
    print list(charges)
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/orm/query.py", line 841, in __iter__
    return self._execute_and_instances(context)
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/orm/query.py", line 844, in _execute_and_instances
    result = self.session.execute(querycontext.statement, params=self._params, mapper=self.mapper, instance=self._refresh_instance)
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/orm/session.py", line 605, in execute
    return self.__connection(engine, close_with_result=True).execute(clause, params or {})
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/engine/base.py", line 846, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/engine/base.py", line 897, in execute_clauseelement
    return self._execute_compiled(elem.compile(dialect=self.dialect, column_keys=keys, inline=len(params) > 1), distilled_params=params)
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/engine/base.py", line 909, in _execute_compiled
    self.__execute_raw(context)
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/engine/base.py", line 918, in __execute_raw
    self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/engine/base.py", line 960, in _cursor_execute
    self.dialect.do_execute(cursor, statement, parameters, context=context)
  File "/home/janderso/lib/EasyInstall/SQLAlchemy-0.4.3-py2.4.egg/sqlalchemy/databases/mysql.py", line 1478, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 137, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
    raise errorclass, errorvalue
RuntimeError: maximum recursion depth exceeded