View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001497 | SymmetricDS | Bug | public | 2013-12-19 17:53 | 2014-08-28 01:03 |
Reporter | elong | Assigned To | |||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.5.10 | ||||
Target Version | 3.5.13 | Fixed in Version | 3.5.13 | ||
Summary | 0001497: Missing primary key with Stream Lobs causes initial load to fail | ||||
Description | If a primary is missing from the table, and the table includes LOB and/or float data type columns, initial loads on postgres and sqlserver (and possible others) will fail since the captured value for teh blob is null. Thus, the wheres clause tries to retreive the blob with a wheres clause that also says blob-col=null, so it retrieves nothing. | ||||
Steps To Reproduce | 1. Setup sync with two SQL Server databases 2. Create a table with no primary and columns including blob 3. Setup a Trigger for the table 4. Initial load the table with Stream lobs for the table set. Expected: the data should be loaded with the blob data Actual: the data rows are loaded, but blob data is null. | ||||
Tags | No tags attached. | ||||
SymmetricDS: master 3a4a4e04 2014-01-02 17:07:53 eegeek Details Diff |
0001497: Missing primary key with Stream Lobs causes initial load to fail |
Affected Issues 0001497 |
|
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 | ||
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDatabasePlatform.java | Diff File | ||
SymmetricDS: master 57124dc8 2014-01-02 17:13:18 eegeek Details Diff |
0001497: Missing primary key with Stream Lobs causes initial load to fail |
Affected Issues 0001497 |
|
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2013-12-19 17:53 | elong | New Issue | |
2013-12-19 17:53 | elong | Status | new => assigned |
2013-12-19 17:53 | elong | Assigned To | => mhanes |
2014-01-02 13:58 |
|
Target Version | 3.5.13 => 4.0.0 |
2014-01-02 21:13 |
|
Summary | Missing primary key prevents updates from syncing => Missing primary key with Stream Lobs causes initial load to fail |
2014-01-02 21:13 |
|
Description Updated | View Revisions |
2014-01-02 21:13 |
|
Steps to Reproduce Updated | View Revisions |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r7835 | |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r7836 | |
2014-02-04 19:05 | elong | Status | assigned => resolved |
2014-02-04 19:05 | elong | Fixed in Version | => 3.5.13 |
2014-02-04 19:05 | elong | Resolution | open => fixed |
2014-02-04 20:30 | admin | Target Version | 4.0.0 => 3.5.13 |
2014-08-28 01:03 | chenson | Status | resolved => closed |
2015-07-31 01:49 | Changeset attached | => SymmetricDS master 57124dc8 | |
2015-07-31 01:49 | Changeset attached | => SymmetricDS master 3a4a4e04 |