Debian Codegraph @

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

raw
1 ################## mysql-test/t/innodb_undo_directory_basic.test ##############
2 # #
3 # Variable Name: innodb_undo_directory #
4 # Scope: Global #
5 # Access Type: Static #
6 # Data Type: string #
7 # #
8 # #
9 # Creation Date: 2011-07-05 #
10 # Author : Sunny Bains #
11 # #
12 # #
13 # Description: Read-only config global variable innodb_undo_directory #
14 # * Value check #
15 # * Scope check #
16 # #
17 ###############################################################################
18
19
20 ####################################################################
21 # Display the default value #
22 ####################################################################
23 SELECT COUNT(@@GLOBAL.innodb_undo_directory);
24 --echo 1 Expected
25
26
27 ####################################################################
28 # Check if Value can set #
29 ####################################################################
30
31 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
32 SET @@GLOBAL.innodb_undo_directory="/tmp";
33 --echo Expected error 'Read only variable'
34
35 SELECT COUNT(@@GLOBAL.innodb_undo_directory);
36 --echo 1 Expected
37
38
39 ################################################################################
40 # Check if the value in GLOBAL table matches value in variable #
41 ################################################################################
42
43 --disable_warnings
44 SELECT @@GLOBAL.innodb_undo_directory = VARIABLE_VALUE
45 FROM performance_schema.global_variables
46 WHERE VARIABLE_NAME='innodb_undo_directory';
47 --enable_warnings
48 --echo 1 Expected
49
50 SELECT COUNT(@@GLOBAL.innodb_undo_directory);
51 --echo 1 Expected
52
53 --disable_warnings
54 SELECT COUNT(VARIABLE_VALUE)
55 FROM performance_schema.global_variables
56 WHERE VARIABLE_NAME='innodb_undo_directory';
57 --enable_warnings
58 --echo 1 Expected
59
60
61 ################################################################################
62 # Check if accessing variable with and without GLOBAL point to same variable #
63 ################################################################################
64 SELECT @@innodb_undo_directory = @@GLOBAL.innodb_undo_directory;
65 --echo 1 Expected
66
67
68 ################################################################################
69 # Check if innodb_undo_directory can be accessed with and without @@ sign #
70 ################################################################################
71
72 SELECT COUNT(@@innodb_undo_directory);
73 --echo 1 Expected
74
75 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
76 SELECT COUNT(@@local.innodb_undo_directory);
77 --echo Expected error 'Variable is a GLOBAL variable'
78
79 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
80 SELECT COUNT(@@SESSION.innodb_undo_directory);
81 --echo Expected error 'Variable is a GLOBAL variable'
82
83 SELECT COUNT(@@GLOBAL.innodb_undo_directory);
84 --echo 1 Expected
85
86 --Error ER_BAD_FIELD_ERROR
87 SELECT innodb_undo_directory;
88 --echo Expected error 'Unknown column'