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
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S2 (Serious)
• 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] MySQL Verification Team

Verified with 4.1.6-gamma-debug-log

[31 Oct 2004 14:45] Pekka Nousiainen

NdbBlob now supports writeTuple