View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004433 | SymmetricDS | Bug | public | 2020-06-19 13:24 | 2022-08-05 14:47 |
| Reporter | JJ_Starrett | Assigned To | JJ_Starrett | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.30 | ||||
| Target Version | 3.11.10 | Fixed in Version | 3.11.10 | ||
| Summary | 0004433: MySql Bulk loader fails on Hex encoded BLOBs and CLOBs | ||||
| Description | When 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 | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.11 4e0e9c61 2020-06-19 09:25:32 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 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 | ||
| 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 |