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] MySQL Verification Team 
Verified with 4.1.6-gamma-debug-log
[31 Oct 2004 14:45] Pekka Nousiainen 
NdbBlob now supports writeTuple

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.