1'#---------------------BS_STVARS_035_01----------------------#'
2SELECT COUNT(@@GLOBAL.innodb_max_undo_log_size);
3COUNT(@@GLOBAL.innodb_max_undo_log_size)
41
51 Expected
6'#---------------------BS_STVARS_035_02----------------------#'
7SET @@GLOBAL.innodb_max_undo_log_size=1073741824;
8SELECT COUNT(@@GLOBAL.innodb_max_undo_log_size);
9COUNT(@@GLOBAL.innodb_max_undo_log_size)
101
111 Expected
12SET @@GLOBAL.innodb_max_undo_log_size=18446744073709551615;
13SELECT @@GLOBAL.innodb_max_undo_log_size;
14@@GLOBAL.innodb_max_undo_log_size
1518446744073709551615
1618446744073709551615 Expected
17SET @@GLOBAL.innodb_max_undo_log_size=1073741824;
18'#---------------------BS_STVARS_035_03----------------------#'
19SELECT @@GLOBAL.innodb_max_undo_log_size = VARIABLE_VALUE
20FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
21WHERE VARIABLE_NAME='innodb_max_undo_log_size';
22@@GLOBAL.innodb_max_undo_log_size = VARIABLE_VALUE
231
241 Expected
25SELECT COUNT(@@GLOBAL.innodb_max_undo_log_size);
26COUNT(@@GLOBAL.innodb_max_undo_log_size)
271
281 Expected
29SELECT COUNT(VARIABLE_VALUE)
30FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
31WHERE VARIABLE_NAME='innodb_max_undo_log_size';
32COUNT(VARIABLE_VALUE)
331
341 Expected
35'#---------------------BS_STVARS_035_04----------------------#'
36SELECT @@innodb_max_undo_log_size = @@GLOBAL.innodb_max_undo_log_size;
37@@innodb_max_undo_log_size = @@GLOBAL.innodb_max_undo_log_size
381
391 Expected
40'#---------------------BS_STVARS_035_05----------------------#'
41SELECT COUNT(@@innodb_max_undo_log_size);
42COUNT(@@innodb_max_undo_log_size)
431
441 Expected
45SELECT COUNT(@@local.innodb_max_undo_log_size);
46ERROR HY000: Variable 'innodb_max_undo_log_size' is a GLOBAL variable
47Expected error 'Variable is a GLOBAL variable'
48SELECT COUNT(@@SESSION.innodb_max_undo_log_size);
49ERROR HY000: Variable 'innodb_max_undo_log_size' is a GLOBAL variable
50Expected error 'Variable is a GLOBAL variable'
51SELECT COUNT(@@GLOBAL.innodb_max_undo_log_size);
52COUNT(@@GLOBAL.innodb_max_undo_log_size)
531
541 Expected
55