Debian Codegraph @

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

raw
1 #
2 # Basic test for innodb_merge_threshold_set_all_debug
3 #
4 SELECT @@global.innodb_merge_threshold_set_all_debug;
5 @@global.innodb_merge_threshold_set_all_debug
6 50
7 set global innodb_merge_threshold_set_all_debug = 1;
8 SELECT @@global.innodb_merge_threshold_set_all_debug;
9 @@global.innodb_merge_threshold_set_all_debug
10 1
11 set global innodb_merge_threshold_set_all_debug = 51;
12 Warnings:
13 Warning 1292 Truncated incorrect innodb_merge_threshold_set_all_debug value: '51'
14 SELECT @@global.innodb_merge_threshold_set_all_debug;
15 @@global.innodb_merge_threshold_set_all_debug
16 50
17 set global innodb_merge_threshold_set_all_debug = 0;
18 Warnings:
19 Warning 1292 Truncated incorrect innodb_merge_threshold_set_all_debug value: '0'
20 SELECT @@global.innodb_merge_threshold_set_all_debug;
21 @@global.innodb_merge_threshold_set_all_debug
22 1
23 set innodb_merge_threshold_set_all_debug = 50;
24 ERROR HY000: Variable 'innodb_merge_threshold_set_all_debug' is a GLOBAL variable and should be set with SET GLOBAL
25 set global innodb_merge_threshold_set_all_debug = 50;
26 SELECT @@global.innodb_merge_threshold_set_all_debug;
27 @@global.innodb_merge_threshold_set_all_debug
28 50