View Issue Details

IDProjectCategoryView StatusLast Update
0004083SymmetricDSBugpublic2019-10-30 20:01
ReporterMrKichAssigned To 
Status newResolutionopen 
Product Version3.10.4 
Target VersionFixed in Version 
Summary0004083: Auto converting date to null for not mysql db brokes synchronization
DescriptionWe use symmetricds for replication between mariadb hosts and oracle.
There is a datetime field in mysql db that allows null and a date field in oracle which does not.

Maybe it's not a good architecture but it exists.

After upgrading from 3.10.3 to 3.10.4 replication from mariadb nodes to oracle was broken as symmetric tried to insert 'null' to a non-null date field.

We have plenty of similar fields and I believe that this behavior should be tunable.
Steps To Reproduce1. Setup replication between mariadb host and oracle host.
2. Create table on maridb host with datetime field.
3. Create table on oracle host with date non-null field.
4. Insert 'null' to datetime in mariadb table
5. Error will be raised as 'null' is not allowed for date field at oracle host
Additional Information"Improvement" issue -
Tagsdialect: mysql/mariadb



2019-08-29 13:22

developer   ~0001596

Maybe we add a parameter of and you could change it to what you need, like Would that meet your requirements?


2019-08-29 13:44

reporter   ~0001597

Yes, I think that parameter will solve our problems.
With exception that for parameter could be not only date field, but datetime field.


2019-10-30 20:01

developer   ~0001626

If you remove zeroDateTimeBehavior=convertToNull from the db.url, it will go back to the same behavior it had in 3.10.3.

Issue History

Date Modified Username Field Change
2019-08-28 21:58 MrKich New Issue
2019-08-29 13:22 elong Note Added: 0001596
2019-08-29 13:44 MrKich Note Added: 0001597
2019-10-30 20:01 elong Note Added: 0001626
2019-10-30 20:01 elong Tag Attached: dialect: mysql/mariadb