View Issue Details

IDProjectCategoryView StatusLast Update
0005584SymmetricDSBugpublic2022-11-30 19:34
Reporteremiller Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.11 
Target Version3.12.20Fixed in Version3.12.20 
Summary0005584: Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened
DescriptionWhen 2 triggers have trigger IDs that are identical when shortened (e.g., test_table and tst_tbl) and there are no existing triggers installed on the tables, SymmetricDS does not append a number onto the end of any of the trigger names. This results in duplicate trigger names and causes trigger creation to fail.
TagsNo tags attached.

Relationships

has duplicate 0005588 closedpmarzullo Sync Triggers- Need to keep track of new trigger names created so that duplicates will not be created 
related to 0005585 closedpmarzullo Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened 
related to 0005586 closedpmarzullo Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 c22bc337

2022-11-15 15:49:58

pmarzullo

Details Diff
0005584: Trigger creation fails when 2 new triggers have trigger IDs
that are identical when shortened
Affected Issues
0005584
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ITriggerRouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

SymmetricDS: 3.12 c79f5570

2022-11-15 18:41:29

evan-miller-jumpmind

Details Diff
0005584: Added test for overlapping trigger names Affected Issues
0005584
mod - symmetric-core/src/test/java/org/jumpmind/symmetric/service/impl/AbstractTriggerRouterServiceTest.java Diff File
mod - symmetric-core/src/test/resources/test-schema.xml Diff File

Issue History

Date Modified Username Field Change
2022-11-14 19:21 emiller New Issue
2022-11-14 19:21 emiller Status new => assigned
2022-11-14 19:21 emiller Assigned To => emiller
2022-11-14 19:22 emiller Issue cloned: 0005585
2022-11-14 19:22 emiller Relationship added related to 0005585
2022-11-14 19:22 emiller Relationship added related to 0005586
2022-11-15 15:21 pmarzullo Relationship added has duplicate 0005588
2022-11-15 15:22 pmarzullo Assigned To emiller => pmarzullo
2022-11-15 16:00 pmarzullo Changeset attached => SymmetricDS 3.12 c22bc337
2022-11-15 16:07 pmarzullo Status assigned => resolved
2022-11-15 16:07 pmarzullo Resolution open => fixed
2022-11-15 16:07 pmarzullo Fixed in Version => 3.12.20
2022-11-15 19:00 Changeset attached => SymmetricDS 3.12 c79f5570
2022-11-30 19:34 admin Status resolved => closed