[MDEV-29199] Unique hash key is ignored upon INSERT ... SELECT into non-empty MyISAM table Created: 2022-07-28  Updated: 2023-01-21  Resolved: 2023-01-21

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.11.2, 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-371 Unique indexes for blobs Closed
Relates
relates to MDEV-23264 Unique blobs allow duplicate values u... Closed

 Description   

The patch from MDEV-23264 (bb-10.4-MDEV-23264 b2eb92843c) does not fix it.

--source include/have_sequence.inc
 
 
 
create or replace table t (a int, b text, unique(b)) engine=MyISAM;
 
insert into t values (0,'aa');
 
insert into t (a,b) select 1,'xxx' from seq_1_to_5;
 
select * from t;
 
 
 
# Cleanup
 
drop table t;

10.4 f0107c90

 
insert into t (a,b) select 1,'xxx' from seq_1_to_5;
 
select * from t;
 
a	b
 
0	aa
 
1	xxx
 
1	xxx
 
1	xxx
 
1	xxx
 
1	xxx


Generated at Thu Feb 08 10:06:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.