diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/connection_3a.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/connection_3a.result | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/connection_3a.result b/mysql-test/suite/perfschema/r/connection_3a.result index 1f92d67137d..e799864edfd 100644 --- a/mysql-test/suite/perfschema/r/connection_3a.result +++ b/mysql-test/suite/perfschema/r/connection_3a.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 @@ -94,6 +98,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 1 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con2b, localhost, user2, , ; select "user2 in con2b" as status; status user2 in con2b @@ -118,6 +123,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 2 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con2c, localhost, user2, , ; select "user2 in con2c" as status; status user2 in con2c @@ -143,6 +149,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 3 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con3a, localhost, user3, , ; select "user3 in con3a" as status; status user3 in con3a @@ -170,6 +177,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 4 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con3b, localhost, user3, , ; select "user3 in con3b" as status; status user3 in con3b @@ -198,6 +206,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 5 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con3c, localhost, user3, , ; select "user3 in con3c" as status; status user3 in con3c @@ -227,6 +236,8 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connection default; +disconnect con1a; select "con1a disconnected" as status; status con1a disconnected @@ -255,6 +266,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con2a; select "con2a disconnected" as status; status con2a disconnected @@ -282,6 +294,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con3a; select "con3a disconnected" as status; status con3a disconnected @@ -380,6 +393,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con4a, localhost, user4, , ; select "user4 in con4a" as status; status user4 in con4a @@ -408,6 +422,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 7 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con4b, localhost, user4, , ; select "user4 in con4b" as status; status user4 in con4b @@ -437,6 +452,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 8 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con4c, localhost, user4, , ; select "user4 in con4c" as status; status user4 in con4c @@ -467,6 +483,8 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connection default; +disconnect con1b; select "con1b disconnected" as status; status con1b disconnected @@ -496,6 +514,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con2b; select "con2b disconnected" as status; status con2b disconnected @@ -524,6 +543,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con3b; select "con3b disconnected" as status; status con3b disconnected @@ -551,6 +571,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con1c; select "con1c disconnected" as status; status con1c disconnected @@ -577,6 +598,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con2c; select "con2c disconnected" as status; status con2c disconnected @@ -602,6 +624,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +disconnect con3c; select "con3c disconnected" as status; status con3c disconnected @@ -683,6 +706,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con5a, localhost, user5, , ; select "user5 in con5a" as status; status user5 in con5a @@ -706,6 +730,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con5b, localhost, user5, , ; select "user5 in con5b" as status; status user5 in con5b @@ -730,6 +755,7 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 +connect con5c, localhost, user5, , ; select "user5 in con5c" as status; status user5 in con5c @@ -755,6 +781,13 @@ variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 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 |