View Issue Details

IDProjectCategoryView StatusLast Update
0002486SymmetricDSBugpublic2016-04-28 10:01
ReportermmichalekAssigned Tommichalek 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version3.7.28 
Target Version3.7.29Fixed in Version3.7.29 
Summary0002486: Initial Load Purge Statement doesn't honor Transforms
DescriptionTo recreate this bug, 2 things need to be in place:
1) Set the parameter initial.load.delete.first=true
2) Define a source table and target table with different names, with a table transform mapping the 2.

When attempting to do an initial load in this situation, the DELETE statement generated will point at the source table and not the target table, and therefore create a batch which will fail on the target node. The rest of the initial load works because the data is run through the TransformWriter.

The fix is to manually lookup the transform while building the DELETE statement, and use the target table if it's available.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.7 c439b553

2016-01-29 16:38:14

mmichalek

Details Diff
0002486: Initial Load Purge Statement doesn't honor Transforms
0002486
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ITransformService.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/TransformService.java Diff File
mod - symmetric-util/src/main/java/org/jumpmind/security/SecurityService.java Diff File

SymmetricDS: 3.8 6e973c93

2016-01-29 16:38:14

mmichalek

Details Diff
0002486: Initial Load Purge Statement doesn't honor Transforms
0002486
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ITransformService.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/TransformService.java Diff File
mod - symmetric-util/src/main/java/org/jumpmind/security/SecurityService.java Diff File

Issue History

Date Modified Username Field Change
2016-01-29 14:17 mmichalek New Issue
2016-01-29 14:17 mmichalek Status new => assigned
2016-01-29 14:17 mmichalek Assigned To => mmichalek
2016-01-29 16:44 mmichalek Status assigned => resolved
2016-01-29 16:44 mmichalek Resolution open => fixed
2016-01-29 16:45 mmichalek Status resolved => feedback
2016-01-29 16:45 mmichalek Resolution fixed => reopened
2016-01-29 16:45 mmichalek Fixed in Version => 3.7.29
2016-01-29 16:47 mmichalek Status feedback => closed
2016-01-29 16:47 mmichalek Resolution reopened => fixed
2016-01-29 17:00 mmichalek Changeset attached => SymmetricDS 3.7 c439b553
2016-04-28 10:01 mmichalek Changeset attached => SymmetricDS 3.8 6e973c93