Debian Codegraph @

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

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