You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
createtablet6 (a int, b int, c int, primary key(a, b) clustered, unique key idx_14(b), unique key idx_15(b), unique key idx_16(a, b));
insert into t6 select10, 10, 20;
insert ignore into t6 set a =20, b =10on duplicate key update a =100;
2. What did you expect to see? (Required)
on duplicate on b=10 and update a to 100
3. What did you see instead (Required)
update nothing
4. What is your TiDB version? (Required)
master
The text was updated successfully, but these errors were encountered:
lysu
changed the title
insert ignore on duplicate got wrong result when not change index value
insert ignore on duplicate got wrong result when index value unchanged
Apr 7, 2021
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
on duplicate on
b=10
and update a to 1003. What did you see instead (Required)
update nothing
4. What is your TiDB version? (Required)
master
The text was updated successfully, but these errors were encountered: