]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
CAST Oracle table_name, owner, others to VARCHAR(128)
authorMike Bayer <mike_mp@zzzcomputing.com>
Wed, 18 Aug 2021 14:48:16 +0000 (10:48 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 18 Aug 2021 15:53:26 +0000 (11:53 -0400)
commit9dd3184f7b48f0dd402dbf7db5f7f13d51483804
tree441ec58781fb986ce333f17a8bc47dcdc726c9a4
parentb09dbcf141afa516f55857b37396f91d1f2aae0f
CAST Oracle table_name, owner, others to VARCHAR(128)

Added a CAST(VARCHAR2(128)) to the "table name", "owner", and other
DDL-name parameters as used in reflection queries against Oracle system
views such as ALL_TABLES, ALL_TAB_CONSTRAINTS, etc to better enable
indexing to take place against these columns, as they previously would be
implicitly handled as NVARCHAR2 due to Python's use of Unicode for strings;
these columns are documented in all Oracle versions as being VARCHAR2 with
lengths varying from 30 to 128 characters depending on server version.
Additionally, test support has been enabled for Unicode-named DDL
structures against Oracle databases.

Fixes: #4486
Change-Id: I2787e3f8de1f656318692bd535d6a7f1cef1a841
doc/build/changelog/unreleased_14/4486.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/oracle/base.py
test/requirements.py