1'#---------------------BS_STVARS_042_01----------------------#' 2SELECT COUNT(@@GLOBAL.myisam_use_mmap); 3COUNT(@@GLOBAL.myisam_use_mmap) 41 51 Expected 6'#---------------------BS_STVARS_042_02----------------------#' 7"BUG:It should give error on setting this variable as it is readonly variable" 8Expected error 'Read only variable' 9SELECT COUNT(@@GLOBAL.myisam_use_mmap); 10COUNT(@@GLOBAL.myisam_use_mmap) 111 121 Expected 13'#---------------------BS_STVARS_042_03----------------------#' 14SELECT IF(@@GLOBAL.myisam_use_mmap, "ON", "OFF") = VARIABLE_VALUE 15FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 16WHERE VARIABLE_NAME='myisam_use_mmap'; 17IF(@@GLOBAL.myisam_use_mmap, "ON", "OFF") = VARIABLE_VALUE 181 191 Expected 20SELECT COUNT(@@GLOBAL.myisam_use_mmap); 21COUNT(@@GLOBAL.myisam_use_mmap) 221 231 Expected 24SELECT COUNT(VARIABLE_VALUE) 25FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 26WHERE VARIABLE_NAME='myisam_use_mmap'; 27COUNT(VARIABLE_VALUE) 281 291 Expected 30'#---------------------BS_STVARS_042_04----------------------#' 31SELECT @@myisam_use_mmap = @@GLOBAL.myisam_use_mmap; 32@@myisam_use_mmap = @@GLOBAL.myisam_use_mmap 331 341 Expected 35'#---------------------BS_STVARS_042_05----------------------#' 36SELECT COUNT(@@myisam_use_mmap); 37COUNT(@@myisam_use_mmap) 381 391 Expected 40SELECT COUNT(@@local.myisam_use_mmap); 41ERROR HY000: Variable 'myisam_use_mmap' is a GLOBAL variable 42Expected error 'Variable is a GLOBAL variable' 43SELECT COUNT(@@SESSION.myisam_use_mmap); 44ERROR HY000: Variable 'myisam_use_mmap' is a GLOBAL variable 45Expected error 'Variable is a GLOBAL variable' 46SELECT COUNT(@@GLOBAL.myisam_use_mmap); 47COUNT(@@GLOBAL.myisam_use_mmap) 481 491 Expected 50SELECT myisam_use_mmap = @@SESSION.myisam_use_mmap; 51ERROR 42S22: Unknown column 'myisam_use_mmap' in 'field list' 52Expected error 'Readonly variable' 53