Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_strict_mode_basic.result

raw
1 SET @start_global_value = @@global.innodb_strict_mode;
2 SELECT @start_global_value;
3 @start_global_value
4 1
5 Valid values are 'ON' and 'OFF'
6 select @@global.innodb_strict_mode in (0, 1);
7 @@global.innodb_strict_mode in (0, 1)
8 1
9 select @@global.innodb_strict_mode;
10 @@global.innodb_strict_mode
11 1
12 select @@session.innodb_strict_mode in (0, 1);
13 @@session.innodb_strict_mode in (0, 1)
14 1
15 select @@session.innodb_strict_mode;
16 @@session.innodb_strict_mode
17 1
18 show global variables like 'innodb_strict_mode';
19 Variable_name Value
20 innodb_strict_mode ON
21 show session variables like 'innodb_strict_mode';
22 Variable_name Value
23 innodb_strict_mode ON
24 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
25 VARIABLE_NAME VARIABLE_VALUE
26 INNODB_STRICT_MODE ON
27 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
28 VARIABLE_NAME VARIABLE_VALUE
29 INNODB_STRICT_MODE ON
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
34 0
35 select @@session.innodb_strict_mode;
36 @@session.innodb_strict_mode
37 0
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
48 1
49 select @@session.innodb_strict_mode;
50 @@session.innodb_strict_mode
51 1
52 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
53 VARIABLE_NAME VARIABLE_VALUE
54 INNODB_STRICT_MODE ON
55 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
56 VARIABLE_NAME VARIABLE_VALUE
57 INNODB_STRICT_MODE ON
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
62 0
63 select @@session.innodb_strict_mode;
64 @@session.innodb_strict_mode
65 0
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
76 1
77 select @@session.innodb_strict_mode;
78 @@session.innodb_strict_mode
79 1
80 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
81 VARIABLE_NAME VARIABLE_VALUE
82 INNODB_STRICT_MODE ON
83 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
84 VARIABLE_NAME VARIABLE_VALUE
85 INNODB_STRICT_MODE ON
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 set global innodb_strict_mode=-3;
103 ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of '-3'
104 set session innodb_strict_mode=-7;
105 ERROR 42000: Variable 'innodb_strict_mode' can't be set to the value of '-7'
106 select @@global.innodb_strict_mode;
107 @@global.innodb_strict_mode
108 1
109 select @@session.innodb_strict_mode;
110 @@session.innodb_strict_mode
111 1
112 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
113 VARIABLE_NAME VARIABLE_VALUE
114 INNODB_STRICT_MODE ON
115 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
116 VARIABLE_NAME VARIABLE_VALUE
117 INNODB_STRICT_MODE ON
118 SET @@global.innodb_strict_mode = @start_global_value;
119 SELECT @@global.innodb_strict_mode;
120 @@global.innodb_strict_mode
121 1