Bug #34997 FEDERATED TABLES BLOB FIELD IS NOT CORRECTLY UPDATED
Submitted: 3 Mar 2008 12:34 Modified: 30 Nov 2018 18:09
Reporter: Zigmund Bulinsh Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S2 (Serious)
Version:5.1.23a, 5.0, 6.0 BK OS:Any (Linux, MS Windows)
Assigned to: CPU Architecture:Any
Tags: blob field, federated

[3 Mar 2008 12: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 13:16] Sveta Smirnova 
Thank you for the report.

Verified as described.
[29 Oct 2009 16:59] Zigmund Bulinsh 
Still does not work on 5.1.40 version.
[30 Nov 2018 18:09] Paul DuBois 
Fixed in 8.0.14.

Updates for BLOB columns in FEDERATED tables did not work.