CALL mtr.add_suppression("The repository is not configured properly. Please, fix this before using replication."); '#---------------------BS_STVARS_002_01----------------------#' SELECT @@GLOBAL.master_info_repository; @@GLOBAL.master_info_repository TABLE Warnings: Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. SELECT COUNT(@@GLOBAL.master_info_repository); COUNT(@@GLOBAL.master_info_repository) 1 Warnings: Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. 1 Expected SELECT COUNT(@@SESSION.master_info_repository); ERROR HY000: Variable 'master_info_repository' is a GLOBAL variable '#---------------------BS_STVARS_002_02----------------------#' SET @@GLOBAL.master_info_repository= "FILE"; Warnings: Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. SELECT @@GLOBAL.master_info_repository; @@GLOBAL.master_info_repository FILE Warnings: Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. '#---------------------BS_STVARS_002_03----------------------#' SELECT @@GLOBAL.master_info_repository = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='master_info_repository'; @@GLOBAL.master_info_repository = VARIABLE_VALUE 1 1 Expected SELECT COUNT(@@GLOBAL.master_info_repository); COUNT(@@GLOBAL.master_info_repository) 1 Warnings: Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. 1 Expected SELECT COUNT(VARIABLE_VALUE) FROM performance_schema.global_variables WHERE VARIABLE_NAME='master_info_repository'; COUNT(VARIABLE_VALUE) 1 1 Expected '#---------------------BS_STVARS_002_05----------------------#' SELECT COUNT(@@master_info_repository); COUNT(@@master_info_repository) 1 Warnings: Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. 1 Expected SELECT COUNT(@@local.master_info_repository); ERROR HY000: Variable 'master_info_repository' is a GLOBAL variable SELECT COUNT(@@GLOBAL.master_info_repository); COUNT(@@GLOBAL.master_info_repository) 1 Warnings: Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release. 1 Expected '#---------------------BS_STVARS_002_06----------------------#' SET @@GLOBAL.master_info_repository= "TABLE"; Warnings: Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.