[Sqlalchemy-tickets] Issue #3570: Weird behavior of `delete` using different query param type (zzzeek/sqlalchemy)

[fengsp <iss...@bi...>]

New issue 3570: Weird behavior of `delete` using different query param type
https://bitbucket.org/zzzeek/sqlalchemy/issues/3570/weird-behavior-of-delete-using-different

fengsp:

>>> t
<Text 643544210980470784>
>>> print t.__dict__
{'content': u'ha', 'created_ts': 1446212896L, '_sa_instance_state': <sqlalchemy.orm.state.InstanceState object at 0x100c615d0>, 'updated_ts': 1446212896L, 'id': 643544210980470784L}
>>> models.Text.query.filter_by(id='643544210980470784').delete()
1L
>>> session.commit()
>>> print t.__dict__
{'_sa_instance_state': <sqlalchemy.orm.state.InstanceState object at 0x100c615d0>}

The t's attribute can not be accessed any more, I try it again with id as integer, and get different result:

>>> t
<Text 643544531031031808>
>>> print t.__dict__
{'content': u'ah', 'created_ts': 1446212972L, '_sa_instance_state': <sqlalchemy.orm.state.InstanceState object at 0x108ca45d0>, 'updated_ts': 1446212972L, 'id': 643544531031031808L}
>>> models.Text.query.filter_by(id=643544531031031808).delete()
1L
>>> session.commit()
>>> print t.__dict__
{'content': u'ah', 'created_ts': 1446212972L, '_sa_instance_state': <sqlalchemy.orm.state.InstanceState object at 0x108ca45d0>, 'updated_ts': 1446212972L, 'id': 643544531031031808L}