]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
denormalize "public" schema to "PUBLIC"
authorMike Bayer <mike_mp@zzzcomputing.com>
Thu, 9 Mar 2023 16:49:46 +0000 (11:49 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Thu, 9 Mar 2023 21:49:38 +0000 (16:49 -0500)
commit33ae862c054c4ab167aeab8cdc499b863c0f70a9
tree7cc64510122aee02ad13f134270fc769a2100103
parent9c0715181de6f03543c7ac9038c481f57f773d49
denormalize "public" schema to "PUBLIC"

Fixed reflection bug where Oracle "name normalize" would not work correctly
for reflection of symbols that are in the "PUBLIC" schema, such as
synonyms, meaning the PUBLIC name could not be indicated as lower case on
the Python side for the :paramref:`_schema.Table.schema` argument. Using
uppercase "PUBLIC" would work, but would then lead to awkward SQL queries
including a quoted ``"PUBLIC"`` name as well as indexing the table under
uppercase "PUBLIC", which was inconsistent.

Fixes: #9459
Change-Id: I989bd1e794a5b5ac9aae4f4a8702f14c56cd74c2
doc/build/changelog/unreleased_20/9459.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/oracle/base.py
test/dialect/oracle/test_reflection.py