1## Preamle 2--source ../include/xplugin_preamble.inc 3 4## Test case 5 6# Please update the test case when the variable count changes 7# add/remove variable 8let $wait_condition= 9 SELECT COUNT(*)=60 FROM performance_schema.global_status where variable_name like "Mysqlx_%"; 10--source include/wait_condition_or_abort.inc 11 12# Values for variables that were overwritten by MTR 13--let $mtr_overwrited_port= $MASTER_X_MYPORT 14--let $mtr_overwrited_socket= $MASTER_X_MYSOCK 15 16if (`SELECT CONVERT(@@version_compile_os using latin1) IN ("Win32","Win64","Windows")`) 17{ 18 --let $mtr_overwrited_socket= UNDEFINED 19} 20 21 22## Verify default value of system variables 23--let $assert_text= Mysqlx_port must match value set by MTR 24--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_port", Value, 1] = $mtr_overwrited_port 25--source include/assert.inc 26 27--let $assert_text= No connections were made, Mysqlx_stmt_execute_sql must match default value which is 0. 28--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_execute_sql", Value, 1] = 0 29--source include/assert.inc 30 31--let $assert_text= No connections were made, Mysqlx_stmt_execute_xplugin must match default value which is 0. 32--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_execute_xplugin", Value, 1] = 0 33--source include/assert.inc 34 35--let $assert_text= No connections were made, Mysqlx_stmt_execute_mysqlx must match default value which is 0. 36--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_execute_mysqlx", Value, 1] = 0 37--source include/assert.inc 38 39--let $assert_text= No connections were made, Mysqlx_crud_update must match default value which is 0. 40--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_update", Value, 1] = 0 41--source include/assert.inc 42 43--let $assert_text= No connections were made, Mysqlx_crud_update must match default value which is 0. 44--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_update", Value, 1] = 0 45--source include/assert.inc 46 47--let $assert_text= No connections were made, Mysqlx_crud_delete must match default value which is 0. 48--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_delete", Value, 1] = 0 49--source include/assert.inc 50 51--let $assert_text= No connections were made, Mysqlx_crud_find must match default value which is 0. 52--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_find", Value, 1] = 0 53--source include/assert.inc 54 55--let $assert_text= No connections were made, Mysqlx_crud_insert must match default value which is 0. 56--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_insert", Value, 1] = 0 57--source include/assert.inc 58 59--let $assert_text= No connections were made, Mysqlx_crud_create_view must match default value which is 0. 60--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_create_view", Value, 1] = 0 61--source include/assert.inc 62 63--let $assert_text= No connections were made, Mysqlx_crud_modify_view must match default value which is 0. 64--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_modify_view", Value, 1] = 0 65--source include/assert.inc 66 67--let $assert_text= No connections were made, Mysqlx_crud_drop_view must match default value which is 0. 68--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_crud_drop_view", Value, 1] = 0 69--source include/assert.inc 70 71--let $assert_text= No connections were made, Mysqlx_expect_open must match default value which is 0. 72--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_expect_open", Value, 1] = 0 73--source include/assert.inc 74 75--let $assert_text= No connections were made, Mysqlx_expect_close must match default value which is 0. 76--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_expect_close", Value, 1] = 0 77--source include/assert.inc 78 79--let $assert_text= No connections were made, Mysqlx_stmt_create_collection must match default value which is 0. 80--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_create_collection", Value, 1] = 0 81--source include/assert.inc 82 83--let $assert_text= No connections were made, Mysqlx_stmt_create_collection_index must match default value which is 0. 84--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_create_collection_index", Value, 1] = 0 85--source include/assert.inc 86 87--let $assert_text= No connections were made, Mysqlx_stmt_drop_collection must match default value which is 0. 88--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_drop_collection", Value, 1] = 0 89--source include/assert.inc 90 91--let $assert_text= No connections were made, Mysqlx_stmt_ensure_collection must match default value which is 0. 92--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_ensure_collection", Value, 1] = 0 93--source include/assert.inc 94 95--let $assert_text= No connections were made, Mysqlx_stmt_drop_collection_index must match default value which is 0. 96--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_drop_collection_index", Value, 1] = 0 97--source include/assert.inc 98 99--let $assert_text= No connections were made, Mysqlx_stmt_list_objects must match default value which is 0. 100--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_list_objects", Value, 1] = 0 101--source include/assert.inc 102 103--let $assert_text= No connections were made, Mysqlx_stmt_enable_notices must match default value which is 0. 104--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_enable_notices", Value, 1] = 0 105--source include/assert.inc 106 107--let $assert_text= No connections were made, Mysqlx_stmt_disable_notices must match default value which is 0. 108--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_disable_notices", Value, 1] = 0 109--source include/assert.inc 110 111--let $assert_text= No connections were made, Mysqlx_stmt_list_notices must match default value which is 0. 112--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_list_notices", Value, 1] = 0 113--source include/assert.inc 114 115--let $assert_text= No connections were made, Mysqlx_stmt_list_clients must match default value which is 0. 116--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_list_clients", Value, 1] = 0 117--source include/assert.inc 118 119--let $assert_text= No connections were made, Mysqlx_stmt_kill_client must match default value which is 0. 120--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_kill_client", Value, 1] = 0 121--source include/assert.inc 122 123--let $assert_text= No connections were made, Mysqlx_stmt_ping must match default value which is 0. 124--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_stmt_ping", Value, 1] = 0 125--source include/assert.inc 126 127--let $assert_text= No connections were made, Mysqlx_bytes_sent must match default value which is 0. 128--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_bytes_sent", Value, 1] = 0 129--source include/assert.inc 130 131--let $assert_text= No connections were made, Mysqlx_bytes_received must match default value which is 0. 132--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_bytes_received", Value, 1] = 0 133--source include/assert.inc 134 135--let $assert_text= No connections were made, Mysqlx_errors_sent must match default value which is 0. 136--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_errors_sent", Value, 1] = 0 137--source include/assert.inc 138 139--let $assert_text= No connections were made, Mysqlx_errors_unknown_message_type must match default value which is 0. 140--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_errors_unknown_message_type", Value, 1] = 0 141--source include/assert.inc 142 143--let $assert_text= No connections were made, Mysqlx_rows_sent must match default value which is 0. 144--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_rows_sent", Value, 1] = 0 145--source include/assert.inc 146 147--let $assert_text= No connections were made, Mysqlx_notice_warning_sent must match default value which is 0. 148--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_notice_warning_sent", Value, 1] = 0 149--source include/assert.inc 150 151--let $assert_text= No connections were made, Mysqlx_notice_other_sent must match default value which is 0. 152--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_notice_other_sent", Value, 1] = 0 153--source include/assert.inc 154 155--let $assert_text= No connections were made, Mysqlx_sessions must match default value which is 0. 156--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions", Value, 1] = 0 157--source include/assert.inc 158 159--let $assert_text= No connections were made, Mysqlx_sessions_closed must match default value which is 0. 160--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_closed", Value, 1] = 0 161--source include/assert.inc 162 163--let $assert_text= No connections were made, Mysqlx_sessions_fatal_error must match default value which is 0. 164--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_fatal_error", Value, 1] = 0 165--source include/assert.inc 166 167--let $assert_text= No init error occurred, Mysqlx_init_error must match default value which is 0. 168--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_init_error", Value, 1] = 0 169--source include/assert.inc 170 171--let $assert_text= No connections were made, Mysqlx_sessions_accepted must match default value which is 0. 172--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_accepted", Value, 1] = 0 173--source include/assert.inc 174 175--let $assert_text= No connections were made, Mysqlx_sessions_rejected must match default value which is 0. 176--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_rejected", Value, 1] = 0 177--source include/assert.inc 178 179--let $assert_text= No connections were made, Mysqlx_sessions_killed must match default value which is 0. 180--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_sessions_killed", Value, 1] = 0 181--source include/assert.inc 182 183--let $assert_text= No connections were made, Mysqlx_connections_closed must match default value which is 0. 184--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connections_closed", Value, 1] = 0 185--source include/assert.inc 186 187--let $assert_text= No connections were made, Mysqlx_connections_accepted must match default value which is 0. 188--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connections_accepted", Value, 1] = 0 189--source include/assert.inc 190 191--let $assert_text= No connections were made, Mysqlx_connections_rejected must match default value which is 0. 192--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connections_rejected", Value, 1] = 0 193--source include/assert.inc 194 195--let $assert_text= No accept errors were triggered, Mysqlx_connection_accept_errors must match default value which is 0. 196--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connection_accept_errors", Value, 1] = 0 197--source include/assert.inc 198 199--let $assert_text= No connections errors were simulated, Mysqlx_connection_errors must match default value which is 0. 200--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_connection_errors", Value, 1] = 0 201--source include/assert.inc 202 203--let $assert_text= XPlugin run two threads in default, Mysqlx_worker_threads should be set to 2. 204--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_worker_threads", Value, 1] = 2 205--source include/assert.inc 206 207--let $assert_text= Mysqlx_worker_threads_active must match default value which is 0. 208--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_worker_threads_active", Value, 1] = 0 209--source include/assert.inc 210 211--let $assert_text= Mysqlx_socket must match value set by MTR or UNDEFINED on windows 212--let $assert_cond= [select VARIABLE_VALUE="$mtr_overwrited_socket" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_socket", Value, 1] = 1 213--source include/assert.inc 214 215--let $assert_text= SSL not configured, Mysqlx_ssl_active should be empty 216--let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_active", Value, 1] = 1 217--source include/assert.inc 218 219--let $assert_text= SSL not configured, Mysqlx_ssl_cipher_list should be empty 220--let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_cipher_list", Value, 1] = 1 221--source include/assert.inc 222 223--let $assert_text= SSL not configured, Mysqlx_ssl_cipher should be empty 224--let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_cipher", Value, 1] = 1 225--source include/assert.inc 226 227--let $assert_text= SSL not configured, Mysqlx_ssl_version should be empty 228--let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_version", Value, 1] = 1 229--source include/assert.inc 230 231--let $assert_text= SSL not configured, Mysqlx_ssl_verify_depth should be empty 232--let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_verify_depth", Value, 1] = 1 233--source include/assert.inc 234 235--let $assert_text= SSL not configured, Mysqlx_ssl_verify_mode should be empty 236--let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_verify_mode", Value, 1] = 1 237--source include/assert.inc 238 239--let $assert_text= Mysqlx_ssl_ctx_verify_depth must match default value which is 0. 240--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_ssl_ctx_verify_depth", Value, 1] = 0 241--source include/assert.inc 242 243--let $assert_text= Mysqlx_ssl_ctx_verify_mode must match default value which is 0. 244--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_ssl_ctx_verify_mode", Value, 1] = 0 245--source include/assert.inc 246 247--let $assert_text= No connections were made, Mysqlx_ssl_finished_accepts must match default value which is 0. 248--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_ssl_finished_accepts", Value, 1] = 0 249--source include/assert.inc 250 251--let $assert_text= No connections were made, Mysqlx_ssl_accepts must match default value which is 0. 252--let $assert_cond= [SHOW STATUS LIKE "Mysqlx_ssl_accepts", Value, 1] = 0 253--source include/assert.inc 254 255--let $assert_text= Mysqlx_ssl_server_not_after should be empty 256--let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_server_not_after", Value, 1] = 1 257--source include/assert.inc 258 259--let $assert_text= Mysqlx_ssl_active should be empty 260--let $assert_cond= [select VARIABLE_VALUE="" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_ssl_server_not_before", Value, 1] = 1 261--source include/assert.inc 262 263--let $assert_text= Mysqlx_address must match default value which is "::" 264--let $assert_cond= [select VARIABLE_VALUE="::" as Value from performance_schema.global_status WHERE VARIABLE_NAME like "Mysqlx_address", Value, 1] = 1 265--source include/assert.inc 266 267## Postamble 268uninstall plugin mysqlx; 269