Debian Codegraph @

mysql-test/suite/test_service_sql_api/r/test_sql_sleep_is_connected.result

raw
1 ------ Run plugin ------------------------------------------------
2 INSTALL PLUGIN test_sql_sleep_is_connected SONAME 'TEST_SQL_SLEEP_IS_CONNECTED';
3 ------ Stop plugin -----------------------------------------------
4 UNINSTALL PLUGIN test_sql_sleep_is_connected;
5 ------ plugin log ------------------------------------------------
6 =========================================================================
7 Opening Session
8 -------------------------------------------------------------------------
9 Test interaction between `sleep` and `is_connected`, in case when connection break at 1 call to is_connected
10 Execute: SELECT SLEEP(3600);
11 > sql_field_metadata: SLEEP(3600)
12 > sql_connection_alive => returns false
13 > sql_get_longlong
14 > sql_handle_ok
15 -------------------------------------------------------------------------
16 Test interaction between `sleep` and `is_connected`, in case when connection break at 2 call to is_connected
17 Execute: SELECT SLEEP(3600);
18 > sql_field_metadata: SLEEP(3600)
19 > sql_connection_alive => returns true
20 > sql_connection_alive => returns false
21 > sql_get_longlong
22 > sql_handle_ok
23 -------------------------------------------------------------------------
24 Test interaction between `sleep` and `is_connected`, in case when connection break at 4 call to is_connected
25 Execute: SELECT SLEEP(3600);
26 > sql_field_metadata: SLEEP(3600)
27 > sql_connection_alive => returns true
28 > sql_connection_alive => returns true
29 > sql_connection_alive => returns true
30 > sql_connection_alive => returns false
31 > sql_get_longlong
32 > sql_handle_ok
33 -------------------------------------------------------------------------
34 Test sleep and is_connected interactions, in case when connection never breaks
35 Execute: SELECT SLEEP(20);
36 > sql_field_metadata: SLEEP(20)
37 > sql_get_longlong
38 > sql_handle_ok
39 > is_connected was called several times.
40 =========================================================================
41 Close Session
42 ------ cleanup ---------------------------------------------------