mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-04-09 00:35:40 +02:00
Code Issues Projects Releases Packages Wiki Activity Actions1
mariadb/mysql-test/suite/versioning/t
History
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
..
alter.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
autoinc.test MDEV-22562 Assertion `next_insert_id == 0' upon UPDATE on system-versioned table 2021-03-31 21:25:36 +03:00
commit_id.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
create.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
cte.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
debug.test Merge 10.3 into 10.4 2022-04-06 08:59:09 +03:00
delete.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
delete_history.test MDEV-33470 Unique hash index is broken on DML for system-versioned table 2024-10-08 13:08:10 +03:00
derived.test Merge branch '10.2' into 10.3 2019-09-03 13:17:32 +03:00
foreign.combinations MDEV-14744 Assertion `table->versioned() == m_prebuilt->table->versioned()' failed in ha_innobase::open 2017-12-29 00:23:07 +03:00
foreign.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
insert.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
insert2.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
misc.test MDEV-29750 triggers can modify history 2022-10-16 01:24:30 +02:00
not_embedded.test Versioning test suite cleanups 2022-01-13 23:35:16 +03:00
online.test Merge 10.3 into 10.4 2019-10-10 21:30:40 +03:00
optimized.test MDEV-15062 Information Schema COLUMNS Table does not show system versioning information 2018-04-10 13:12:36 +02:00
partition.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
replace.test MDEV-35343 unexpected replace behaviour when long unique index on 2025-01-14 18:56:13 +03:00
rpl.test MDEV-31313 SYSTEM VERSIONING and FOREIGN KEY CASCADE create orphan rows on replica 2023-07-20 18:22:30 +03:00
rpl_mix.test MDEV-15405 Mixed replication fails with "Could not execute Delete_rows_v1 event" upon DELETE HISTORY 2018-02-25 14:31:15 +01:00
rpl_row.test MDEV-31297 Create table as select on system versioned tables do not 2024-10-08 13:08:10 +03:00
select.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
select2.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
simple.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
sysvars.test Merge branch '10.3' into 10.4 2021-07-31 22:59:58 +02:00
trx_id.opt MDEV-29989 binlog_do_db option breaks versioning table 2023-09-26 10:47:59 +05:30
trx_id.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
update-big.test versioning test suite fixes 2019-10-10 00:20:34 +03:00
update.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
view.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00