[MDEV-29199] Unique hash key is ignored upon INSERT ... SELECT into non-empty MyISAM table - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3, 10.11.2
Component/s: Server
Labels:
None

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

is caused by

MDEV-371 Unique indexes for blobs

relates to

MDEV-23264 Unique blobs allow duplicate values upon UPDATE

Estimated:

Not Specified

Remaining:

Logged:

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.