Debian Codegraph @

mysql-test/suite/perfschema/r/idx_compare_replication_connection_configuration.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 include/stop_slave.inc
7 SET @old_replica_parallel_workers= @@global.replica_parallel_workers;
8 SET GLOBAL replica_parallel_workers= 4;
9 include/start_slave.inc
10
11 ## Create index_test() procedure
12 DROP PROCEDURE IF EXISTS index_test;
13 SET @pfs_columns = "*";
14 TABLE: "replication_connection_configuration"
15 INDEXES: PK (CHANNEL_NAME)
16
17 ===== BEGIN TEST =====
18 ========
19 SELECT * FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME is null
20
21 OK: Handler_read_key
22
23 OK: Result set: Empty Expected: Empty
24
25 OK: Extra rows: 0 Missing rows: 0
26 ========
27 SELECT * FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME is not null
28
29 OK: Handler_read_key
30
31 OK: Result set: Non-empty Expected: Non-empty
32
33 OK: Extra rows: 0 Missing rows: 0
34 ========
35 SELECT * FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME = ''
36
37 OK: Handler_read_key
38
39 OK: Result set: Non-empty Expected: Non-empty
40
41 OK: Extra rows: 0 Missing rows: 0
42 ========
43 SELECT * FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME != ''
44
45 OK: Handler_read_key
46
47 OK: Result set: Empty Expected: Empty
48
49 OK: Extra rows: 0 Missing rows: 0
50 ========
51 SELECT * FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME = 'impossible'
52
53 OK: Handler_read_key
54
55 OK: Result set: Empty Expected: Empty
56
57 OK: Extra rows: 0 Missing rows: 0
58 ========
59 SELECT * FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME != 'impossible' ORDER BY CHANNEL_NAME DESC
60
61 OK: Handler_read_key
62
63 OK: Result set: Non-empty Expected: Non-empty
64
65 OK: Extra rows: 0 Missing rows: 0
66
67 ===== CLEAN UP =====
68 DROP PROCEDURE index_test;
69 DROP TABLE IF EXISTS test.indexes_off;
70 DROP TABLE IF EXISTS test.indexes_on;
71 include/stop_slave.inc
72 SET GLOBAL replica_parallel_workers= @old_replica_parallel_workers;
73 include/start_slave.inc
74 include/rpl_end.inc