View Revisions: Issue #1497
Summary | 0001497: Missing primary key with Stream Lobs causes initial load to fail | ||
---|---|---|---|
Revision | 2014-01-02 21:13 by |
||
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. | ||
Revision | 2013-12-19 17:53 by elong | ||
Description | If a primary is missing from the table, and the table includes LOB and/or float data type columns, updates will not be captured and synced on SQL Server. When no primary is defined, SymmetricDS will use all columns as a synthetic primary key, which is used for joining inserted and deleted virtual tables in the trigger to find new and old values. Joining on columns like LOB and float will not result in an equal comparison, so they should be excluded. |