Debian Codegraph @

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

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