View Issue Details

IDProjectCategoryView StatusLast Update
0005433SymmetricDSImprovementpublic2024-01-29 14:18
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.2Fixed in Version3.14.2 
Summary0005433: Sync triggers when parameters change that affect triggers
DescriptionWhen a parameter is changed that affects the text of triggers, either by loading or routing the parameter change, then call sync triggers. The node should match external_id and node_group_id of sym_parameter.

The following parameters are know to affect triggers:
  - treat.binary.as.lob.enabled
  - dataextractor.text.column.expression
  - oracle.use.ntypes.for.sync
  - as400.cast.clob.to
  - db2.capture.transaction.id
  - trigger.update.capture.changed.data.only.enabled
  - trigger.capture.ddl.changes
  - trigger.capture.ddl.delimiter
  - trigger.use.insert.delete.for.primary.key.changes
  - db.treat.date.time.as.varchar.enabled
  - mssql.use.ntypes.for.sync
  - mssql.trigger.execute.as
  - mssql.trigger.order.first
  - mssql.include.catalog.in.triggers
  - db.master.collation
  - monitor.events.capture.enabled
  - postgres.security.definer
  - data.create_time.timezone
  - oracle.template.precision
  - oracle.template.precision.text.minimum
Tagstrigger

Relationships

related to 0006211 closedpmarzullo Registration error: sym_parameter changes causing sync triggers need to be limited to DML changes 
related to 0006212 closedpmarzullo Registration error: sym_parameter changes causing sync triggers need to be limited to DML changes 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 a34b5815

2022-09-02 14:35:00

admin

Details Diff
0005433: Sync triggers when parameters change that affect triggers Affected Issues
0005433
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ConfigurationChangedHelper.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File
mod - symmetric-util/src/main/java/org/jumpmind/properties/DefaultParameterParser.java Diff File

SymmetricDS: 3.14 28c15e40

2022-09-06 19:28:20

admin

Details Diff
0005433: fix NPE Affected Issues
0005433
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ConfigurationChangedHelper.java Diff File

Issue History

Date Modified Username Field Change
2022-09-02 14:24 elong New Issue
2022-09-02 14:24 elong Status new => assigned
2022-09-02 14:24 elong Assigned To => elong
2022-09-02 14:24 elong Tag Attached: trigger
2022-09-02 14:35 elong Status assigned => resolved
2022-09-02 14:35 elong Resolution open => fixed
2022-09-02 14:35 elong Fixed in Version => 3.14.2
2022-09-02 15:00 admin Changeset attached => SymmetricDS 3.14 a34b5815
2022-09-06 20:00 admin Changeset attached => SymmetricDS 3.14 28c15e40
2022-10-04 15:15 admin Status resolved => closed
2024-01-29 13:50 pmarzullo Relationship added related to 0006211
2024-01-29 14:15 pmarzullo Relationship added related to 0006212
2024-01-29 14:16 pmarzullo Status closed => resolved
2024-01-29 14:16 pmarzullo Fixed in Version 3.14.2 => 3.14.12
2024-01-29 14:17 pmarzullo Status resolved => closed
2024-01-29 14:17 pmarzullo Status closed => resolved
2024-01-29 14:18 pmarzullo Status resolved => closed
2024-01-29 14:18 pmarzullo Fixed in Version 3.14.12 => 3.14.2