1#
2# innodb_disallow_writes
3#
4# save the initial value
5SET @innodb_disallow_writes_global_saved = @@global.innodb_disallow_writes;
6# default
7SELECT @@global.innodb_disallow_writes;
8@@global.innodb_disallow_writes
90
10
11# scope
12SELECT @@session.innodb_disallow_writes;
13ERROR HY000: Variable 'innodb_disallow_writes' is a GLOBAL variable
14SET @@global.innodb_disallow_writes=OFF;
15SELECT @@global.innodb_disallow_writes;
16@@global.innodb_disallow_writes
170
18SET @@global.innodb_disallow_writes=ON;
19SELECT @@global.innodb_disallow_writes;
20@@global.innodb_disallow_writes
211
22
23# valid values
24SET @@global.innodb_disallow_writes='OFF';
25SELECT @@global.innodb_disallow_writes;
26@@global.innodb_disallow_writes
270
28SET @@global.innodb_disallow_writes=ON;
29SELECT @@global.innodb_disallow_writes;
30@@global.innodb_disallow_writes
311
32SET @@global.innodb_disallow_writes=default;
33SELECT @@global.innodb_disallow_writes;
34@@global.innodb_disallow_writes
350
36
37# invalid values
38SET @@global.innodb_disallow_writes=NULL;
39ERROR 42000: Variable 'innodb_disallow_writes' can't be set to the value of 'NULL'
40SET @@global.innodb_disallow_writes='junk';
41ERROR 42000: Variable 'innodb_disallow_writes' can't be set to the value of 'junk'
42
43# restore the initial value
44SET @@global.innodb_disallow_writes = @innodb_disallow_writes_global_saved;
45# End of test
46