Debian Codegraph @

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

raw
1
2
3 # 2010-01-25 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_strict_mode;
8 SELECT @start_global_value;
9
10 #
11 # exists as global and session
12 #
13 --echo Valid values are 'ON' and 'OFF'
14 select @@global.innodb_strict_mode in (0, 1);
15 select @@global.innodb_strict_mode;
16 select @@session.innodb_strict_mode in (0, 1);
17 select @@session.innodb_strict_mode;
18 show global variables like 'innodb_strict_mode';
19 show session variables like 'innodb_strict_mode';
20 --disable_warnings
21 select * from performance_schema.global_variables where variable_name='innodb_strict_mode';
22 select * from performance_schema.session_variables where variable_name='innodb_strict_mode';
23 --enable_warnings
24
25 #
26 # show that it's writable
27 #
28 set global innodb_strict_mode='OFF';
29 set session innodb_strict_mode='OFF';
30 select @@global.innodb_strict_mode;
31 select @@session.innodb_strict_mode;
32 --disable_warnings
33 select * from performance_schema.global_variables where variable_name='innodb_strict_mode';
34 select * from performance_schema.session_variables where variable_name='innodb_strict_mode';
35 --enable_warnings
36 set @@global.innodb_strict_mode=1;
37 set @@session.innodb_strict_mode=1;
38 select @@global.innodb_strict_mode;
39 select @@session.innodb_strict_mode;
40 --disable_warnings
41 select * from performance_schema.global_variables where variable_name='innodb_strict_mode';
42 select * from performance_schema.session_variables where variable_name='innodb_strict_mode';
43 --enable_warnings
44 set global innodb_strict_mode=0;
45 set session innodb_strict_mode=0;
46 select @@global.innodb_strict_mode;
47 select @@session.innodb_strict_mode;
48 --disable_warnings
49 select * from performance_schema.global_variables where variable_name='innodb_strict_mode';
50 select * from performance_schema.session_variables where variable_name='innodb_strict_mode';
51 --enable_warnings
52 set @@global.innodb_strict_mode='ON';
53 set @@session.innodb_strict_mode='ON';
54 select @@global.innodb_strict_mode;
55 select @@session.innodb_strict_mode;
56 --disable_warnings
57 select * from performance_schema.global_variables where variable_name='innodb_strict_mode';
58 select * from performance_schema.session_variables where variable_name='innodb_strict_mode';
59 --enable_warnings
60
61 #
62 # incorrect types
63 #
64 --error ER_WRONG_TYPE_FOR_VAR
65 set global innodb_strict_mode=1.1;
66 --error ER_WRONG_TYPE_FOR_VAR
67 set session innodb_strict_mode=1.1;
68 --error ER_WRONG_TYPE_FOR_VAR
69 set global innodb_strict_mode=1e1;
70 --error ER_WRONG_TYPE_FOR_VAR
71 set session innodb_strict_mode=1e1;
72 --error ER_WRONG_VALUE_FOR_VAR
73 set global innodb_strict_mode=2;
74 --error ER_WRONG_VALUE_FOR_VAR
75 set session innodb_strict_mode=2;
76 --error ER_WRONG_VALUE_FOR_VAR
77 set global innodb_strict_mode='AUTO';
78 --error ER_WRONG_VALUE_FOR_VAR
79 set session innodb_strict_mode='AUTO';
80 --error ER_WRONG_VALUE_FOR_VAR
81 set global innodb_strict_mode=-3;
82 --error ER_WRONG_VALUE_FOR_VAR
83 set session innodb_strict_mode=-7;
84 select @@global.innodb_strict_mode;
85 select @@session.innodb_strict_mode;
86 --disable_warnings
87 select * from performance_schema.global_variables where variable_name='innodb_strict_mode';
88 select * from performance_schema.session_variables where variable_name='innodb_strict_mode';
89 --enable_warnings
90
91 ######################################################################################
92 # Check if changing session variable throws error without sufficient privileges #
93 ######################################################################################
94 CREATE USER foo, bar;
95 GRANT SESSION_VARIABLES_ADMIN ON *.* TO bar;
96 --let $conn_name = foo_connection
97 --connect($conn_name, localhost, foo,,,)
98 SELECT @@session.innodb_strict_mode;
99 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
100 SET @@session.innodb_strict_mode = 'OFF';
101 --connection default
102 disconnect $conn_name;
103 --let $conn_name = bar_connection
104 --connect($conn_name, localhost, bar,,,)
105 SELECT @@session.innodb_strict_mode;
106 SET @@session.innodb_strict_mode = 'OFF';
107 SET @@session.innodb_strict_mode = 1;
108 SET @@session.innodb_strict_mode = FALSE;
109 SELECT @@session.innodb_strict_mode;
110 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
111 SET @@global.innodb_strict_mode = FALSE;
112 --Error ER_WRONG_VALUE_FOR_VAR
113 SET @@session.innodb_table_locks = -1;
114 --Error ER_WRONG_VALUE_FOR_VAR
115 SET @@session.innodb_table_locks = 'STR';
116 --connection default
117 disconnect $conn_name;
118 DROP USER foo, bar;
119
120 #
121 # Cleanup
122 #
123
124 SET @@global.innodb_strict_mode = @start_global_value;
125 SELECT @@global.innodb_strict_mode;