From 3d8d366e1b5e2f0caa728a741dad5e467b67c7ac Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 7 Dec 2022 15:54:59 -0500 Subject: 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 --- lib/sqlalchemy/dialects/oracle/base.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/dialects/oracle/base.py b/lib/sqlalchemy/dialects/oracle/base.py index 41b9ac43d..dc2b011af 100644 --- a/lib/sqlalchemy/dialects/oracle/base.py +++ b/lib/sqlalchemy/dialects/oracle/base.py @@ -859,7 +859,7 @@ class OracleCompiler(compiler.SQLCompiler): def visit_table_valued_column(self, element, **kw): text = super().visit_table_valued_column(element, **kw) - text = "COLUMN_VALUE " + text + text = text + ".COLUMN_VALUE" return text def default_from(self): -- cgit v1.2.1