Debian Codegraph @

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

raw
1
2
3 ################## mysql-test\t\innodb_redo_log_capacity_basic.test ###########
4 # #
5 # Variable Name: innodb_redo_log_capacity #
6 # Scope: Global #
7 # Access Type: Dynamic #
8 # Data Type: numeric #
9 # #
10 # #
11 # Creation Date: 2020-05-19 #
12 # Author : Paweł Olchawa #
13 # #
14 # #
15 # Description:Test Cases of Dynamic System Variable innodb_redo_log_capacity #
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/8.0/en/ #
21 # server-system-variables.html #
22 # #
23 ###############################################################################
24
25
26 let $wait_condition =
27 SELECT variable_value = 'OK'
28 FROM performance_schema.global_status
29 WHERE variable_name = 'Innodb_redo_log_resize_status';
30
31 SET @start_log_capacity = @@GLOBAL.innodb_redo_log_capacity;
32
33 --echo '#---------------------BS_STVARS_022_01----------------------#'
34 ####################################################################
35 # Displaying default value #
36 ####################################################################
37 SELECT COUNT(@@GLOBAL.innodb_redo_log_capacity);
38 --echo 1 Expected
39
40
41 --echo '#---------------------BS_STVARS_022_02----------------------#'
42 ####################################################################
43 # Check if Value can set #
44 ####################################################################
45
46 SET @@GLOBAL.innodb_redo_log_capacity=15728640;
47 --echo Expected succeeded
48 --source include/wait_condition.inc
49
50 SELECT COUNT(@@GLOBAL.innodb_redo_log_capacity);
51 --echo 1 Expected
52
53
54
55
56 --echo '#---------------------BS_STVARS_022_03----------------------#'
57 #################################################################
58 # Check if the value in GLOBAL Table matches value in variable #
59 #################################################################
60
61 --disable_warnings
62 SELECT @@GLOBAL.innodb_redo_log_capacity = VARIABLE_VALUE
63 FROM performance_schema.global_variables
64 WHERE VARIABLE_NAME='innodb_redo_log_capacity';
65 --enable_warnings
66 --echo 1 Expected
67
68 SELECT COUNT(@@GLOBAL.innodb_redo_log_capacity);
69 --echo 1 Expected
70
71 --disable_warnings
72 SELECT COUNT(VARIABLE_VALUE)
73 FROM performance_schema.global_variables
74 WHERE VARIABLE_NAME='innodb_redo_log_capacity';
75 --enable_warnings
76 --echo 1 Expected
77
78
79
80 --echo '#---------------------BS_STVARS_022_04----------------------#'
81 ################################################################################
82 # Check if accessing variable with and without GLOBAL point to same variable #
83 ################################################################################
84 SELECT @@innodb_redo_log_capacity = @@GLOBAL.innodb_redo_log_capacity;
85 --echo 1 Expected
86
87
88
89 --echo '#---------------------BS_STVARS_022_05----------------------#'
90 ################################################################################
91 # Check if innodb_redo_log_capacity can be accessed with and without @@ sign #
92 ################################################################################
93
94 SELECT COUNT(@@innodb_redo_log_capacity);
95 --echo 1 Expected
96
97 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
98 SELECT COUNT(@@local.innodb_redo_log_capacity);
99 --echo Expected error 'Variable is a GLOBAL variable'
100
101 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
102 SELECT COUNT(@@SESSION.innodb_redo_log_capacity);
103 --echo Expected error 'Variable is a GLOBAL variable'
104
105 SELECT COUNT(@@GLOBAL.innodb_redo_log_capacity);
106 --echo 1 Expected
107
108 --Error ER_BAD_FIELD_ERROR
109 SELECT innodb_redo_log_capacity;
110 --echo Expected error 'Readonly variable'
111 SET @@GLOBAL.innodb_redo_log_capacity = @start_log_capacity;
112 --source include/wait_condition.inc
113
114 let MYSQLD_DATADIR=`SELECT @@datadir`;
115 let MYSQLD_IB_REDO_LOG_PHYSICAL_CAPACITY = `SELECT @@innodb_redo_log_capacity`;
116 --source include/ib_redo_log_capacity_check.inc