View Issue Details

IDProjectCategoryView StatusLast Update
0004433SymmetricDSBugpublic2022-08-05 14:47
ReporterJJ_Starrett Assigned ToJJ_Starrett  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.7.30 
Target Version3.11.10Fixed in Version3.11.10 
Summary0004433: MySql Bulk loader fails on Hex encoded BLOBs and CLOBs
DescriptionWhen data is encoded in hex instead of base64, the MySqlBulkDatabaseWriter attempts to decode from hex twice - once in the code and once in the LOAD FILE sql command, resulting in null or incorrect data
Steps To Reproduce[reproduced in mariadb]
setup two databases with a clob and/or blob column, with hex encoding
set symmetric default channel to bulk mode
attempt to replicate from one database to the other
TagsNo tags attached.

Relationships

related to 0003461 closedelong mysql bulk loader doesn't work with binary() columns, tries to insert in wrong column. 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 4e0e9c61

2020-06-19 09:25:32

JJ_Starrett

Details Diff
0004433: MySql Bulk loader fails on Hex encoded BLOBs and CLOBs Affected Issues
0004433
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/io/MySqlBulkDatabaseWriter.java Diff File

SymmetricDS: 3.11 96dfc619

2020-06-19 16:21:49

JJ_Starrett

Details Diff
0004433: MySql Bulk loader fails on Hex encoded BLOBs and CLOBs

Refactored bulk testing to allow for hex encoded BLOBs as well as Base64
Affected Issues
0004433
mod - symmetric-client/src/integrationTest/java/org/jumpmind/symmetric/io/data/writer/AbstractBulkDatabaseWriterTest.java Diff File
mod - symmetric-client/src/integrationTest/java/org/jumpmind/symmetric/io/data/writer/MsSqlBulkDatabaseWriterTest.java Diff File
mod - symmetric-client/src/integrationTest/java/org/jumpmind/symmetric/io/data/writer/MySqlBulkDatabaseWriterTest.java Diff File
mod - symmetric-client/src/integrationTest/java/org/jumpmind/symmetric/io/data/writer/PostgresBulkDatabaseWriterTest.java Diff File
mod - symmetric-io/src/test/java/org/jumpmind/symmetric/io/AbstractWriterTest.java Diff File

Issue History

Date Modified Username Field Change
2020-06-19 13:24 JJ_Starrett New Issue
2020-06-19 13:24 JJ_Starrett Status new => assigned
2020-06-19 13:24 JJ_Starrett Assigned To => JJ_Starrett
2020-06-19 13:26 JJ_Starrett Status assigned => resolved
2020-06-19 13:26 JJ_Starrett Resolution open => fixed
2020-06-19 13:26 JJ_Starrett Fixed in Version => 3.11.10
2020-06-19 13:36 elong Project SymmetricDS Pro => SymmetricDS
2020-06-19 14:00 JJ_Starrett Changeset attached => SymmetricDS 3.11 4e0e9c61
2020-06-19 21:00 JJ_Starrett Changeset attached => SymmetricDS 3.11 96dfc619
2020-06-24 20:39 admin Status resolved => closed
2022-08-05 14:47 elong Relationship added related to 0003461