View Revisions: Issue #6922

Summary 0006922: Uninstall node action does not remove DDL capture function
Revision 2025-06-05 13:20 by josh-a-hicks
Steps To Reproduce Setup a node connected to SQL Server
Turn on DDL parameter trigger.capture.ddl.changes=true
Uninstall the node
Verify the sym_on_filtered_ddl is removed.
To check run a simple create table script on the database and would fail to fire the function and capture the change without sym runtime tables.
Revision 2025-06-05 20:48 by pbelov
Steps To Reproduce Setup a new node connected to any database, which supports DDL capture (PostgreSQL, SQL Server, ...) and has permissions to do so.
Turn on DDL capture parameter trigger.capture.ddl.changes=true
Ensure DDL triggers are installed.
Uninstall the node from the Manage->Nodes screen.
Verify the sym_on_filtered_ddl is NOT removed (fsym_on_filtered_ddl and fsym_on_filtered_ddl_drop in PostgreSQL).
To check run a simple create table script on the database and would fail to fire the function and capture the change without sym runtime tables.