diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-12-07 15:54:59 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-12-07 17:28:49 -0500 |
| commit | 3d8d366e1b5e2f0caa728a741dad5e467b67c7ac (patch) | |
| tree | 3aaea9628c0b3cddd8e4f23945b7627bfc7aa052 /doc | |
| parent | 59f5beff1928e752b33d65a541cd68295ae0a5f1 (diff) | |
| download | sqlalchemy-3d8d366e1b5e2f0caa728a741dad5e467b67c7ac.tar.gz | |
Oracle COLUMN_VALUE is a column name, not a keyword
Fixed issue in Oracle compiler where the syntax for
:meth:`.FunctionElement.column_valued` was incorrect, rendering the name
``COLUMN_VALUE`` without qualifying the source table correctly.
Fixes: #8945
Change-Id: Ia04bbdc68168e78b67a74bb3834a63f5d5000627
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/build/changelog/unreleased_14/8827.rst | 13 | ||||
| -rw-r--r-- | doc/build/changelog/unreleased_14/8945.rst | 8 | ||||
| -rw-r--r-- | doc/build/tutorial/data_select.rst | 2 |
3 files changed, 17 insertions, 6 deletions
diff --git a/doc/build/changelog/unreleased_14/8827.rst b/doc/build/changelog/unreleased_14/8827.rst index d71a30db5..b389ff771 100644 --- a/doc/build/changelog/unreleased_14/8827.rst +++ b/doc/build/changelog/unreleased_14/8827.rst @@ -3,8 +3,11 @@ :tickets: 8827 :versions: 2.0.0b4 - Fixed a series of issues regarding positionally rendered bound parameters, - such as those used for SQLite, asyncpg, MySQL and others. Some compiled - forms would not maintain the order of parameters correctly, such as the - PostgreSQL ``regexp_replace()`` function as well as within the "nesting" - feature of the :class:`.CTE` construct first introduced in :ticket:`4123`. + Fixed a series of issues regarding the position and sometimes the identity + of rendered bound parameters, such as those used for SQLite, asyncpg, + MySQL, Oracle and others. Some compiled forms would not maintain the order + of parameters correctly, such as the PostgreSQL ``regexp_replace()`` + function, the "nesting" feature of the :class:`.CTE` construct first + introduced in :ticket:`4123`, and selectable tables formed by using the + :meth:`.FunctionElement.column_valued` method with Oracle. + diff --git a/doc/build/changelog/unreleased_14/8945.rst b/doc/build/changelog/unreleased_14/8945.rst new file mode 100644 index 000000000..e1b4bd693 --- /dev/null +++ b/doc/build/changelog/unreleased_14/8945.rst @@ -0,0 +1,8 @@ +.. change:: + :tags: bug, oracle + :tickets: 8945 + :versions: 2.0.0b5 + + Fixed issue in Oracle compiler where the syntax for + :meth:`.FunctionElement.column_valued` was incorrect, rendering the name + ``COLUMN_VALUE`` without qualifying the source table correctly. diff --git a/doc/build/tutorial/data_select.rst b/doc/build/tutorial/data_select.rst index 64b9cef8a..206171988 100644 --- a/doc/build/tutorial/data_select.rst +++ b/doc/build/tutorial/data_select.rst @@ -1753,7 +1753,7 @@ it is usable for custom SQL functions:: >>> from sqlalchemy.dialects import oracle >>> stmt = select(func.scalar_strings(5).column_valued("s")) >>> print(stmt.compile(dialect=oracle.dialect())) - SELECT COLUMN_VALUE s + SELECT s.COLUMN_VALUE FROM TABLE (scalar_strings(:scalar_strings_1)) s |