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 mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_archive.result MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
gcol_blackhole.result MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
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 mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_handler_myisam.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
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 MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
gcol_merge.result MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
gcol_ndb.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
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 mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
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 mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_trigger_sp_myisam.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
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 MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
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 MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
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 MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
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 MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
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