1SELECT @@GLOBAL.innodb_undo_logs; 2@@GLOBAL.innodb_undo_logs 3128 4128 Expected 5SET @@GLOBAL.innodb_undo_logs=128; 6SELECT COUNT(@@GLOBAL.innodb_undo_logs); 7COUNT(@@GLOBAL.innodb_undo_logs) 81 91 Expected 10SELECT VARIABLE_VALUE 11FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 12WHERE VARIABLE_NAME='innodb_undo_logs'; 13VARIABLE_VALUE 14128 15128 Expected 16SELECT @@innodb_undo_logs = @@GLOBAL.innodb_undo_logs; 17@@innodb_undo_logs = @@GLOBAL.innodb_undo_logs 181 191 Expected 20SELECT COUNT(@@innodb_undo_logs); 21COUNT(@@innodb_undo_logs) 221 231 Expected 24SELECT COUNT(@@local.innodb_undo_logs); 25ERROR HY000: Variable 'innodb_undo_logs' is a GLOBAL variable 26Expected error 'Variable is a GLOBAL variable' 27SELECT COUNT(@@SESSION.innodb_undo_logs); 28ERROR HY000: Variable 'innodb_undo_logs' is a GLOBAL variable 29Expected error 'Variable is a GLOBAL variable' 30SELECT innodb_undo_logs = @@SESSION.innodb_undo_logs; 31ERROR 42S22: Unknown column 'innodb_undo_logs' in 'field list' 32Begin bug 13604034 33select @@innodb_undo_logs; 34@@innodb_undo_logs 35128 36128 Expected 37set global innodb_undo_logs = 129; 38Warnings: 39Warning 1292 Truncated incorrect innodb_undo_logs value: '129' 40select @@innodb_undo_logs; 41@@innodb_undo_logs 42128 43128 Expected 44set global innodb_undo_logs = 0; 45Warnings: 46Warning 1292 Truncated incorrect innodb_undo_logs value: '0' 47select @@innodb_undo_logs; 48@@innodb_undo_logs 491 501 Expected 51set global innodb_undo_logs = -1; 52Warnings: 53Warning 1292 Truncated incorrect innodb_undo_logs value: '-1' 54select @@innodb_undo_logs; 55@@innodb_undo_logs 561 571 Expected 58set global innodb_undo_logs = 50; 59select @@innodb_undo_logs; 60@@innodb_undo_logs 6150 6250 Expected 63set global innodb_undo_logs = default; 64select @@innodb_undo_logs; 65@@innodb_undo_logs 66128 67128 Expected 68End bug 13604034 69