Debian Codegraph @

mysql-test/suite/sys_vars/t/mysqlx_enable_hello_notice_basic.test

raw
1 # Variable: mysqlx_enable_hello_notice
2 # Default : true
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 SET @mysqlx_enable_hello_notice_sav= @@global.mysqlx_enable_hello_notice;
7
8 ## Valid cases
9 SET GLOBAL mysqlx_enable_hello_notice=false;
10 show variables like 'mysqlx_enable_hello_notice';
11
12 SET @@global.mysqlx_enable_hello_notice=true;
13 show variables like 'mysqlx_enable_hello_notice';
14
15 ##
16 ## Invalid scope
17 --error ER_GLOBAL_VARIABLE
18 SET mysqlx_enable_hello_notice=true;
19 --error ER_GLOBAL_VARIABLE
20 SET @@local.mysqlx_enable_hello_notice=true;
21 --error ER_GLOBAL_VARIABLE
22 SET @@mysqlx_enable_hello_notice=true;
23 --error ER_GLOBAL_VARIABLE
24 SET @@session.mysqlx_enable_hello_notice=true;
25 --error ER_GLOBAL_VARIABLE
26 SET SESSION mysqlx_enable_hello_notice=true;
27
28 ##
29 ## Invalid value
30 --error ER_WRONG_VALUE_FOR_VAR
31 SET GLOBAL mysqlx_enable_hello_notice='%45*#in';
32 SELECT @@global.mysqlx_enable_hello_notice;
33 --Error ER_WRONG_VALUE_FOR_VAR
34 SET @@global.mysqlx_enable_hello_notice = 4294967296;
35 SELECT @@global.mysqlx_enable_hello_notice;
36 --Error ER_WRONG_VALUE_FOR_VAR
37 SET @@global.mysqlx_enable_hello_notice = 10240022115;
38 SELECT @@global.mysqlx_enable_hello_notice;
39 --Error ER_WRONG_TYPE_FOR_VAR
40 SET @@global.mysqlx_enable_hello_notice = 10000.01;
41 SELECT @@global.mysqlx_enable_hello_notice;
42 --Error ER_WRONG_VALUE_FOR_VAR
43 SET @@global.mysqlx_enable_hello_notice = 42949672950;
44 SELECT @@global.mysqlx_enable_hello_notice;
45
46 SET @@global.mysqlx_enable_hello_notice= @mysqlx_enable_hello_notice_sav;