Debian Codegraph @

mysql-test/suite/federated/t/federated_connection_attrs.test

raw
1 --source suite/federated/include/federated.inc
2
3 --echo #
4 --echo # Bug #16555730: FEDERATED SHOULD DEFINE CONNECTION ATTRIBUTES
5 --echo # TO IDENTIFY ITSELF
6 --echo #
7
8 connection slave;
9 CREATE TABLE federated.t1 (a int, b int) DEFAULT CHARSET=latin1;
10 INSERT INTO federated.t1 VALUES (1,1),(2,2);
11
12 connection master;
13 --replace_result $SLAVE_MYPORT SLAVE_PORT
14 eval CREATE TABLE federated.t1 (a int, b int)
15 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
16 CONNECTION='mysql://[email protected]:$SLAVE_MYPORT/federated/t1';
17
18 SELECT * FROM federated.t1 ORDER BY a;
19
20 connection slave;
21 --echo # must be non-zero
22 SELECT COUNT(*) FROM performance_schema.session_account_connect_attrs
23 WHERE ATTR_NAME='program_name' AND ATTR_VALUE='mysqld';
24
25 connection master;
26 DROP TABLE federated.t1;
27
28 connection slave;
29 DROP TABLE federated.t1;
30
31 connection default;
32
33 source suite/federated/include/federated_cleanup.inc;