Debian Codegraph @

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

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