[MDEV-32015] insert into an empty table fails with hash unique - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5(EOL), 10.6, 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3
Component/s: Data Manipulation - Insert
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"

Attachments

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Sergei Golubchik

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2023-08-25 16:12

Updated:: 2023-09-07 12:49

Resolved:: 2023-09-07 07:22

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

3.75d

Git Integration

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