Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.innodb_temp_tablespaces_dir);
2 COUNT(@@GLOBAL.innodb_temp_tablespaces_dir)
3 1
4 1 Expected
5 SET @@GLOBAL.innodb_temp_tablespaces_dir="/tmp";
6 ERROR HY000: Variable 'innodb_temp_tablespaces_dir' is a read only variable
7 Expected error 'Read only variable'
8 SELECT COUNT(@@GLOBAL.innodb_temp_tablespaces_dir);
9 COUNT(@@GLOBAL.innodb_temp_tablespaces_dir)
10 1
11 1 Expected
12 SELECT @@GLOBAL.innodb_temp_tablespaces_dir = VARIABLE_VALUE
13 FROM performance_schema.global_variables
14 WHERE VARIABLE_NAME='innodb_temp_tablespaces_dir';
15 @@GLOBAL.innodb_temp_tablespaces_dir = VARIABLE_VALUE
16 1
17 1 Expected
18 SELECT COUNT(@@GLOBAL.innodb_temp_tablespaces_dir);
19 COUNT(@@GLOBAL.innodb_temp_tablespaces_dir)
20 1
21 1 Expected
22 SELECT COUNT(VARIABLE_VALUE)
23 FROM performance_schema.global_variables
24 WHERE VARIABLE_NAME='innodb_temp_tablespaces_dir';
25 COUNT(VARIABLE_VALUE)
26 1
27 1 Expected
28 SELECT @@innodb_temp_tablespaces_dir = @@GLOBAL.innodb_temp_tablespaces_dir;
29 @@innodb_temp_tablespaces_dir = @@GLOBAL.innodb_temp_tablespaces_dir
30 1
31 1 Expected
32 SELECT @@innodb_temp_tablespaces_dir = VARIABLE_VALUE
33 FROM performance_schema.session_variables
34 WHERE VARIABLE_NAME='innodb_temp_tablespaces_dir';
35 @@innodb_temp_tablespaces_dir = VARIABLE_VALUE
36 1
37 1 Expected
38 SET PERSIST_ONLY innodb_temp_tablespaces_dir = "/tmp";
39 ERROR HY000: Variable 'innodb_temp_tablespaces_dir' is a non persistent read only variable
40 Expected error 'Non persistent read only variable'
41 SELECT COUNT(@@innodb_temp_tablespaces_dir);
42 COUNT(@@innodb_temp_tablespaces_dir)
43 1
44 1 Expected
45 SELECT COUNT(@@local.innodb_temp_tablespaces_dir);
46 ERROR HY000: Variable 'innodb_temp_tablespaces_dir' is a GLOBAL variable
47 Expected error 'Variable is a GLOBAL variable'
48 SELECT COUNT(@@SESSION.innodb_temp_tablespaces_dir);
49 ERROR HY000: Variable 'innodb_temp_tablespaces_dir' is a GLOBAL variable
50 Expected error 'Variable is a GLOBAL variable'
51 SELECT COUNT(@@GLOBAL.innodb_temp_tablespaces_dir);
52 COUNT(@@GLOBAL.innodb_temp_tablespaces_dir)
53 1
54 1 Expected
55 SELECT innodb_temp_tablespaces_dir;
56 ERROR 42S22: Unknown column 'innodb_temp_tablespaces_dir' in 'field list'
57 Expected error 'Unknown column'
58 SET innodb_temp_tablespaces_dir = "/tmp";
59 ERROR HY000: Variable 'innodb_temp_tablespaces_dir' is a read only variable
60 Expected error 'Read only variable'
61 SET local.innodb_temp_tablespaces_dir = 1;
62 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.innodb_temp_tablespaces_dir = 1' at line 1
63 Expected error 'Parse error'
64 SELECT local.innodb_temp_tablespaces_dir;
65 ERROR 42S02: Unknown table 'local' in field list
66 Expected error 'Unknown table local in field list'
67 SET global.innodb_temp_tablespaces_dir = 1;
68 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.innodb_temp_tablespaces_dir = 1' at line 1
69 Expected error 'Parse error'
70 SELECT global.innodb_temp_tablespaces_dir;
71 ERROR 42S02: Unknown table 'global' in field list
72 Expected error 'Unknown table global in field list'
73 SELECT innodb_temp_tablespaces_dir;
74 ERROR 42S22: Unknown column 'innodb_temp_tablespaces_dir' in 'field list'
75 SELECT @@session.innodb_temp_tablespaces_dir;
76 ERROR HY000: Variable 'innodb_temp_tablespaces_dir' is a GLOBAL variable
77 SELECT innodb_temp_tablespaces_dir;
78 ERROR 42S22: Unknown column 'innodb_temp_tablespaces_dir' in 'field list'
79 Expected error 'Unknown column innodb_temp_tablespaces_dir in field list'