]> 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:39:55 +0000 (19:39 -0400)
commitb1cd6e4295b07e01983deb2845f6e22a059f5b76
tree3daf50c7d1410bbb2a40e9c2bda74d2dbe1cfba6
parent13766228c19954f8860de6a2401c44a32832ae3e
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
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