Debian Codegraph @

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

raw
1
2
3 ############### mysql-test\t\innodb_undo_log_truncate_basic.test ##############
4 # #
5 # Variable Name: innodb_undo_log_truncate #
6 # Scope: Global #
7 # Access Type: Dynamic #
8 # Data Type: boolean #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author : Sharique Abdullah #
13 # #
14 # #
15 # Description:Test Cases of Dynamic System Variable innodb_undo_log_truncate #
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
26 SET @start_global_value = @@global.innodb_undo_log_truncate;
27 SELECT @start_global_value;
28
29
30 --echo '#---------------------BS_STVARS_028_01----------------------#'
31 ####################################################################
32 # Displaying default value #
33 ####################################################################
34 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
35 --echo 1 Expected
36
37
38 --echo '#---------------------BS_STVARS_028_02----------------------#'
39 ####################################################################
40 # Check if Value can set #
41 ####################################################################
42
43 SET @@global.innodb_undo_log_truncate = 0;
44 SELECT @@global.innodb_undo_log_truncate;
45
46 SET @@global.innodb_undo_log_truncate ='On' ;
47 SELECT @@global.innodb_undo_log_truncate;
48
49 SET @@global.innodb_undo_log_truncate ='Off' ;
50 SELECT @@global.innodb_undo_log_truncate;
51
52 SET @@global.innodb_undo_log_truncate = 1;
53 SELECT @@global.innodb_undo_log_truncate;
54
55 --echo '#---------------------BS_STVARS_028_03----------------------#'
56 #################################################################
57 # Check if the value in GLOBAL Table matches value in variable #
58 #################################################################
59
60 --disable_warnings
61 SELECT IF(@@GLOBAL.innodb_undo_log_truncate,'ON','OFF') = VARIABLE_VALUE
62 FROM performance_schema.global_variables
63 WHERE VARIABLE_NAME='innodb_undo_log_truncate';
64 --echo 1 Expected
65
66 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
67 --echo 1 Expected
68
69 SELECT COUNT(VARIABLE_VALUE)
70 FROM performance_schema.global_variables
71 WHERE VARIABLE_NAME='innodb_undo_log_truncate';
72 --echo 1 Expected
73 --enable_warnings
74
75
76 --echo '#---------------------BS_STVARS_028_04----------------------#'
77 ################################################################################
78 # Check if accessing variable with and without GLOBAL point to same variable #
79 ################################################################################
80 SELECT @@innodb_undo_log_truncate = @@GLOBAL.innodb_undo_log_truncate;
81 --echo 1 Expected
82
83
84
85 --echo '#---------------------BS_STVARS_028_05----------------------#'
86 ################################################################################
87 # Check if innodb_undo_log_truncate can be accessed with and without @@ sign #
88 ################################################################################
89
90 SELECT COUNT(@@innodb_undo_log_truncate);
91 --echo 1 Expected
92
93 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
94 SELECT COUNT(@@local.innodb_undo_log_truncate);
95 --echo Expected error 'Variable is a GLOBAL variable'
96
97 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
98 SELECT COUNT(@@SESSION.innodb_undo_log_truncate);
99 --echo Expected error 'Variable is a GLOBAL variable'
100
101 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
102 --echo 1 Expected
103
104 --Error ER_BAD_FIELD_ERROR
105 SELECT innodb_undo_log_truncate;
106
107 #
108 # Cleanup
109 #
110
111 SET @@global.innodb_undo_log_truncate = @start_global_value;
112 SELECT @@global.innodb_undo_log_truncate;