diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/connection.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/connection.result | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/connection.result b/mysql-test/suite/perfschema/r/connection.result index fe312f6fa04..332b5a43466 100644 --- a/mysql-test/suite/perfschema/r/connection.result +++ b/mysql-test/suite/perfschema/r/connection.result @@ -11,6 +11,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con1a, localhost, user1, , ; select "user1 in con1a" as status; status user1 in con1a @@ -30,6 +31,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con1b, localhost, user1, , ; select "user1 in con1b" as status; status user1 in con1b @@ -50,6 +52,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con1c, localhost, user1, , ; select "user1 in con1c" as status; status user1 in con1c @@ -71,6 +74,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con2a, localhost, user2, , ; select "user2 in con2a" as status; status user2 in con2a @@ -95,6 +99,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con2b, localhost, user2, , ; select "user2 in con2b" as status; status user2 in con2b @@ -120,6 +125,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con2c, localhost, user2, , ; select "user2 in con2c" as status; status user2 in con2c @@ -146,6 +152,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con3a, localhost, user3, , ; select "user3 in con3a" as status; status user3 in con3a @@ -175,6 +182,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con3b, localhost, user3, , ; select "user3 in con3b" as status; status user3 in con3b @@ -205,6 +213,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con3c, localhost, user3, , ; select "user3 in con3c" as status; status user3 in con3c @@ -236,6 +245,8 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connection default; +disconnect con1a; select "con1a disconnected" as status; status con1a disconnected @@ -266,6 +277,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con2a; select "con2a disconnected" as status; status con2a disconnected @@ -295,6 +307,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con3a; select "con3a disconnected" as status; status con3a disconnected @@ -401,6 +414,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con4a, localhost, user4, , ; select "user4 in con4a" as status; status user4 in con4a @@ -432,6 +446,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con4b, localhost, user4, , ; select "user4 in con4b" as status; status user4 in con4b @@ -464,6 +479,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con4c, localhost, user4, , ; select "user4 in con4c" as status; status user4 in con4c @@ -497,6 +513,8 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connection default; +disconnect con1b; select "con1b disconnected" as status; status con1b disconnected @@ -529,6 +547,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con2b; select "con2b disconnected" as status; status con2b disconnected @@ -560,6 +579,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con3b; select "con3b disconnected" as status; status con3b disconnected @@ -590,6 +610,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con1c; select "con1c disconnected" as status; status con1c disconnected @@ -619,6 +640,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con2c; select "con2c disconnected" as status; status con2c disconnected @@ -647,6 +669,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con3c; select "con3c disconnected" as status; status con3c disconnected @@ -734,6 +757,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con5a, localhost, user5, , ; select "user5 in con5a" as status; status user5 in con5a @@ -758,6 +782,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con5b, localhost, user5, , ; select "user5 in con5b" as status; status user5 in con5b @@ -783,6 +808,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con5c, localhost, user5, , ; select "user5 in con5c" as status; status user5 in con5c @@ -809,6 +835,13 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connection default; +disconnect con4a; +disconnect con4b; +disconnect con4c; +disconnect con5a; +disconnect con5b; +disconnect con5c; select "con 5a, 5b, 5c, 6a, 6b, 6c disconnected" as status; status con 5a, 5b, 5c, 6a, 6b, 6c disconnected |