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