Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_undo_tablespaces_basic.result

raw
1 SELECT @@GLOBAL.innodb_undo_tablespaces >= 0;
2 @@GLOBAL.innodb_undo_tablespaces >= 0
3 1
4 SET @@GLOBAL.innodb_undo_tablespaces=128;
5 ERROR HY000: Variable 'innodb_undo_tablespaces' is a read only variable
6 Expected error 'Read only variable'
7 SELECT COUNT(@@GLOBAL.innodb_undo_tablespaces);
8 COUNT(@@GLOBAL.innodb_undo_tablespaces)
9 1
10 1 Expected
11 DIFFERENCE
12 0
13 0 Expected
14 SELECT @@innodb_undo_tablespaces = @@GLOBAL.innodb_undo_tablespaces;
15 @@innodb_undo_tablespaces = @@GLOBAL.innodb_undo_tablespaces
16 1
17 1 Expected
18 SELECT COUNT(@@innodb_undo_tablespaces);
19 COUNT(@@innodb_undo_tablespaces)
20 1
21 1 Expected
22 SELECT COUNT(@@local.innodb_undo_tablespaces);
23 ERROR HY000: Variable 'innodb_undo_tablespaces' is a GLOBAL variable
24 Expected error 'Variable is a GLOBAL variable'
25 SELECT COUNT(@@SESSION.innodb_undo_tablespaces);
26 ERROR HY000: Variable 'innodb_undo_tablespaces' is a GLOBAL variable
27 Expected error 'Variable is a GLOBAL variable'
28 SELECT COUNT(@@GLOBAL.innodb_undo_tablespaces);
29 COUNT(@@GLOBAL.innodb_undo_tablespaces)
30 1
31 1 Expected
32 SELECT innodb_undo_tablespaces = @@SESSION.innodb_undo_tablespaces;
33 ERROR 42S22: Unknown column 'innodb_undo_tablespaces' in 'SELECT'
34 Expected error 'Readonly variable'