View Issue Details

IDProjectCategoryView StatusLast Update
0002559SymmetricDSBugpublic2016-04-20 23:37
ReportermmichalekAssigned Tommichalek 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version3.7.31 
Target Version3.7.32Fixed in Version3.7.32 
Summary0002559: DB2 Trigger may shift decimal point on millisecond portion of timestamp
DescriptionThe DB2 trigger is converting from the numeric microsceond value to a string. If the numeric had leading zeros, they will get dropped in the string. For example, 090000 becomes '90000'. The fix is to make sure the string is always left padded with zeros if necessary.
TagsNo tags attached.

Activities

mmichalek

2016-04-12 10:14

administrator   ~0000782

Note this was fix was tested on z/OS, but trying to use functions that will be available on i series as well.

Related Changesets

SymmetricDS: 3.7 3fbf383d

2016-04-12 10:26:23

mmichalek

Details Diff
0002559: DB2 Trigger may shift decimal point on millisecond portion of
timestamp

0002559
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2TriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2016-04-12 10:12 mmichalek New Issue
2016-04-12 10:12 mmichalek Status new => assigned
2016-04-12 10:12 mmichalek Assigned To => mmichalek
2016-04-12 10:14 mmichalek Note Added: 0000782
2016-04-12 11:00 mmichalek Changeset attached => SymmetricDS 3.7 3fbf383d
2016-04-20 23:36 mmichalek Status assigned => closed
2016-04-20 23:36 mmichalek Resolution open => fixed
2016-04-20 23:36 mmichalek Fixed in Version => 3.7.32
2016-04-20 23:37 mmichalek Status closed => feedback
2016-04-20 23:37 mmichalek Resolution fixed => reopened
2016-04-20 23:37 mmichalek Status feedback => resolved
2016-04-20 23:37 mmichalek Resolution reopened => fixed