1--source include/not_embedded.inc
2
3FLUSH STATUS;
4
5--disable_result_log
6--disable_query_log
7
8let $i = 10;
9begin;
10while ($i)
11{
12  dec $i;
13  SELECT 1;
14}
15commit;
16
17--enable_query_log
18--enable_result_log
19
20SHOW local STATUS LIKE 'com_select';
21
22--reset_connection
23
24SHOW local STATUS LIKE 'com_select';
25
26--echo # Test if charset changes after reset (utf8)
27connect(utf8_conn,localhost,root,,,,,CHARSET=utf8);
28connection utf8_conn;
29SELECT IF(@@character_set_client='utf8','OK', 'FAIL') AS RESULT;
30--reset_connection
31SELECT IF(@@character_set_client='utf8','OK', 'FAIL') AS RESULT;
32disconnect utf8_conn;
33
34--echo # Test if charset changes after reset (latin1)
35connect(latin1_conn,localhost,root,,,,,CHARSET=latin1);
36connection latin1_conn;
37SELECT IF(@@character_set_client='latin1','OK', 'FAIL') AS RESULT;
38--reset_connection
39SELECT IF(@@character_set_client='latin1','OK', 'FAIL') AS RESULT;
40disconnect latin1_conn;