View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006700 | SymmetricDS | Bug | public | 2025-01-13 21:33 | 2025-02-14 14:27 |
| Reporter | richard@deepred.co.za | Assigned To | pbelov | ||
| Priority | urgent | ||||
| Status | closed | Resolution | duplicate | ||
| Product Version | 3.15.12 | ||||
| Target Version | 3.15.13 | Fixed in Version | 3.15.13 | ||
| Summary | 0006700: boolean constants in csv row data are not converted correctly on Postgres | ||||
| Description | After upgrading to 3.15.12, I discovered that all boolean columns on my Postgres host node are set to FALSE when the client node is Derby. The method DerbyFunctions.escape inserts the string literal of the column value into CSV data, ie. "true" or "false". It appears that this is no longer mapped correctly in the Postgres nodes that receive this data. The outcome is always FALSE. Part of my trouble shooting, I intercepted a CSV file and changed the values to "0" or "1". This appeared to work, ie. "1" was mapped to TRUE on the Postgres. | ||||
| Additional Information | This is an extract from the CSV DATA. The column RESULT is of type boolean in Derby client nodes and Postgres host nodes. In this example, the value of the column RESULT is "true", however when this is processed it maps to FALSE on the database. table,system_activity keys,ID columns,ID,TSTAMP,ACTIVITY,CLIENT_NAME,HOST_NAME,OPERATOR,CLINIC_ID,DATA,MESSAGES,RESULT,EXECUTION_TIME,ORIGIN ts,6 insert,"42694d1c-4e00-4bd8-bedd-0cd93b55abf0","2025-01-13 22:09:17.303","za.drt.ambium.service.impl.EmployerService:updateEmployer","malachor","localhost","admin",,"employer= 1a79aa44119e; name= ACTIVE 10:09",,"true","9","app" | ||||
| Tags | dialect: Derby (Apache DB) | ||||
|
|
SymmetricDS does not currently support the Derby boolean data type. This issue will be resolved once 0006637 is resolved. |
|
|
I have a patch for 0006637 and this issue on a local branch. I'm happy to commit to Github would add me as a contributor. I did submit the requested documents a few weeks back. |
|
|
Released as part of 3.15.13 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-01-13 21:33 | richard@deepred.co.za | New Issue | |
| 2025-01-29 18:45 | emiller | Relationship added | duplicate of 0006637 |
| 2025-01-29 18:45 | emiller | Tag Attached: dialect: derby | |
| 2025-01-29 18:46 | emiller | Note Added: 0002599 | |
| 2025-01-29 20:16 | admin | Tag Renamed | dialect: derby => dialect: Derby (Apache DB) |
| 2025-01-30 19:35 | richard@deepred.co.za | Note Added: 0002602 | |
| 2025-02-12 18:21 | mdrouard | Assigned To | => pbelov |
| 2025-02-12 18:21 | mdrouard | Status | new => resolved |
| 2025-02-12 18:21 | mdrouard | Resolution | open => duplicate |
| 2025-02-12 18:21 | mdrouard | Fixed in Version | => 3.15.13 |
| 2025-02-14 14:27 | pbelov | Note Added: 0002629 | |
| 2025-02-14 14:27 | pbelov | Status | resolved => closed |