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 --source include/have_innodb.inc
26
27 SET @start_global_value = @@global.innodb_undo_log_truncate;
28 SELECT @start_global_value;
29
30
31 --echo '#---------------------BS_STVARS_028_01----------------------#'
32 ####################################################################
33 # Displaying default value #
34 ####################################################################
35 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
36 --echo 1 Expected
37
38
39 --echo '#---------------------BS_STVARS_028_02----------------------#'
40 ####################################################################
41 # Check if Value can set #
42 ####################################################################
43
44 SET @@global.innodb_undo_log_truncate = 0;
45 SELECT @@global.innodb_undo_log_truncate;
46
47 SET @@global.innodb_undo_log_truncate ='On' ;
48 SELECT @@global.innodb_undo_log_truncate;
49
50 SET @@global.innodb_undo_log_truncate ='Off' ;
51 SELECT @@global.innodb_undo_log_truncate;
52
53 SET @@global.innodb_undo_log_truncate = 1;
54 SELECT @@global.innodb_undo_log_truncate;
55
56 --echo '#---------------------BS_STVARS_028_03----------------------#'
57 #################################################################
58 # Check if the value in GLOBAL Table matches value in variable #
59 #################################################################
60
61 --disable_warnings
62 SELECT IF(@@GLOBAL.innodb_undo_log_truncate,'ON','OFF') = VARIABLE_VALUE
63 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
64 WHERE VARIABLE_NAME='innodb_undo_log_truncate';
65 --echo 1 Expected
66
67 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
68 --echo 1 Expected
69
70 SELECT COUNT(VARIABLE_VALUE)
71 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
72 WHERE VARIABLE_NAME='innodb_undo_log_truncate';
73 --echo 1 Expected
74 --enable_warnings
75
76
77 --echo '#---------------------BS_STVARS_028_04----------------------#'
78 ################################################################################
79 # Check if accessing variable with and without GLOBAL point to same variable #
80 ################################################################################
81 SELECT @@innodb_undo_log_truncate = @@GLOBAL.innodb_undo_log_truncate;
82 --echo 1 Expected
83
84
85
86 --echo '#---------------------BS_STVARS_028_05----------------------#'
87 ################################################################################
88 # Check if innodb_undo_log_truncate can be accessed with and without @@ sign #
89 ################################################################################
90
91 SELECT COUNT(@@innodb_undo_log_truncate);
92 --echo 1 Expected
93
94 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
95 SELECT COUNT(@@local.innodb_undo_log_truncate);
96 --echo Expected error 'Variable is a GLOBAL variable'
97
98 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
99 SELECT COUNT(@@SESSION.innodb_undo_log_truncate);
100 --echo Expected error 'Variable is a GLOBAL variable'
101
102 SELECT COUNT(@@GLOBAL.innodb_undo_log_truncate);
103 --echo 1 Expected
104
105 --Error ER_BAD_FIELD_ERROR
106 SELECT innodb_undo_log_truncate = @@SESSION.innodb_undo_log_truncate;
107
108 #
109 # Cleanup
110 #
111
112 SET @@global.innodb_undo_log_truncate = @start_global_value;
113 SELECT @@global.innodb_undo_log_truncate;