View Issue Details

IDProjectCategoryView StatusLast Update
0005387SymmetricDSBugpublic2022-08-02 14:30
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.10.4 
Target Version3.13.7Fixed in Version3.13.7 
Summary0005387: Initial load delete or truncate with table transform
DescriptionWhen sending an initial load with a delete or truncate of the table, if the table has a load transform to change the catalog, schema, or table name, it does not take effect. An extract transform does work. The load transform doesn't work because 0003726 changed the database writer to generate its own SQL statement using the catalog, schema, and table sent in the batch.
TagsNo tags attached.

Relationships

related to 0003726 closedJJ_Starrett Delete or truncate should quote table name and include catalog/schema 
related to 0003294 closedjosh-a-hicks Loads that use a custom sql (truncate table %s) to not take into account transforms 
related to 0005388 resolvedelong Initial load delete or truncate with table transform 
related to 0005390 resolvedelong Initial load delete or truncate with table transform 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.13 c9ce6a93

2022-08-01 18:59:50

admin

Details Diff
0005387: Initial load delete or truncate with table transform Affected Issues
0005387
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/TransformWriter.java Diff File

SymmetricDS: 3.14 ab31a733

2022-08-01 18:59:50

admin

Details Diff
0005387: Initial load delete or truncate with table transform Affected Issues
0005387
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/TransformWriter.java Diff File

Issue History

Date Modified Username Field Change
2022-08-01 18:27 elong New Issue
2022-08-01 18:27 elong Status new => assigned
2022-08-01 18:27 elong Assigned To => elong
2022-08-01 18:58 elong Relationship added related to 0003726
2022-08-01 18:58 elong Relationship added related to 0003294
2022-08-01 19:03 elong Status assigned => resolved
2022-08-01 19:03 elong Resolution open => fixed
2022-08-01 19:03 elong Fixed in Version => 3.13.7
2022-08-01 19:03 elong Issue cloned: 0005388
2022-08-01 19:03 elong Relationship added related to 0005388
2022-08-01 20:00 admin Changeset attached => SymmetricDS 3.13 c9ce6a93
2022-08-01 20:00 admin Changeset attached => SymmetricDS 3.14 ab31a733
2022-08-02 14:30 elong Issue cloned: 0005390
2022-08-02 14:30 elong Relationship added related to 0005390