Debian Codegraph @

mysql-test/suite/federated/r/federated_connection_attrs.result

raw
1 CREATE DATABASE federated;
2 CREATE DATABASE federated;
3 #
4 # Bug #16555730: FEDERATED SHOULD DEFINE CONNECTION ATTRIBUTES
5 # TO IDENTIFY ITSELF
6 #
7 CREATE TABLE federated.t1 (a int, b int) DEFAULT CHARSET=latin1;
8 INSERT INTO federated.t1 VALUES (1,1),(2,2);
9 CREATE TABLE federated.t1 (a int, b int)
10 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
11 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
12 SELECT * FROM federated.t1 ORDER BY a;
13 a b
14 1 1
15 2 2
16 # must be non-zero
17 SELECT COUNT(*) FROM performance_schema.session_account_connect_attrs
18 WHERE ATTR_NAME='program_name' AND ATTR_VALUE='mysqld';
19 COUNT(*)
20 1
21 DROP TABLE federated.t1;
22 DROP TABLE federated.t1;
23 DROP TABLE IF EXISTS federated.t1;
24 DROP DATABASE federated;
25 DROP TABLE IF EXISTS federated.t1;
26 DROP DATABASE federated;