open-metadata / OpenMetadata

OpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
https://open-metadata.org
Apache License 2.0
5.26k stars 994 forks source link

Oracle lineage issues with tables and views of the same name #17971

Open KsM00000 opened 3 days ago

KsM00000 commented 3 days ago

Affected module UI

Describe the bug We have views and tables with the same names. Recently I realised that our view 'a_link' displays wrong lineage becuase it displays lineage of the deleted table 'A_LINK'.

I have reached out to the community on Slack and after some troubleshooting I was told to open a ticket here.

To Reproduce

example

After I hard deleted the table, view started to display correct lineage.

fix

Expected behavior We expect tables to show the correct lineage.

Version:

Additional context I think the bug is related to the issue #17796