Debian Codegraph @

mysql-test/suite/galera/r/galera_server.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 # On node_1
5 CREATE SERVER s1
6 FOREIGN DATA WRAPPER mysql
7 OPTIONS (HOST 'foo');
8 connection node_2;
9 # On node_2
10 SELECT * FROM mysql.servers;
11 Server_name Host Db Username Password Port Socket Wrapper Owner Options
12 s1 foo 3306 mysql {"HOST": "foo"}
13 ALTER SERVER s1
14 OPTIONS (HOST 'bar');
15 connection node_1;
16 # On node_1
17 SELECT * FROM mysql.servers;
18 Server_name Host Db Username Password Port Socket Wrapper Owner Options
19 s1 bar 3306 mysql {"HOST": "bar"}
20 DROP SERVER s1;
21 connection node_2;
22 # On node_2
23 SELECT COUNT(*)=0 FROM mysql.servers;
24 COUNT(*)=0
25 1
26 disconnect node_2;
27 disconnect node_1;
28 # End of test