mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-04-12 10:15:31 +02:00
Code Issues Projects Releases Packages Wiki Activity Actions1
mariadb/mysql-test/suite/versioning/r
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.result Merge 10.4 into 10.5 2024-02-13 14:25:21 +02:00
autoinc.result MDEV-22562 Assertion `next_insert_id == 0' upon UPDATE on system-versioned table 2021-03-31 21:25:36 +03:00
commit_id.result MDEV-11953: support of brackets in UNION/EXCEPT/INTERSECT operations 2018-07-04 19:13:55 +02:00
create.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
cte.result Merge 10.4 to 10.5 2020-10-22 17:08:49 +03:00
debug.result Merge 10.3 into 10.4 2023-01-03 16:10:02 +02:00
delete.result MDEV-25644 UPDATE not working properly on transaction precise system versioned table 2023-07-20 18:22:31 +03:00
delete_history.result MDEV-33470 Unique hash index is broken on DML for system-versioned table 2024-10-08 13:08:10 +03:00
derived.result MDEV-23779 Error upon querying the view, that selecting from versioned table with partitions 2020-10-20 10:49:54 +03:00
foreign.result Merge 10.4 into 10.5 2023-01-13 10:18:30 +02:00
insert.result MDEV-11953: support of brackets in UNION/EXCEPT/INTERSECT operations 2018-07-04 19:13:55 +02:00
insert2.result Merge 10.2 into 10.3 2019-03-27 13:27:04 +02:00
misc.result MDEV-29750 triggers can modify history 2022-10-16 01:24:30 +02:00
not_embedded.result MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DB 2022-09-30 08:48:57 +02:00
online.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
optimized.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
partition.result MDEV-29727 ALTER and CREATE with default partitioning 2023-07-27 18:12:58 +03:00
replace.result MDEV-35343 unexpected replace behaviour when long unique index on 2025-01-14 18:56:13 +03:00
rpl.result MDEV-31313 SYSTEM VERSIONING and FOREIGN KEY CASCADE create orphan rows on replica 2023-07-20 18:22:30 +03:00
rpl_mix.result 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.result MDEV-31297 Create table as select on system versioned tables do not 2024-10-08 13:08:10 +03:00
select,trx_id.rdiff MDEV-11953: support of brackets in UNION/EXCEPT/INTERSECT operations 2018-07-04 19:13:55 +02:00
select.result Merge branch '10.4' into 10.5 2023-12-02 01:02:50 +01:00
select2,trx_id.rdiff Merge 10.4 into 10.5 2020-05-31 10:28:59 +03:00
select2.result Merge 10.4 into 10.5 2020-05-31 10:28:59 +03:00
simple.result fix versioning.simple for embedded 2019-06-17 12:26:25 +02:00
sysvars.result Merge branch '10.3' into 10.4 2021-07-31 22:59:58 +02:00
trx_id.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
update,trx_id.rdiff MDEV-25644 UPDATE not working properly on transaction precise system versioned table 2023-07-20 18:22:31 +03:00
update-big.result versioning test suite fixes 2019-10-10 00:20:34 +03:00
update.result MDEV-25644 UPDATE not working properly on transaction precise system versioned table 2023-07-20 18:22:31 +03:00
view.result MDEV-23779 Error upon querying the view, that selecting from versioned table with partitions 2020-10-20 10:49:54 +03:00