View Issue Details

IDProjectCategoryView StatusLast Update
0000281SymmetricDSBugpublic2014-08-28 01:02
ReporterAssigned Toelong  
Status closedResolutionfixed 
Fixed in Version3.5.0 
Summary0000281: MS SQL: Update on varbinary(max) gets not synchronized
DescriptionI'm using the sample envoronment (Store - Corp). On Corp: create table blobs (id numeric primary key identity, data varbinary(max)) insert into sym_trigger (trigger_id,source_table_name,channel_id,last_update_time,create_time) values('blobs','blobs','item',current_timestamp,current_timestamp); insert into sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) values('blobs','corp_store_identity', 200, current_timestamp, current_timestamp); insert into sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) values('blobs','store_corp_identity', 200, current_timestamp, current_timestamp); 1. insert into blobs(data) values (convert(varbinary(max), 'XXX')) OK - is published to store update blobs set data = (convert(varbinary(max), 'oooo')) where id = 1 Not OK: No publishing to store delete blobs where id=1 OK - is published to store
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2014-02-04 15:54 elong Status new => resolved
2014-02-04 15:54 elong Fixed in Version => 3.5.0
2014-02-04 15:54 elong Resolution open => fixed
2014-02-04 15:54 elong Assigned To => elong
2014-08-28 01:02 chenson Status resolved => closed