Oracle doesn't query for relationships properly

[NullEntity]

Respawn/Respawn/DbAdapter.cs

Line 515 in 6159862

inner join all_CONSTRAINTS b on a.r_constraint_name=b.constraint_name

This join should also be filtering on: AND a.r_owner=b.owner
If you have the same constraint in two different schemas the query will return a relationship between the tables on different schemas. Adding a test for this would probably be a good idea, but I'm not too sure on how to test it.

[jbogard]

PR?

[FranksDevRepo]

I provided a PR for this issue since I ran into the same problem NullEntity mentioned on our test servers.
A possible work around is to invoke respawn by the schema owner. If respawn is invoked by system user, or a user with privileges on another schema, sometimes I experienced foreign key constraint violations on our test pipelines after calling respawn. I could track down the issue to using named foreign key constraints with same names in different schemas.
Hope this helps.