OpenMetadata
OpenMetadata copied to clipboard
open-metadata
Oracle connector bug with cases
Affected module Oracle connector (backend)
Describe the bug When using SQLAlchemy Inspector in Oracle connector we face a problem with case sensitivity/insensitivity If we check Oracle case insensitive table/schema/column names, they all will be uppercase SQLAlchemy sees all them lowercased
To Reproduce
The bug we found:
In Oracle we have two tables with same name except for case (Oracle allows us to do so):
But if we see them in OpenMetadata:
They have completely similar structure and (probably) changed casing.
Expected behavior We expect table/column/schema names to be shown as they are in source system (Oracle).
Version:
- OS: Ubuntu Linux/Kubernetes
- Python version: 3.9
- OpenMetadata version: 1.3.2-1.4.8
Additional context The problem was described here: https://github.com/open-metadata/OpenMetadata/issues/15471#issuecomment-2321095946
I have found bugs which I think related to the problems with case sensetivity:
- problems with displaying lineages of the tables and views with the same names (issue #17971)
- problems with links to the tables of the foreign keys Ex. we have a table 'A' which has a key to the table 'B'. When I trying to go to the table 'B' by clicking on the link on the frame 'Table Constraints' I get an error "table instance for ... not found". I realized that this is due to the fact that the table name on the frame is in lowercase letters ('b'), while the table itself is in uppercase.
