SELECT COUNT(@@GLOBAL.innodb_doublewrite_pages); --echo 1 Expected --error ER_INCORRECT_GLOBAL_LOCAL_VAR SET @@GLOBAL.innodb_doublewrite_pages=1; --echo Expected error 'Read only variable' SELECT COUNT(@@GLOBAL.innodb_doublewrite_pages); --echo 1 Expected --disable_warnings SELECT @@GLOBAL.innodb_doublewrite_pages = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='innodb_doublewrite_pages'; --enable_warnings --echo 1 Expected SELECT COUNT(@@GLOBAL.innodb_doublewrite_pages); --echo 1 Expected --disable_warnings SELECT COUNT(VARIABLE_VALUE) FROM performance_schema.global_variables WHERE VARIABLE_NAME='innodb_doublewrite_pages'; --enable_warnings --echo 1 Expected SELECT @@innodb_doublewrite_pages = @@GLOBAL.innodb_doublewrite_pages; --echo 1 Expected SELECT COUNT(@@innodb_doublewrite_pages); --echo 1 Expected --Error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT COUNT(@@local.innodb_doublewrite_pages); --echo Expected error 'Variable is a GLOBAL variable' --Error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT COUNT(@@SESSION.innodb_doublewrite_pages); --echo Expected error 'Variable is a GLOBAL variable' SELECT COUNT(@@GLOBAL.innodb_doublewrite_pages); --echo 1 Expected --Error ER_BAD_FIELD_ERROR SELECT innodb_doublewrite_pages; --echo Expected error 'Unknown column'