1
SET @start_global_value = @@global.innodb_strict_mode;
2
SELECT @start_global_value;
5
Valid values are 'ON' and 'OFF'
6
select @@global.innodb_strict_mode in (0, 1);
7
@@global.innodb_strict_mode in (0, 1)
9
select @@global.innodb_strict_mode;
10
@@global.innodb_strict_mode
12
select @@session.innodb_strict_mode in (0, 1);
13
@@session.innodb_strict_mode in (0, 1)
15
select @@session.innodb_strict_mode;
16
@@session.innodb_strict_mode
18
show global variables like 'innodb_strict_mode';
20
innodb_strict_mode OFF
21
show session variables like 'innodb_strict_mode';
23
innodb_strict_mode OFF
24
select * from information_schema.global_variables where variable_name='innodb_strict_mode';
25
VARIABLE_NAME VARIABLE_VALUE
26
INNODB_STRICT_MODE OFF
27
select * from information_schema.session_variables where variable_name='innodb_strict_mode';
28
VARIABLE_NAME VARIABLE_VALUE
29
INNODB_STRICT_MODE OFF
30
set global innodb_strict_mode='OFF';
31
set session innodb_strict_mode='OFF';
32
select @@global.innodb_strict_mode;
33
@@global.innodb_strict_mode
35
select @@session.innodb_strict_mode;
36
@@session.innodb_strict_mode
38
select * from information_schema.global_variables where variable_name='innodb_strict_mode';
39
VARIABLE_NAME VARIABLE_VALUE
40
INNODB_STRICT_MODE OFF
41
select * from information_schema.session_variables where variable_name='innodb_strict_mode';
42
VARIABLE_NAME VARIABLE_VALUE
43
INNODB_STRICT_MODE OFF
44
set @@global.innodb_strict_mode=1;
45
set @@session.innodb_strict_mode=1;
46
select @@global.innodb_strict_mode;
47
@@global.innodb_strict_mode
49
select @@session.innodb_strict_mode;
50
@@session.innodb_strict_mode
52
select * from information_schema.global_variables where variable_name='innodb_strict_mode';
53
VARIABLE_NAME VARIABLE_VALUE
55
select * from information_schema.session_variables where variable_name='innodb_strict_mode';
56
VARIABLE_NAME VARIABLE_VALUE
58
set global innodb_strict_mode=0;
59
set session innodb_strict_mode=0;
60
select @@global.innodb_strict_mode;
61
@@global.innodb_strict_mode
63
select @@session.innodb_strict_mode;
64
@@session.innodb_strict_mode
66
select * from information_schema.global_variables where variable_name='innodb_strict_mode';
67
VARIABLE_NAME VARIABLE_VALUE
68
INNODB_STRICT_MODE OFF
69
select * from information_schema.session_variables where variable_name='innodb_strict_mode';
70
VARIABLE_NAME VARIABLE_VALUE
71
INNODB_STRICT_MODE OFF
72
set @@global.innodb_strict_mode='ON';
73
set @@session.innodb_strict_mode='ON';
74
select @@global.innodb_strict_mode;
75
@@global.innodb_strict_mode
77
select @@session.innodb_strict_mode;
78
@@session.innodb_strict_mode
80
select * from information_schema.global_variables where variable_name='innodb_strict_mode';
81
VARIABLE_NAME VARIABLE_VALUE
83
select * from information_schema.session_variables where variable_name='innodb_strict_mode';
84
VARIABLE_NAME VARIABLE_VALUE
86
set global innodb_strict_mode=1.1;
87
ERROR 42000: Incorrect argument type to variable 'innodb_strict_mode'
88
set session innodb_strict_mode=1.1;
89
ERROR 42000: Incorrect argument type to variable 'innodb_strict_mode'
90
set global innodb_strict_mode=1e1;
91
ERROR 42000: Incorrect argument type to variable 'innodb_strict_mode'
92
set session innodb_strict_mode=1e1;
93
ERROR 42000: Incorrect argument type to variable 'innodb_strict_mode'
94
set global innodb_strict_mode=2;
95
ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of '2'
96
set session innodb_strict_mode=2;
97
ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of '2'
98
set global innodb_strict_mode='AUTO';
99
ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of 'AUTO'
100
set session innodb_strict_mode='AUTO';
101
ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of 'AUTO'
102
NOTE: The following should fail with ER_WRONG_VALUE_FOR_VAR (BUG#50643)
103
set global innodb_strict_mode=-3;
104
set session innodb_strict_mode=-7;
105
select @@global.innodb_strict_mode;
106
@@global.innodb_strict_mode
108
select @@session.innodb_strict_mode;
109
@@session.innodb_strict_mode
111
select * from information_schema.global_variables where variable_name='innodb_strict_mode';
112
VARIABLE_NAME VARIABLE_VALUE
113
INNODB_STRICT_MODE ON
114
select * from information_schema.session_variables where variable_name='innodb_strict_mode';
115
VARIABLE_NAME VARIABLE_VALUE
116
INNODB_STRICT_MODE ON
117
SET @@global.innodb_strict_mode = @start_global_value;
118
SELECT @@global.innodb_strict_mode;
119
@@global.innodb_strict_mode