Revision related metadata is left in DB after deleting revision

[ksankeerth]

Description

Revision related metadata is left in DB after deleting revision

Steps to Reproduce

• Create an API product
• Create multiple revisions
• Delete a revision from the Publisher UI
• Run the following query:
• SELECT * FROM AM_API_REVISION_METADATA
• WHERE REVISION_UUID NOT IN (SELECT REVISION_UUID FROM AM_REVISION);
• → Returns orphaned rows confirming the product-level bug (revision deletion does not clean up AM_API_REVISION_METADATA)

Version

4.6.0/4.0.0

Environment Details (with versions)

No response