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