Debian Codegraph @

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

raw
1 SET @mysqlx_enable_hello_notice_sav= @@global.mysqlx_enable_hello_notice;
2 SET GLOBAL mysqlx_enable_hello_notice=false;
3 show variables like 'mysqlx_enable_hello_notice';
4 Variable_name Value
5 mysqlx_enable_hello_notice OFF
6 SET @@global.mysqlx_enable_hello_notice=true;
7 show variables like 'mysqlx_enable_hello_notice';
8 Variable_name Value
9 mysqlx_enable_hello_notice ON
10 SET mysqlx_enable_hello_notice=true;
11 ERROR HY000: Variable 'mysqlx_enable_hello_notice' is a GLOBAL variable and should be set with SET GLOBAL
12 SET @@local.mysqlx_enable_hello_notice=true;
13 ERROR HY000: Variable 'mysqlx_enable_hello_notice' is a GLOBAL variable and should be set with SET GLOBAL
14 SET @@mysqlx_enable_hello_notice=true;
15 ERROR HY000: Variable 'mysqlx_enable_hello_notice' is a GLOBAL variable and should be set with SET GLOBAL
16 SET @@session.mysqlx_enable_hello_notice=true;
17 ERROR HY000: Variable 'mysqlx_enable_hello_notice' is a GLOBAL variable and should be set with SET GLOBAL
18 SET SESSION mysqlx_enable_hello_notice=true;
19 ERROR HY000: Variable 'mysqlx_enable_hello_notice' is a GLOBAL variable and should be set with SET GLOBAL
20 SET GLOBAL mysqlx_enable_hello_notice='%45*#in';
21 ERROR 42000: Variable 'mysqlx_enable_hello_notice' can't be set to the value of '%45*#in'
22 SELECT @@global.mysqlx_enable_hello_notice;
23 @@global.mysqlx_enable_hello_notice
24 1
25 SET @@global.mysqlx_enable_hello_notice = 4294967296;
26 ERROR 42000: Variable 'mysqlx_enable_hello_notice' can't be set to the value of '4294967296'
27 SELECT @@global.mysqlx_enable_hello_notice;
28 @@global.mysqlx_enable_hello_notice
29 1
30 SET @@global.mysqlx_enable_hello_notice = 10240022115;
31 ERROR 42000: Variable 'mysqlx_enable_hello_notice' can't be set to the value of '10240022115'
32 SELECT @@global.mysqlx_enable_hello_notice;
33 @@global.mysqlx_enable_hello_notice
34 1
35 SET @@global.mysqlx_enable_hello_notice = 10000.01;
36 ERROR 42000: Incorrect argument type to variable 'mysqlx_enable_hello_notice'
37 SELECT @@global.mysqlx_enable_hello_notice;
38 @@global.mysqlx_enable_hello_notice
39 1
40 SET @@global.mysqlx_enable_hello_notice = 42949672950;
41 ERROR 42000: Variable 'mysqlx_enable_hello_notice' can't be set to the value of '42949672950'
42 SELECT @@global.mysqlx_enable_hello_notice;
43 @@global.mysqlx_enable_hello_notice
44 1
45 SET @@global.mysqlx_enable_hello_notice= @mysqlx_enable_hello_notice_sav;