Debian Codegraph @

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

raw
1
2
3 # 2010-01-25 - Added
4 #
5
6 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_strict_mode;
9 SELECT @start_global_value;
10
11 #
12 # exists as global and session
13 #
14 --echo Valid values are 'ON' and 'OFF'
15 select @@global.innodb_strict_mode in (0, 1);
16 select @@global.innodb_strict_mode;
17 select @@session.innodb_strict_mode in (0, 1);
18 select @@session.innodb_strict_mode;
19 show global variables like 'innodb_strict_mode';
20 show session variables like 'innodb_strict_mode';
21 --disable_warnings
22 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
23 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
24 --enable_warnings
25
26 #
27 # show that it's writable
28 #
29 set global innodb_strict_mode='OFF';
30 set session innodb_strict_mode='OFF';
31 select @@global.innodb_strict_mode;
32 select @@session.innodb_strict_mode;
33 --disable_warnings
34 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
35 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
36 --enable_warnings
37 set @@global.innodb_strict_mode=1;
38 set @@session.innodb_strict_mode=1;
39 select @@global.innodb_strict_mode;
40 select @@session.innodb_strict_mode;
41 --disable_warnings
42 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
43 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
44 --enable_warnings
45 set global innodb_strict_mode=0;
46 set session innodb_strict_mode=0;
47 select @@global.innodb_strict_mode;
48 select @@session.innodb_strict_mode;
49 --disable_warnings
50 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
51 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
52 --enable_warnings
53 set @@global.innodb_strict_mode='ON';
54 set @@session.innodb_strict_mode='ON';
55 select @@global.innodb_strict_mode;
56 select @@session.innodb_strict_mode;
57 --disable_warnings
58 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
59 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
60 --enable_warnings
61
62 #
63 # incorrect types
64 #
65 --error ER_WRONG_TYPE_FOR_VAR
66 set global innodb_strict_mode=1.1;
67 --error ER_WRONG_TYPE_FOR_VAR
68 set session innodb_strict_mode=1.1;
69 --error ER_WRONG_TYPE_FOR_VAR
70 set global innodb_strict_mode=1e1;
71 --error ER_WRONG_TYPE_FOR_VAR
72 set session innodb_strict_mode=1e1;
73 --error ER_WRONG_VALUE_FOR_VAR
74 set global innodb_strict_mode=2;
75 --error ER_WRONG_VALUE_FOR_VAR
76 set session innodb_strict_mode=2;
77 --error ER_WRONG_VALUE_FOR_VAR
78 set global innodb_strict_mode='AUTO';
79 --error ER_WRONG_VALUE_FOR_VAR
80 set session innodb_strict_mode='AUTO';
81 --error ER_WRONG_VALUE_FOR_VAR
82 set global innodb_strict_mode=-3;
83 --error ER_WRONG_VALUE_FOR_VAR
84 set session innodb_strict_mode=-7;
85 select @@global.innodb_strict_mode;
86 select @@session.innodb_strict_mode;
87 --disable_warnings
88 select * from information_schema.global_variables where variable_name='innodb_strict_mode';
89 select * from information_schema.session_variables where variable_name='innodb_strict_mode';
90 --enable_warnings
91
92 #
93 # Cleanup
94 #
95
96 SET @@global.innodb_strict_mode = @start_global_value;
97 SELECT @@global.innodb_strict_mode;