Repository navigation
UPDATE and INSERT ON DUPLICATE KEY doesn't update index containing generated column #58400
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
Case1:
CREATE TABLE t3 (
id int,
time1 datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
time2 datetime GENERATED ALWAYS AS (date_add(time1, interval 1 day)) VIRTUAL,
KEY idx (id, time2)
);
insert into t3 set id = 1;
update t3 set id = 2;
admin check table t3;Case2:
drop table tmv;
CREATE TABLE tmv (
J1 json, J2 json GENERATED ALWAYS AS (j1) VIRTUAL,
UNIQUE KEY i1 ((cast(j1 as signed array))),
KEY i2 ((cast(j2 as signed array)))
);
insert into tmv set j1 = '[1]';
insert ignore into tmv set j1 = '[1]' on duplicate key update j1 = '[2]';
admin check table tmv;2. What did you expect to see? (Required)
Both admin check table passed.
3. What did you see instead (Required)
ERROR 8223 (HY000): data inconsistency in table: t3, index: idx, handle: 1, index-values:"handle: 1, values: [KindInt64 2 KindMysqlTime 2024-12-20 10:33:33]" != record-values:"handle: 1, values: [KindInt64 2 KindMysqlTime 2024-12-20 10:33:38]"
ERROR 8134 (HY000): data inconsistency in table: tmv, index: i2, col: _V$_i2_0, handle: "1",
index-values:"KindInt64 1" != record-values:"KindMysqlJSON [2]", compare err:<nil>
Activity
[-]`Update` doesn't update index containing generated column[/-][+]`UPDATE` and `INSERT ON DUPLICATE KEY` doesn't update index containing generated column[/+]joechenrh commentedon Dec 24, 2024
/remove-label may-affects-5.4
planner/core: update missing virtual columns in `update` and `insert` (…
planner/core: update missing virtual columns in `update` and `insert` (…
planner/core: update missing virtual columns in `update` and `insert` (…