[MDEV-32015] insert into an empty table fails with hash unique Created: 2023-08-25  Updated: 2023-09-07  Resolved: 2023-09-07

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Insert
Affects Version/s: 10.4, 10.5, 10.6, 10.10, 10.11, 11.0, 11.1
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3

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


 Description    

create table t1 (f1 varchar(25), unique (f1) using hash);
 
insert ignore t1 (f1) values ('new york'),('virginia'),('spouse'),(null),('zqekmqpwutxnzddrbjycyo'),('nebraska'),('illinois'),('qe'),('ekmqpwut'),('arizona'),('arizona');
 
check table t1 extended;
 
drop table t1;

shows "1194: Table 't1' is marked as crashed and should be repaired"

 Comments   
Comment by Elena Stepanova [ 2023-08-26 ]

Apparently same as MDEV-24972.

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