0006603: NULL-able trait is not preserved, when column referenced by a unique index - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0006603	SymmetricDS	Bug	public	2024-10-01 18:47	2024-10-15 19:02

Reporter	pbelov	Assigned To	pbelov
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.15.7
Target Version	3.15.9	Fixed in Version	3.15.9

Summary	0006603: NULL-able trait is not preserved, when column referenced by a unique index
Description	NULL-able trait is not preserved, when column referenced by a unique index
Steps To Reproduce	Create test table on source with at least one columns, which is: * NULL-able * Part of the Unique index * Table has ho Primary Key Then run wither Full Load (with create table) or partial load/CDC Observe: 1. Table on target will have same columns, but as NOT NULL 2. Data in table on target will have empty string ' ' values instead of NULL values in the column on source
Tags	data sync, dialect: postgresql, schema

SymmetricDS: 3.15 4f1321a6 2024-10-04 15:14:46 admin Details Diff	0006603: spotless code format	Affected Issues 0006603
	mod - symmetric-db/src/main/java/org/jumpmind/db/model/Table.java	Diff File
	mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java	Diff File

Date Modified	Username	Field	Change
2024-10-01 18:47	pbelov	New Issue
2024-10-01 18:47	pbelov	Status	new => assigned
2024-10-01 18:47	pbelov	Assigned To	=> pbelov
2024-10-01 18:47	pbelov	Tag Attached: data sync
2024-10-01 18:47	pbelov	Tag Attached: dialect: postgresql
2024-10-01 18:47	pbelov	Tag Attached: schema
2024-10-01 18:48	elong	Target Version	=> 3.15.9
2024-10-01 18:50	elong	Status	assigned => resolved
2024-10-01 18:50	elong	Resolution	open => fixed
2024-10-01 18:50	elong	Fixed in Version	=> 3.15.9
2024-10-01 19:48	admin	Status	resolved => closed
2024-10-04 16:00	admin	Changeset attached	=> SymmetricDS 3.15 4f1321a6
2024-10-15 19:02	emiller	Note Added: 0002503

emiller 2024-10-15 19:02 developer ~0002503	This issue can occur on other database platforms, regardless of whether the table has a unique index. I reproduced it using an Oracle database with a table that has no primary key or unique index. For Oracle, the NULL values get replaced by spaces.