fully qualify schema names in all cases

Issue #999 resolved
Mike Bayer repo owner created an issue

two schemas with the same tablename will produce a conflict currently. Patch is attached which turns on schema qualification across the board. Remove the redundant logic from the mssql.py module and others who may have hardcoded this; tests need to be added for PG,Oracle etc. to ensure that all SELECT/INSERT/UPDATE/DELETE works (as in, is accepted by the DB) with schema-qualified tables.

Comments (3)

  1. Former user Account Deleted

    (original author: ram) Have a look at tickets 594 and 973 for some potentially complicating factors.

  2. Mike Bayer reporter

    added some tests for PG and applied the patch in 7512b5e5482ea8a01095f98f82f1380f19a07110. Any DB that supports a schema-qualified tablename has to support it within column expressions as well (will leave it to the userbase to reveal some weird MaxDB/Firebird glitch).

    also commented on the above MS-SQL tickets which aren't directly impacted by this.

  3. Log in to comment