mariadb/mysql-test/suite/versioning
Aleksey Midenkov 78c192644c MDEV-35343 unexpected replace behaviour when long unique index on
system versioned table

For versioned table REPLACE first tries to insert a row, if it gets
duplicate key error and optimization is possible it does UPDATE +
INSERT history. If optimization is not possible it goes normal branch
for UPDATE to history and repeats the cycle of INSERT.

The failure was in normal branch when we tried UPDATE to history but
such history already exists from previous cycles. There is no such
failures in optimized branch because vers_insert_history_row() already
ignores duplicates.

The fix ignores duplicate errors for UPDATE to history and does DELETE
instead.
2025-01-14 18:56:13 +03:00
..
r MDEV-35343 unexpected replace behaviour when long unique index on 2025-01-14 18:56:13 +03:00
t MDEV-35343 unexpected replace behaviour when long unique index on 2025-01-14 18:56:13 +03:00
common.inc MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
common.opt Tests: versioning suite fix when no test_versioning plugin 2019-07-09 10:01:54 +03:00
common_finish.inc MDEV-31313 SYSTEM VERSIONING and FOREIGN KEY CASCADE create orphan rows on replica 2023-07-20 18:22:30 +03:00
disabled.def MDEV-14820 System versioning is applied incorrectly to CTEs 2018-05-12 10:16:45 +02:00
engines.combinations MDEV-16937 Strict SQL with system versioned tables causes issues (10.4) 2020-05-29 11:45:19 +03:00
engines.inc versioning/common.inc must "have_innodb" 2017-12-05 17:42:27 +03:00
innodb.combinations MDEV-17038 ALTER TABLE CHANGE COLUMN c1 c1 bigint NOT NULL - generates error if table uses SYSTEM VERSIONING 2018-11-01 16:42:06 +02:00
innodb.inc MDEV-17038 ALTER TABLE CHANGE COLUMN c1 c1 bigint NOT NULL - generates error if table uses SYSTEM VERSIONING 2018-11-01 16:42:06 +02:00
key_type.combinations versioning test suite fixes 2019-10-10 00:20:34 +03:00
key_type.inc versioning test suite fixes 2019-10-10 00:20:34 +03:00
wait_system_clock.inc fix tests on windows 2018-01-13 02:01:35 +01:00