[MDEV-18953] Hash index on partial char field not working Created: 2019-03-17  Updated: 2019-03-23  Resolved: 2019-03-23

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: None
Fix Version/s: 10.4.4

Type: Bug Priority: Blocker
Reporter: Sachin Setiya (Inactive) Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description    

eval create table t1 (
 
c char(10),
 
unique key a using hash (c(1))
 
) engine=myisam;
 
show create table t1;
 
insert into t1 values ('б');
 
--error ER_DUP_ENTRY
 
insert into t1 values ('бб');
 
--error ER_DUP_ENTRY
 
insert into t1 values ('ббб');
 
drop table t1;
 



mysqltest: At line 9: query 'insert into t1 values ('бб')' succeeded - should have failed with errno 1062...

And also enable ctype_utf8mb4_innodb and myisam , which is disabled because of this bug.

 Comments   
Comment by Sachin Setiya (Inactive) [ 2019-03-18 ]

bb-10.4-sachin

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