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;