View Issue Details

IDProjectCategoryView StatusLast Update
0006486SymmetricDSBugpublic2024-06-10 20:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.15 
Target Version3.14.16Fixed in Version3.14.16 
Summary0006486: Wildcard trigger definitions do not remove existing triggers when adding a NOT table name to wild carded definition
DescriptionWhen you have a wild card trigger definition, and the triggers are already built on the tables that the trigger definition applies to, if you add a NOT constraint to the trigger definition list, the triggers on the table that has a NOT constraint does not get the triggers removed.

For example, if you have "*" for the source table name, and you change it to:
*,!Company

the triggers that exist on the Company table are not removed.
This issue ends up causing tables to have multiple sets of Insert, Update, and Delete triggers created on the table when another trigger defines triggers for the Company table.
Steps To Reproduce1. Configure nodes that have a wildcard definition for the source table names.
2. Make sure that all triggers are created for all tables that the wildcard definition matches.
3. Add a NOT constraint to remove one of the tables from the set.
4. After synching triggers, the triggers are not removed from the table that has the NOT constraint.
Tagstrigger

Relationships

related to 0006487 closedpmarzullo Wildcard trigger definitions do not remove existing triggers when adding a NOT table name to wild carded definition 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 21b8c6c2

2024-06-10 19:09:59

pmarzullo

Details Diff
0006486: Wildcard trigger definitions do not remove existing triggers
when adding a NOT table name to wild carded definition
Affected Issues
0006486
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

Issue History

Date Modified Username Field Change
2024-06-10 17:50 pmarzullo New Issue
2024-06-10 17:50 pmarzullo Status new => assigned
2024-06-10 17:50 pmarzullo Assigned To => pmarzullo
2024-06-10 17:50 pmarzullo Tag Attached: trigger
2024-06-10 18:38 pmarzullo Description Updated View Revisions
2024-06-10 18:55 pmarzullo Relationship added related to 0006487
2024-06-10 19:10 pmarzullo Status assigned => resolved
2024-06-10 19:10 pmarzullo Resolution open => fixed
2024-06-10 19:10 pmarzullo Fixed in Version => 3.14.16
2024-06-10 20:00 pmarzullo Changeset attached => SymmetricDS 3.14 21b8c6c2
2024-08-16 17:44 admin Status resolved => closed