Bug #6018 REPLACE does not work for BLOBs + NDB

• Submitted: 11 Oct 2004 13:46
• Modified: 4 Nov 2004 13:34
• Reporter: Magnus Blaudd
• Status: Closed
• Category: Server: Cluster
• Severity: S2 (Serious)
• Assigned to: Pekka Nousiainen

[11 Oct 2004 13:46] Magnus Blaudd

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 15:30] Victoria Reznichenko

Verified with 4.1.6-gamma-debug-log

[31 Oct 2004 15:45] Pekka Nousiainen

NdbBlob now supports writeTuple