mariadb/mysql-test/suite/gcol/r
Marko Mäkelä 1c9f64e54f MDEV-36613 Incorrect undo logging for indexes on virtual columns
Starting with mysql/mysql-server@02f8eaa998
and commit 2e814d4702 the index ID of
indexes on virtual columns was being encoded insufficiently in
InnoDB undo log records.  Only the least significant 32 bits were
being written.  This could lead to some corruption of the affected
indexes on ROLLBACK, as well as to missed chances to remove some
history from such indexes when purging the history of committed
transactions that included DELETE or an UPDATE in the indexes.

dict_hdr_create(): In debug instrumented builds, initialize the
DICT_HDR_INDEX_ID close to the 32-bit barrier, instead of initializing
it to DICT_HDR_FIRST_ID (10).  This will allow the changed code to
be exercised while running ./mtr --suite=gcol,vcol.

trx_undo_log_v_idx(): Encode large index->id in a similar way as
mysql/mysql-server@e00328b4d0
but using a different implementation.

trx_undo_read_v_idx_low(): Decode large index->id in a similar way
as mach_u64_read_much_compressed().

Reviewed by: Debarun Banerjee
2025-04-16 15:55:45 +03:00
..
federated_gcol.result
gcol_archive.result
gcol_blackhole.result
gcol_blocked_sql_funcs_innodb.result MDEV-19071 Wrong results when using STDDEV_SAMP() and view 2023-01-02 00:04:03 +01:00
gcol_blocked_sql_funcs_myisam.result MDEV-19071 Wrong results when using STDDEV_SAMP() and view 2023-01-02 00:04:03 +01:00
gcol_bug20746926.result MDEV-17563 Different results using table or view when comparing values of time type 2018-11-08 09:31:46 +04:00
gcol_bugfixes.result Merge branch '10.4' into 10.5 2023-12-02 01:02:50 +01:00
gcol_column_def_options_innodb.result Merge 10.4 into 10.5 2022-12-13 14:39:18 +02:00
gcol_column_def_options_myisam.result Merge 10.4 into 10.5 2022-12-13 14:39:18 +02:00
gcol_csv.result MDEV-18650: Options deprecated in previous versions - storage_engine 2020-02-13 13:42:01 +02:00
gcol_falcon.result MDEV-18650: Options deprecated in previous versions - storage_engine 2020-02-13 13:42:01 +02:00
gcol_handler_innodb.result
gcol_handler_myisam.result
gcol_ins_upd_innodb.result Merge branch '10.4' into 10.5 2021-07-31 23:19:51 +02:00
gcol_ins_upd_myisam.result Merge branch '10.4' into 10.5 2021-07-31 23:19:51 +02:00
gcol_keys_innodb.result Merge remote-tracking branch 'origin/10.4' into 10.5 2022-09-14 16:24:51 +04:00
gcol_keys_myisam.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
gcol_memory.result
gcol_merge.result
gcol_ndb.result
gcol_non_stored_columns_innodb.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
gcol_non_stored_columns_myisam.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
gcol_partition_innodb.result MDEV-26220 Server crashes with indexed by prefix virtual column 2021-08-02 10:31:22 +02:00
gcol_partition_myisam.result MDEV-26220 Server crashes with indexed by prefix virtual column 2021-08-02 10:31:22 +02:00
gcol_purge.result MDEV-31355 fixup: Adjust one more test 2023-06-08 10:40:48 +03:00
gcol_rejected_innodb.result
gcol_rollback.result MDEV-30597 Assertion `flag == 1' failed in row_build_index_entry_low 2023-02-14 14:28:27 +05:30
gcol_select_innodb.result Merge 10.4 into 10.5 2022-07-27 17:17:24 +03:00
gcol_select_myisam.result Merge 10.4 into 10.5 2022-07-27 17:17:24 +03:00
gcol_supported_sql_funcs_innodb.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
gcol_supported_sql_funcs_myisam.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
gcol_trigger_sp_innodb.result
gcol_trigger_sp_myisam.result
gcol_update.result Do not require a debug non-embedded server in the test 2017-09-13 16:02:31 +03:00
gcol_view_innodb.result Merge branch '10.3' into 10.4 2021-07-31 22:59:58 +02:00
gcol_view_myisam.result Merge branch '10.3' into 10.4 2021-07-31 22:59:58 +02:00
innodb_partition.result
innodb_prefix_index_check.result MDEV-13626 Merge InnoDB test cases from MySQL 5.7 2023-11-08 12:17:14 +02:00
innodb_virtual_basic.result MDEV-36613 Incorrect undo logging for indexes on virtual columns 2025-04-16 15:55:45 +03:00
innodb_virtual_blob.result
innodb_virtual_debug.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb_virtual_debug_purge.result MDEV-31355 innodb_undo_log_truncate=ON fails to wait for purge of enough transaction history 2023-06-08 09:17:52 +03:00
innodb_virtual_fk.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb_virtual_fk_restart.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb_virtual_index.result MDEV-29753 An error is wrongly reported during INSERT with vcol index 2022-10-12 20:49:45 +03:00
innodb_virtual_purge.result MDEV-30024 InnoDB: tried to purge non-delete-marked of a virtual column prefix 2023-09-19 09:31:34 +03:00
innodb_virtual_rebuild.result MDEV-15662 Instant DROP COLUMN or changing the order of columns 2018-10-19 18:57:23 +03:00
innodb_virtual_stats.result MDEV-24564 Statistics are lost after ALTER TABLE 2021-01-28 14:15:01 +02:00
innodb_wl8114.result
main_alter_table.result MDEV-16678: Fix a problem with duplicate #sql2 table names 2019-12-10 16:18:30 +02:00
main_mysqldump.result
rpl_gcol.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
virtual_index_drop.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00