Debian Codegraph @

mysql-test/suite/sys_vars/t/myisam_use_mmap_basic.test

raw
1
2
3 ################## mysql-test\t\myisam_use_mmap_basic.test ####################
4 # #
5 # Variable Name: myisam_use_mmap #
6 # Scope: Global #
7 # Access Type: Static #
8 # Data Type: #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author : Sharique Abdullah #
13 # #
14 # #
15 # Description:Test Cases of Dynamic System Variable myisam_use_mmap #
16 # that checks the behavior of this variable in the following ways #
17 # * Value Check #
18 # * Scope Check #
19 # #
20 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
21 # server-system-variables.html #
22 # #
23 ###############################################################################
24
25 --echo '#---------------------BS_STVARS_042_01----------------------#'
26 ####################################################################
27 # Displaying default value #
28 ####################################################################
29 SELECT COUNT(@@GLOBAL.myisam_use_mmap);
30 --echo 1 Expected
31
32
33 --echo '#---------------------BS_STVARS_042_02----------------------#'
34 #
35 # Test case for Bug #35433
36 #
37 ####################################################################
38 # Check if Value can set #
39 ####################################################################
40
41 #--error ER_INCORRECT_GLOBAL_LOCAL_VAR
42 #SET @@GLOBAL.myisam_use_mmap=1;
43 --ECHO "BUG:It should give error on setting this variable as it is readonly variable"
44 --echo Expected error 'Read only variable'
45
46 SELECT COUNT(@@GLOBAL.myisam_use_mmap);
47 --echo 1 Expected
48
49
50
51
52 --echo '#---------------------BS_STVARS_042_03----------------------#'
53 #################################################################
54 # Check if the value in GLOBAL Table matches value in variable #
55 #################################################################
56
57 --disable_warnings
58 SELECT IF(@@GLOBAL.myisam_use_mmap, "ON", "OFF") = VARIABLE_VALUE
59 FROM performance_schema.global_variables
60 WHERE VARIABLE_NAME='myisam_use_mmap';
61 --enable_warnings
62 --echo 1 Expected
63
64 SELECT COUNT(@@GLOBAL.myisam_use_mmap);
65 --echo 1 Expected
66
67 --disable_warnings
68 SELECT COUNT(VARIABLE_VALUE)
69 FROM performance_schema.global_variables
70 WHERE VARIABLE_NAME='myisam_use_mmap';
71 --enable_warnings
72 --echo 1 Expected
73
74
75
76 --echo '#---------------------BS_STVARS_042_04----------------------#'
77 ################################################################################
78 # Check if accessing variable with and without GLOBAL point to same variable #
79 ################################################################################
80 SELECT @@myisam_use_mmap = @@GLOBAL.myisam_use_mmap;
81 --echo 1 Expected
82
83
84
85 --echo '#---------------------BS_STVARS_042_05----------------------#'
86 ################################################################################
87 # Check if myisam_use_mmap can be accessed with and without @@ sign #
88 ################################################################################
89
90 SELECT COUNT(@@myisam_use_mmap);
91 --echo 1 Expected
92
93 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
94 SELECT COUNT(@@local.myisam_use_mmap);
95 --echo Expected error 'Variable is a GLOBAL variable'
96
97 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
98 SELECT COUNT(@@SESSION.myisam_use_mmap);
99 --echo Expected error 'Variable is a GLOBAL variable'
100
101 SELECT COUNT(@@GLOBAL.myisam_use_mmap);
102 --echo 1 Expected
103
104 --Error ER_BAD_FIELD_ERROR
105 SELECT myisam_use_mmap;
106 --echo Expected error 'Unknown column'
107
108