0001497: Missing primary key with Stream Lobs causes initial load to fail - SymmetricDS

Summary	0001497: Missing primary key with Stream Lobs causes initial load to fail

Revision	2014-01-02 21:13 by ~~mhanes~~
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.