Add Testcase demonstrating fail on join

When a join is attempted while the transaction is in COMMITFAILED
zope.sqlalchemy is left in an inconsistent state.

See https://github.com/zopefoundation/zope.sqlalchemy/issues/2