Debian Codegraph @

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

raw
1
2 ################ mysql-test\t\innodb_temp_data_file_path_basic.test ############
3 # #
4 # Variable Name: innodb_temp_data_file_path #
5 # Scope: Global #
6 # Access Type: Static #
7 # Data Type: filename #
8 # #
9 # #
10 # Creation Date: 2012-12-27 #
11 # Author : Krunal Bauskar #
12 # #
13 # #
14 # Description:Test Cases of Dynamic System Variable innodb_temp_data_file_path#
15 # that checks the behavior of this variable in the following ways #
16 # * Value Check #
17 # * Scope Check #
18 # #
19 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
20 # server-system-variables.html #
21 # #
22 ###############################################################################
23
24
25 --echo '#---------------------BS_STVARS_024_01----------------------#'
26 ####################################################################
27 # Displaying default value #
28 ####################################################################
29 SELECT COUNT(@@GLOBAL.innodb_temp_data_file_path);
30 --echo 1 Expected
31
32
33 --echo '#---------------------BS_STVARS_024_02----------------------#'
34 ####################################################################
35 # Check if Value can set #
36 ####################################################################
37
38 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
39 SET @@GLOBAL.innodb_temp_data_file_path=1;
40 --echo Expected error 'Read only variable'
41
42 SELECT COUNT(@@GLOBAL.innodb_temp_data_file_path);
43 --echo 1 Expected
44
45
46
47
48 --echo '#---------------------BS_STVARS_024_03----------------------#'
49 #################################################################
50 # Check if the value in GLOBAL Table matches value in variable #
51 #################################################################
52
53 --disable_warnings
54 SELECT @@GLOBAL.innodb_temp_data_file_path = VARIABLE_VALUE
55 FROM performance_schema.global_variables
56 WHERE VARIABLE_NAME='innodb_temp_data_file_path';
57 --enable_warnings
58 --echo 1 Expected
59
60 SELECT COUNT(@@GLOBAL.innodb_temp_data_file_path);
61 --echo 1 Expected
62
63 --disable_warnings
64 SELECT COUNT(VARIABLE_VALUE)
65 FROM performance_schema.global_variables
66 WHERE VARIABLE_NAME='innodb_temp_data_file_path';
67 --enable_warnings
68 --echo 1 Expected
69
70
71
72 --echo '#---------------------BS_STVARS_024_04----------------------#'
73 ################################################################################
74 # Check if accessing variable with and without GLOBAL point to same variable #
75 ################################################################################
76 SELECT @@innodb_temp_data_file_path = @@GLOBAL.innodb_temp_data_file_path;
77 --echo 1 Expected
78
79
80
81 --echo '#---------------------BS_STVARS_024_05----------------------#'
82 ################################################################################
83 #Check if innodb_temp_data_file_path can be accessed with and without @@ sign #
84 ################################################################################
85
86 SELECT COUNT(@@innodb_temp_data_file_path);
87 --echo 1 Expected
88
89 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
90 SELECT COUNT(@@local.innodb_temp_data_file_path);
91 --echo Expected error 'Variable is a GLOBAL variable'
92
93 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
94 SELECT COUNT(@@SESSION.innodb_temp_data_file_path);
95 --echo Expected error 'Variable is a GLOBAL variable'
96
97 SELECT COUNT(@@GLOBAL.innodb_temp_data_file_path);
98 --echo 1 Expected
99
100 --Error ER_BAD_FIELD_ERROR
101 SELECT innodb_temp_data_file_path;
102 --echo Expected error 'Unknown column'
103
104
105 --echo #
106 --echo # Bug #28590014 INNODB_DATA_FILE_PATH HAS A BAD DEFAULT VALUE
107 --echo #
108
109 SET PERSIST_ONLY innodb_temp_data_file_path = DEFAULT;
110
111 let $restart_parameters=;
112 --source include/restart_mysqld.inc
113
114 SELECT @@innodb_temp_data_file_path;
115
116 RESET PERSIST;