SELECT @@GLOBAL.innodb_undo_logs; @@GLOBAL.innodb_undo_logs 128 128 Expected SET @@GLOBAL.innodb_undo_logs=128; SELECT COUNT(@@GLOBAL.innodb_undo_logs); COUNT(@@GLOBAL.innodb_undo_logs) 1 1 Expected SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_undo_logs'; VARIABLE_VALUE 128 128 Expected SELECT @@innodb_undo_logs = @@GLOBAL.innodb_undo_logs; @@innodb_undo_logs = @@GLOBAL.innodb_undo_logs 1 1 Expected SELECT COUNT(@@innodb_undo_logs); COUNT(@@innodb_undo_logs) 1 1 Expected SELECT COUNT(@@local.innodb_undo_logs); ERROR HY000: Variable 'innodb_undo_logs' is a GLOBAL variable Expected error 'Variable is a GLOBAL variable' SELECT COUNT(@@SESSION.innodb_undo_logs); ERROR HY000: Variable 'innodb_undo_logs' is a GLOBAL variable Expected error 'Variable is a GLOBAL variable' SELECT innodb_undo_logs = @@SESSION.innodb_undo_logs; ERROR 42S22: Unknown column 'innodb_undo_logs' in 'field list' Begin bug 13604034 select @@innodb_undo_logs; @@innodb_undo_logs 128 128 Expected set global innodb_undo_logs = 129; Warnings: Warning 1292 Truncated incorrect innodb_undo_logs value: '129' select @@innodb_undo_logs; @@innodb_undo_logs 128 128 Expected set global innodb_undo_logs = 0; Warnings: Warning 1292 Truncated incorrect innodb_undo_logs value: '0' select @@innodb_undo_logs; @@innodb_undo_logs 1 1 Expected set global innodb_undo_logs = -1; Warnings: Warning 1292 Truncated incorrect innodb_undo_logs value: '-1' select @@innodb_undo_logs; @@innodb_undo_logs 1 1 Expected set global innodb_undo_logs = 50; select @@innodb_undo_logs; @@innodb_undo_logs 50 50 Expected set global innodb_undo_logs = default; select @@innodb_undo_logs; @@innodb_undo_logs 128 128 Expected End bug 13604034