View Issue Details

IDProjectCategoryView StatusLast Update
0004680SymmetricDSBugpublic2021-01-11 13:47
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.6Fixed in Version3.12.6 
Summary0004680: Spaces in sym_trigger fields causes create trigger failure
DescriptionOn sym_trigger, some of the fields will allow just spaces, which causes trigger router service to try compiling a trigger with invalid syntax. Some fields that need to be null instead of containing spaces are:

custom_before_update_text = null,
   custom_before_insert_text = null,
   custom_before_delete_text = null,
   custom_on_insert_text = null,
   custom_on_delete_text = null,
   external_select = null,
   channel_expression = null,
   excluded_column_names = null,
   included_column_names = null
Tagstrigger

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 a5ee0d78

2020-12-04 14:12:56

admin

Details Diff
0004680: Spaces in sym_trigger fields causes create trigger failure Affected Issues
0004680
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/Trigger.java Diff File

SymmetricDS: 3.12 822d0ec5

2020-12-09 15:31:56

admin

Details Diff
0004680: Spaces in sym_trigger fields causes create trigger failure Affected Issues
0004680
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/Trigger.java Diff File

Issue History

Date Modified Username Field Change
2020-12-04 13:55 elong New Issue
2020-12-04 13:55 elong Status new => assigned
2020-12-04 13:55 elong Assigned To => elong
2020-12-04 13:55 elong Tag Attached: trigger
2020-12-04 14:13 elong Status assigned => resolved
2020-12-04 14:13 elong Resolution open => fixed
2020-12-04 14:13 elong Fixed in Version => 3.12.6
2020-12-04 15:00 admin Changeset attached => SymmetricDS 3.12 a5ee0d78
2020-12-09 16:00 admin Changeset attached => SymmetricDS 3.12 822d0ec5
2021-01-11 13:47 admin Status resolved => closed