View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006486 | SymmetricDS | Bug | public | 2024-06-10 17:50 | 2024-06-10 20:00 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.15 | ||||
| Target Version | 3.14.16 | Fixed in Version | 3.14.16 | ||
| Summary | 0006486: Wildcard trigger definitions do not remove existing triggers when adding a NOT table name to wild carded definition | ||||
| Description | When 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 Reproduce | 1. 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. | ||||
| Tags | trigger | ||||
|
SymmetricDS: 3.14 21b8c6c2 2024-06-10 19:09:59 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 | ||
| 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 |