View Issue Details

IDProjectCategoryView StatusLast Update
0002821SymmetricDSBugpublic2022-08-30 13:04
Reporterwrygiel Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.3 
Target Version3.14.1Fixed in Version3.14.1 
Summary0002821: dbcompare attempts to insert null into "not null default ..." field
DescriptionI am comparing a single table between Oracle and MySQL databases. The "search" field is not present in Oracle, but it is present in MySQL. In order for SymmetricDS to work with it, it has a default '' value:

CREATE TABLE `DZ_OSOBY` (
  ...
  `search` varchar(61) CHARACTER SET utf8 NOT NULL DEFAULT '',
  ...
  FULLTEXT KEY `search_index` (`search`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

It would work if generated INSERT statements wouldn't include the `search` field at all, but they currently do:

insert into `DZ_OSOBY` (..., `search`, ...) values (...,null,...);

So, when I pipe it to mysql, I get an error:

ERROR 1048 (23000) at line 1: Column 'search' cannot be null

BTW, SymmetricDS itself works correctly with this table.
Tagsdbcompare

Activities

admin

2016-09-30 14:28

administrator   ~0000873

Re-opening. Was accidentally closed when performing the release.

Related Changesets

SymmetricDS: 3.14 9ac56d4e

2022-08-09 17:40:53

evan-miller-jumpmind

Details Diff
0002821: Fixed how dbcompare handles required columns with defaults that are not present on the source table Affected Issues
0002821
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompareDiffWriter.java Diff File

Issue History

Date Modified Username Field Change
2016-09-22 09:45 wrygiel New Issue
2016-09-30 01:01 admin Status new => closed
2016-09-30 14:28 admin Status closed => new
2016-09-30 14:28 admin Note Added: 0000873
2019-04-24 13:15 elong Tag Attached: dbcompare
2022-08-09 17:41 emiller Assigned To => emiller
2022-08-09 17:41 emiller Status new => resolved
2022-08-09 17:41 emiller Resolution open => fixed
2022-08-09 17:41 emiller Fixed in Version => 3.14.1
2022-08-09 18:00 Changeset attached => SymmetricDS 3.14 9ac56d4e
2022-08-30 13:04 admin Status resolved => closed