[MDEV-28987] port lock-related mtr tests from MySQL Created: 2022-06-30  Updated: 2023-10-30

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Fix Version/s: 10.6

Type: Task Priority: Major
Reporter: Vladislav Lesin Assignee: Vladislav Lesin
Resolution: Unresolved Votes: 0
Labels: None


 Description   

MySQL contains more lock-related tests then MariaDB, it would be good to port them to increase locking-code coverage. The following tests should be considered for porting:

mysql-test/suite/innodb/t/avoid_deadlock_with_blocked.test                      
mysql-test/suite/innodb/t/cascade_lock_wait.test                                
mysql-test/suite/innodb/t/constraint_check_locks_in_read_committed.test         
mysql-test/suite/innodb/t/deadlock_on_lock_upgrade.test                         
mysql-test/suite/innodb/t/deadlock_stats.test                                   
mysql-test/suite/innodb/t/hp_deadlock_shutdown.test                             
mysql-test/suite/innodb/t/hp_deadlock.test                                      
mysql-test/suite/innodb/t/index-lock-mode.test                                  
mysql-test/suite/innodb/t/innodb-ac-non-locking-select.test                     
mysql-test/suite/innodb/t/innodb_deadlock_with_autoinc-master.opt               
mysql-test/suite/innodb/t/innodb_deadlock_with_autoinc.test                     
mysql-test/suite/innodb/t/innodb-lock-inherit-read_commited.test                
mysql-test/suite/innodb/t/lock_collision_report.test                            
mysql-test/suite/innodb/t/lock_contention_big.test                              
mysql-test/suite/innodb/t/lock_contention.test                                  
mysql-test/suite/innodb/t/lock_empty_bitmap.test                                
mysql-test/suite/innodb/t/lock_end_of_range.test                                
mysql-test/suite/innodb/t/lock_granted_before_waiting.test                      
mysql-test/suite/innodb/t/lock_impl_to_expl_case_sensitivity.test               
mysql-test/suite/innodb/t/lock_impl_to_expl.test                                
mysql-test/suite/innodb/t/lock-inherit-existing.test                            
mysql-test/suite/innodb/t/lock_partitions.test                                  
mysql-test/suite/innodb/t/lock_rec_unlock.test                                  
mysql-test/suite/innodb/t/lock_sys_resize.test                                  
mysql-test/suite/innodb/t/lock_trx_release_read_locks_in_x_mode.test            
mysql-test/suite/innodb/t/long_deadlock_cycle.test                              
mysql-test/suite/innodb/t/mysql_tables_deadlocks.test                           
mysql-test/suite/innodb/t/secondary_unique_index_range_locking.test             
mysql-test/suite/innodb/t/skip_locked_nowait_isolation.test                     
mysql-test/suite/innodb/t/skip_locked_nowait.test                               
mysql-test/suite/innodb/t/trigger_function_lock_compare.test                    
mysql-test/suite/innodb/t/undetected_deadlock.test                              
mysql-test/suite/innodb/t/xa_prepare_lock_release.test                          
mysql-test/suite/innodb/t/zlob_rollback_deadlock.test


Generated at Thu Feb 08 10:05:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.