Debian Codegraph @

mysql-test/suite/perfschema/r/idx_compare_replication_connection_status.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 select THREAD_ID
11 into @worker_thread_id
12 from performance_schema.replication_connection_status
13 limit 1;
14 select NAME from performance_schema.threads
15 where THREAD_ID = @worker_thread_id;
16 NAME
17 thread/sql/replica_io
18
19 ## Create index_test() procedure
20 DROP PROCEDURE IF EXISTS index_test;
21 SET @pfs_columns = "CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE";
22 TABLE: "replication_connection_status"
23 INDEXES: PK (CHANNEL_NAME)
24
25 ===== BEGIN TEST =====
26 ========
27 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME is null
28
29 OK: Handler_read_key
30
31 OK: Result set: Empty Expected: Empty
32
33 OK: Extra rows: 0 Missing rows: 0
34 ========
35 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME is not null
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 CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME = ''
44
45 OK: Handler_read_key
46
47 OK: Result set: Non-empty Expected: Non-empty
48
49 OK: Extra rows: 0 Missing rows: 0
50 ========
51 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME != ''
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 CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME = 'impossible'
60
61 OK: Handler_read_key
62
63 OK: Result set: Empty Expected: Empty
64
65 OK: Extra rows: 0 Missing rows: 0
66 ========
67 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME != 'impossible' ORDER BY CHANNEL_NAME DESC
68
69 OK: Handler_read_key
70
71 OK: Result set: Non-empty Expected: Non-empty
72
73 OK: Extra rows: 0 Missing rows: 0
74 SET @target_id = @worker_thread_id;
75 TABLE: "replication_connection_status"
76 INDEXES: THREAD_ID
77
78 ===== BEGIN TEST =====
79 ========
80 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE THREAD_ID is null
81
82 OK: Handler_read_key
83
84 OK: Result set: Empty Expected: Empty
85
86 OK: Extra rows: 0 Missing rows: 0
87 ========
88 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE THREAD_ID is not null
89
90 OK: Handler_read_key
91
92 OK: Result set: Non-empty Expected: Non-empty
93
94 OK: Extra rows: 0 Missing rows: 0
95 ========
96 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE THREAD_ID = @target_id
97
98 OK: Handler_read_key
99
100 OK: Result set: Non-empty Expected: Non-empty
101
102 OK: Extra rows: 0 Missing rows: 0
103 ========
104 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE THREAD_ID = @target_id ORDER BY THREAD_ID
105
106 OK: Handler_read_key
107
108 OK: Result set: Non-empty Expected: Non-empty
109
110 OK: Extra rows: 0 Missing rows: 0
111 ========
112 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE THREAD_ID = @target_id ORDER BY THREAD_ID DESC
113
114 OK: Handler_read_key
115
116 OK: Result set: Non-empty Expected: Non-empty
117
118 OK: Extra rows: 0 Missing rows: 0
119 ========
120 SELECT CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE FROM performance_schema.replication_connection_status WHERE THREAD_ID = 9999999 ORDER BY THREAD_ID
121
122 OK: Handler_read_key
123
124 OK: Result set: Empty Expected: Empty
125
126 OK: Extra rows: 0 Missing rows: 0
127
128 ===== CLEAN UP =====
129 DROP PROCEDURE index_test;
130 DROP TABLE IF EXISTS test.indexes_off;
131 DROP TABLE IF EXISTS test.indexes_on;
132 include/stop_slave.inc
133 SET GLOBAL replica_parallel_workers= @old_replica_parallel_workers;
134 include/start_slave.inc
135 include/rpl_end.inc