Bug #6018 REPLACE does not work for BLOBs + NDB
Submitted: 11 Oct 2004 11:46 Modified: 4 Nov 2004 12:34
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version: OS:
Assigned to: Pekka Nousiainen CPU Architecture:Any

[11 Oct 2004 11:46] Magnus Blåudd
Description:
It's not possible to use the REPLACE command on a table with BLOBS in NDB.

How to repeat:
create table t1(a int primary key, b TEXT) engine=ndb;

REPLACE INTO t1 VALUES(1, "HJSLKHLDHFDLHADLHLAS");
1296: Got error 4264 'Invalid usage of blob attribute' 

drop table t1;

Suggested fix:
Either disable REPLACE on BLOB/TEXT tables for NDB or fix REPLACE functionality with blobs.
[11 Oct 2004 13:30] Victoria Reznichenko
Verified with 4.1.6-gamma-debug-log
[31 Oct 2004 14:45] Pekka Nousiainen
NdbBlob now supports writeTuple