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