From 0c294d356f7cbb22a8da3fc4552a9c4232c3f69a Mon Sep 17 00:00:00 2001 From: Gord Thompson Date: Mon, 9 Mar 2020 17:50:53 -0400 Subject: Reflect comments from any table accessible by the current user Fixed a reflection bug where table comments could only be retrieved for tables actually owned by the user but not for tables visible to the user but owned by someone else. Pull request courtesy Dave Hirschfeld. Fixes: #5146 Closes: #5147 Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5147 Pull-request-sha: 0651e3bed05923765203b37986a2506dac3e634e Change-Id: If970fda10d6adf04d926d38df1a567df1de9f7b9 --- lib/sqlalchemy/dialects/oracle/base.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy/dialects/oracle/base.py') diff --git a/lib/sqlalchemy/dialects/oracle/base.py b/lib/sqlalchemy/dialects/oracle/base.py index f6de4de68..c89e441b9 100644 --- a/lib/sqlalchemy/dialects/oracle/base.py +++ b/lib/sqlalchemy/dialects/oracle/base.py @@ -1760,7 +1760,7 @@ class OracleDialect(default.DefaultDialect): COMMENT_SQL = """ SELECT comments - FROM user_tab_comments + FROM all_tab_comments WHERE table_name = :table_name """ -- cgit v1.2.1