Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.innodb_undo_directory);
2 COUNT(@@GLOBAL.innodb_undo_directory)
3 1
4 1 Expected
5 SET @@GLOBAL.innodb_undo_directory="/tmp";
6 ERROR HY000: Variable 'innodb_undo_directory' is a read only variable
7 Expected error 'Read only variable'
8 SELECT COUNT(@@GLOBAL.innodb_undo_directory);
9 COUNT(@@GLOBAL.innodb_undo_directory)
10 1
11 1 Expected
12 SELECT @@GLOBAL.innodb_undo_directory = VARIABLE_VALUE
13 FROM performance_schema.global_variables
14 WHERE VARIABLE_NAME='innodb_undo_directory';
15 @@GLOBAL.innodb_undo_directory = VARIABLE_VALUE
16 1
17 1 Expected
18 SELECT COUNT(@@GLOBAL.innodb_undo_directory);
19 COUNT(@@GLOBAL.innodb_undo_directory)
20 1
21 1 Expected
22 SELECT COUNT(VARIABLE_VALUE)
23 FROM performance_schema.global_variables
24 WHERE VARIABLE_NAME='innodb_undo_directory';
25 COUNT(VARIABLE_VALUE)
26 1
27 1 Expected
28 SELECT @@innodb_undo_directory = @@GLOBAL.innodb_undo_directory;
29 @@innodb_undo_directory = @@GLOBAL.innodb_undo_directory
30 1
31 1 Expected
32 SELECT COUNT(@@innodb_undo_directory);
33 COUNT(@@innodb_undo_directory)
34 1
35 1 Expected
36 SELECT COUNT(@@local.innodb_undo_directory);
37 ERROR HY000: Variable 'innodb_undo_directory' is a GLOBAL variable
38 Expected error 'Variable is a GLOBAL variable'
39 SELECT COUNT(@@SESSION.innodb_undo_directory);
40 ERROR HY000: Variable 'innodb_undo_directory' is a GLOBAL variable
41 Expected error 'Variable is a GLOBAL variable'
42 SELECT COUNT(@@GLOBAL.innodb_undo_directory);
43 COUNT(@@GLOBAL.innodb_undo_directory)
44 1
45 1 Expected
46 SELECT innodb_undo_directory;
47 ERROR 42S22: Unknown column 'innodb_undo_directory' in 'field list'
48 Expected error 'Unknown column'