View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007094 | SymmetricDS Pro | Bug | public | 2025-10-15 17:04 | 2025-10-15 18:23 |
| Reporter | mdrouard | Assigned To | mdrouard | ||
| Priority | normal | ||||
| Status | assigned | Resolution | open | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.16.8 | ||||
| Summary | 0007094: default.values.to.translate not being applied for bit and Boolean types on Postgres | ||||
| Description | When using default.values.to.translate on binary or boolean columns in postgres the parameter is not utilized. This could cause an error if the translation specified is due to default value type incompatibility between source and target DB. | ||||
| Steps To Reproduce | 1. Setup MSSQL and Postgres DB instances 2. Add the following table to MSSQL DB CREATE TABLE [dbo].[test_bit2]( id [int] NOT NULL, bite [bit] NOT NULL DEFAULT 'False', CONSTRAINT [PK_test_bit2] PRIMARY KEY CLUSTERED (id ) ); INSERT INTO test_bit2 (id, bite) VALUES(1, 'true'); INSERT INTO test_bit2 (id) VALUES(2); 3. Setup replication from MSSQL -> Postgres with table "test_bit2" 4. Set dataloader.create.table.without.defaults.on.error=false (This error will still occur without setting this to false, but the table will fallback and create without defaults) 4.1. Set default.values.to.translate="'false'=0","'true'=1","'False'=0","'True'=1" 5. Send an initial load from MSSQL to Postgres with "Create tables or alter them to match source" 6. Observe the following in the log: WARN [Endpoint_2] [JdbcSqlTemplate] [endpoint_2-dataloader-20] ERROR: invalid input syntax for type boolean: "'False'" Position: 90. Failed to execute: CREATE TABLE "public"."test_bit2"( "id" INTEGER NOT NULL, "bite" BOOLEAN DEFAULT '''False''' NOT NULL, PRIMARY KEY ("id") ) | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-10-15 17:04 | mdrouard | New Issue | |
| 2025-10-15 17:04 | mdrouard | Status | new => assigned |
| 2025-10-15 17:04 | mdrouard | Assigned To | => mdrouard |
| 2025-10-15 17:18 | mdrouard | Relationship added | related to 0005551 |
| 2025-10-15 17:22 | mdrouard | Steps to Reproduce Updated | View Revisions |
| 2025-10-15 18:23 | mdrouard | Note Added: 0003504 |