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