Debian Codegraph @

mysql-test/suite/x/t/system_variable_bind_address.test

raw
1 ## Test configuration
2 ##
3 --let $wait_for_unixsocket_status = no_wait
4 --let $wait_for_tcpsocket_status = no_wait
5 --source include/xplugin_preamble.inc
6
7 ## Test body
8 ##
9
10 --echo #
11 --echo #
12 --echo # X Plugin started with *
13 --echo #
14 --echo #
15
16 --let $assert_text= Mysqlx_bind_address global variablem must exist
17 --let $assert_cond= [SELECT COUNT(@@GLOBAL.Mysqlx_bind_address) as Result;, Result, 1] =1
18 --source include/assert.inc
19
20 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
21 SET @@GLOBAL.Mysqlx_bind_address=1;
22
23 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
24 SET @@GLOBAL.Mysqlx_bind_address="1.0.1.0";
25
26 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
27 SELECT COUNT(@@local.Mysqlx_bind_address);
28
29 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
30 SELECT COUNT(@@SESSION.Mysqlx_bind_address);
31
32 --let $assert_text= Mysqlx_bind_address global variable must is read-only, should hold to *
33 --let $assert_cond= [SELECT @@GLOBAL.Mysqlx_bind_address = "*" as Result;, Result, 1] =1
34 --source include/assert.inc
35
36
37 --echo #
38 --echo #
39 --echo # X Plugin started with ::
40 --echo #
41 --echo #
42 --let $restart_parameters = restart: --loose-mysqlx-bind-address=::
43 --source include/restart_mysqld.inc
44
45 --let $assert_text= Mysqlx_bind_address global variablem must exist
46 --let $assert_cond= [SELECT COUNT(@@GLOBAL.Mysqlx_bind_address) as Result;, Result, 1] =1
47 --source include/assert.inc
48
49 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
50 SET @@GLOBAL.Mysqlx_bind_address=1;
51
52 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
53 SET @@GLOBAL.Mysqlx_bind_address="1.0.1.0";
54
55 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
56 SELECT COUNT(@@local.Mysqlx_bind_address);
57
58 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
59 SELECT COUNT(@@SESSION.Mysqlx_bind_address);
60
61 --let $assert_text= Mysqlx_bind_address global variable must is read-only, should hold to ::
62 --let $assert_cond= [SELECT @@GLOBAL.Mysqlx_bind_address = "::" as Result;, Result, 1] =1
63 --source include/assert.inc
64
65 ## Cleanup
66 --let $restart_parameters = restart:
67 --source include/restart_mysqld.inc