reflecting oracle synonym of synonym over dblink #11312
Labels
oracle
PRs (with tests!) welcome
a fix or feature which is appropriate to be implemented by volunteers
reflection
reflection of tables, columns, constraints, defaults, sequences, views, everything else
Milestone
Describe the bug
I get a table not found error when trying to reflect a synonym of a synonym on a dblink. I try reflecting the table as such
the queries that it runs are
The second query returns nothing. It appears that it is taking the
table_owner
field from the first query and then using that in the second query. However since this is a synonym of a synonym the truetable_owner
is not the same as the owner of the second synonym, which causes this to return no results.Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected
No response
SQLAlchemy Version in Use
2.0.25
DBAPI (i.e. the database driver)
oracledb 1.4.2
Database Vendor and Major Version
Oracle 19.0.0.0.0,
Python Version
3.11.7
Operating system
OSX
To Reproduce
Error
Additional context
No response
The text was updated successfully, but these errors were encountered: