[MDEV-18748] REPLACE doesn't work with unique blobs on MyISAM table Created: 2019-02-26  Updated: 2022-12-16  Resolved: 2019-02-28

Status: Closed
Project: MariaDB Server
Component/s: Data types, Storage Engine - MyISAM
Affects Version/s: 10.4
Fix Version/s: 10.4.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-18763 mi_rrnd: Conditional jump or move dep... Closed
Problem/Incident
is caused by MDEV-371 Unique indexes for blobs Closed
Relates
relates to MDEV-30046 wrong row targeted with "insert ... o... Stalled

 Description    

CREATE TABLE t (b BLOB, UNIQUE(b)) ENGINE=MyISAM;
 
INSERT INTO t VALUES ('foo');
 
REPLACE INTO t VALUES ('foo');
 
 
 
# Cleanup
 
DROP TABLE t;

bb-10.4-release-long_unique 5ddae0e0

 
mysqltest: At line 3: query 'REPLACE INTO t VALUES ('foo')' failed: 1062: Duplicate entry 'foo' for key 'b'

I'm not sure whether it's supposed to work or not.

InnoDB currently produces an assertion failure similar to MDEV-18731.
Generated at Thu Feb 08 08:46:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.