Debian Codegraph @

mysql-test/suite/sys_vars/r/myisam_use_mmap_basic.result

raw
1 '#---------------------BS_STVARS_042_01----------------------#'
2 SELECT COUNT(@@GLOBAL.myisam_use_mmap);
3 COUNT(@@GLOBAL.myisam_use_mmap)
4 1
5 1 Expected
6 '#---------------------BS_STVARS_042_02----------------------#'
7 "BUG:It should give error on setting this variable as it is readonly variable"
8 Expected error 'Read only variable'
9 SELECT COUNT(@@GLOBAL.myisam_use_mmap);
10 COUNT(@@GLOBAL.myisam_use_mmap)
11 1
12 1 Expected
13 '#---------------------BS_STVARS_042_03----------------------#'
14 SELECT IF(@@GLOBAL.myisam_use_mmap, "ON", "OFF") = VARIABLE_VALUE
15 FROM performance_schema.global_variables
16 WHERE VARIABLE_NAME='myisam_use_mmap';
17 IF(@@GLOBAL.myisam_use_mmap, "ON", "OFF") = VARIABLE_VALUE
18 1
19 1 Expected
20 SELECT COUNT(@@GLOBAL.myisam_use_mmap);
21 COUNT(@@GLOBAL.myisam_use_mmap)
22 1
23 1 Expected
24 SELECT COUNT(VARIABLE_VALUE)
25 FROM performance_schema.global_variables
26 WHERE VARIABLE_NAME='myisam_use_mmap';
27 COUNT(VARIABLE_VALUE)
28 1
29 1 Expected
30 '#---------------------BS_STVARS_042_04----------------------#'
31 SELECT @@myisam_use_mmap = @@GLOBAL.myisam_use_mmap;
32 @@myisam_use_mmap = @@GLOBAL.myisam_use_mmap
33 1
34 1 Expected
35 '#---------------------BS_STVARS_042_05----------------------#'
36 SELECT COUNT(@@myisam_use_mmap);
37 COUNT(@@myisam_use_mmap)
38 1
39 1 Expected
40 SELECT COUNT(@@local.myisam_use_mmap);
41 ERROR HY000: Variable 'myisam_use_mmap' is a GLOBAL variable
42 Expected error 'Variable is a GLOBAL variable'
43 SELECT COUNT(@@SESSION.myisam_use_mmap);
44 ERROR HY000: Variable 'myisam_use_mmap' is a GLOBAL variable
45 Expected error 'Variable is a GLOBAL variable'
46 SELECT COUNT(@@GLOBAL.myisam_use_mmap);
47 COUNT(@@GLOBAL.myisam_use_mmap)
48 1
49 1 Expected
50 SELECT myisam_use_mmap;
51 ERROR 42S22: Unknown column 'myisam_use_mmap' in 'field list'
52 Expected error 'Unknown column'