Debian Codegraph @

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

raw
1 #
2 # Basic test for innodb_ddl_log_crash_reset_debug
3 #
4 # Save default value.
5 SET @default_var_value = @@GLOBAL.innodb_ddl_log_crash_reset_debug;
6 SELECT @@GLOBAL.innodb_ddl_log_crash_reset_debug;
7 @@GLOBAL.innodb_ddl_log_crash_reset_debug
8 0
9 # Try setting to 1.
10 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = 1;
11 SELECT @@GLOBAL.innodb_ddl_log_crash_reset_debug;
12 @@GLOBAL.innodb_ddl_log_crash_reset_debug
13 1
14 # Try setting to 0.
15 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = 0;
16 SELECT @@GLOBAL.innodb_ddl_log_crash_reset_debug;
17 @@GLOBAL.innodb_ddl_log_crash_reset_debug
18 0
19 # Try setting to 1 (again).
20 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = 1;
21 SELECT @@GLOBAL.innodb_ddl_log_crash_reset_debug;
22 @@GLOBAL.innodb_ddl_log_crash_reset_debug
23 1
24 # Try setting to 0 (again).
25 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = 0;
26 SELECT @@GLOBAL.innodb_ddl_log_crash_reset_debug;
27 @@GLOBAL.innodb_ddl_log_crash_reset_debug
28 0
29 # Check what happens if we set the same value as current.
30 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = 1;
31 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = 1;
32 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = 0;
33 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = 0;
34 # Try using variable as local.
35 SET innodb_ddl_log_crash_reset_debug = 1;
36 ERROR HY000: Variable 'innodb_ddl_log_crash_reset_debug' is a GLOBAL variable and should be set with SET GLOBAL
37 # Finished. Restore default value.
38 SET @@GLOBAL.innodb_ddl_log_crash_reset_debug = @default_var_value;