[MDEV-34052] long uniques false positive when a row value changes letter case - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4
Fix Version/s: N/A
Component/s: Data Manipulation - Update, Virtual Columns
Labels:
None

Description

Test case based on https://dba.stackexchange.com/questions/339135/how-can-i-get-duplicate-entry-error-on-a-table-that-only-has-one-record

create table t1 (a int, b text, unique (b));

insert t1 values (1, 'a');

update t1 set b='A' where a=1;

drop table t1;

Attachments

Issue Links

duplicates

MDEV-29345 update case insensitive (large) unique key with insensitive change of value - duplicate key

Closed

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Sergei Golubchik

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2024-05-02 07:51

Updated:: 2024-05-02 08:16

Resolved:: 2024-05-02 08:16

Git Integration

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