<p dir="auto"><strong>Migrated issue, originally created by Anonymous</strong></p>
<p dir="auto">If a exception raise in commit() function, rollback() function would be called and then the exception would be re-raised. The re-raising of the exception may be failed when sqlalchemy work with a coroutine framework such as evenlet or gevent due to a context switch(rollback is a bocking function, which will cause a context switch, and the exception may be cleared within the context switch). The issue could be simplely fixed by the following patch without risk.</p>
<hr>
<p dir="auto">Attachments: <a href="../wiki/imported_issue_attachments/2703/2703.patch">2703.patch</a> | <a href="../wiki/imported_issue_attachments/2703/2703.2.patch">2703.2.patch</a> | <a href="../wiki/imported_issue_attachments/2703/greenthread_compatibility_fix.patch">greenthread_compatibility_fix.patch</a> | <a href="../wiki/imported_issue_attachments/2703/greenthread_compatibility_fix_v2.patch">greenthread_compatibility_fix_v2.patch</a></p>
<p dir="auto"><strong>Migrated issue, originally created by Anonymous</strong></p>
<p dir="auto">We have an oracle database with multiple schemas defined.  When I try to add a table to a particular schema using SQA (see attached example), the operation fails because a table with the same name is found inside one or more of the other schemas, despite the fact that I'm specifying which schema to use in the Table definition.  When I turn engine echo on I see the following:</p>
<p dir="auto">2007-04-24 16:55:35,952 INFO sqlalchemy.engine.base.Engine.0x..54 select table_name from all_tables where table_name=:name<br>
2007-04-24 16:55:35,954 INFO sqlalchemy.engine.base.Engine.0x..54 {'name': 'TASK'}</p>
<p dir="auto">When I perform this query against the DB I get multiple rows returned.  The problem appears to be that this query does not account for the schema/owner in any way.</p>
<p dir="auto">Note that I have tried the same test using Postgres and it works as expected.</p>
<hr>
<p dir="auto">Attachments: <a href="../wiki/imported_issue_attachments/550/test.py">test.py</a></p>