]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
add Oracle-specific parameter escapes for expanding params
authorMike Bayer <mike_mp@zzzcomputing.com>
Mon, 24 Oct 2022 23:24:11 +0000 (19:24 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Mon, 24 Oct 2022 23:41:32 +0000 (19:41 -0400)
commit922f11f6f26c5ba0481a12d7a650823f922be57c
treea24671f4000eff78de4f979a07685ff412c6e00b
parentb3525904ba8abe323fcd84e1b3674bea4274a59c
add Oracle-specific parameter escapes for expanding params

Fixed issue where bound parameter names, including those automatically
derived from similarly-named database columns, which contained characters
that normally require quoting with Oracle would not be escaped when using
"expanding parameters" with the Oracle dialect, causing execution errors.
The usual "quoting" for bound parameters used by the Oracle dialect is not
used with the "expanding parameters" architecture, so escaping for a large
range of characters is used instead, now using a list of characters/escapes
that are specific to Oracle.

Fixes: #8708
Change-Id: I90c24e48534e1b3a4c222b3022da58159784d91a
(cherry picked from commit b1cd6e4295b07e01983deb2845f6e22a059f5b76)
doc/build/changelog/unreleased_14/8708.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/oracle/cx_oracle.py
lib/sqlalchemy/testing/suite/test_dialect.py