Bug #34997 FEDERATED TABLES BLOB FIELD IS NOT CORRECTLY UPDATED
Submitted: 3 Mar 2008 13:34 Modified: 29 Oct 17:59
Reporter: Zigmund Bulinsh
Status: Verified
Category:Server: Federated Severity:S2 (Serious)
Version:5.1.23a, 5.0, 6.0 BK OS:Any (Linux, MS Windows)
Assigned to: Target Version:
Tags: federated, blob field
Triage: Triaged: D2 (Serious)

[3 Mar 2008 13:34] Zigmund Bulinsh 
Description:
I have federated table with blob field. And when the blob field is not empty updates do
not works.

How to repeat:
create table t1(id int(10), field blob); #on source server
insert into t1(1, NULL);

create table t1(id int(10), field blob) engine=federated connection=s; #on other server;

update t1 set field = '0'; # sets the blob field to 0
update t1 set field = '1'; # do nothing... says that 0 rows affected...

One moment is that I can solve this problem only be setting this column to NULL befor
eupdating to new value.
update t1 set field = NULL;
[3 Mar 2008 14:16] Sveta Smirnova 
Thank you for the report.

Verified as described.
[29 Oct 17:59] Zigmund Bulinsh 
Still does not work on 5.1.40 version.