Table cannot be added to Oracle DB if one of same name exists under a different schema

[Former user]

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:

2007-04-24 16:55:35,952 INFO sqlalchemy.engine.base.Engine.0x..54 select table_name from all_tables where table_name=:name 2007-04-24 16:55:35,954 INFO sqlalchemy.engine.base.Engine.0x..54 {'name': 'TASK'}

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.

Note that I have tried the same test using Postgres and it works as expected.

[Former user]

Test case for ticket

[Mike Bayer]

note that in the ticket duplicated here, i.e. #233, postgres is the only DB where we've implemented this so far. patches welcome on 233.