View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002821 | SymmetricDS | Bug | public | 2016-09-22 09:45 | 2022-08-30 13:04 |
| Reporter | wrygiel | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.3 | ||||
| Target Version | 3.14.1 | Fixed in Version | 3.14.1 | ||
| Summary | 0002821: dbcompare attempts to insert null into "not null default ..." field | ||||
| Description | I 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. | ||||
| Tags | dbcompare | ||||
|
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 | ||
| 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 |