mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-03 20:36:16 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			45 lines
		
	
	
	
		
			1,012 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			45 lines
		
	
	
	
		
			1,012 B
		
	
	
	
		
			Text
		
	
	
	
	
	
--source include/not_embedded.inc
 | 
						|
 | 
						|
FLUSH STATUS;
 | 
						|
 | 
						|
--disable_result_log
 | 
						|
--disable_query_log
 | 
						|
--disable_service_connection
 | 
						|
 | 
						|
--disable_ps2_protocol
 | 
						|
let $i = 10;
 | 
						|
begin;
 | 
						|
while ($i)
 | 
						|
{
 | 
						|
  dec $i;
 | 
						|
  SELECT 1;
 | 
						|
}
 | 
						|
commit;
 | 
						|
--enable_ps2_protocol
 | 
						|
 | 
						|
--enable_query_log
 | 
						|
--enable_result_log
 | 
						|
 | 
						|
SHOW local STATUS LIKE 'com_select';
 | 
						|
 | 
						|
--reset_connection
 | 
						|
 | 
						|
SHOW local STATUS LIKE 'com_select';
 | 
						|
 | 
						|
--echo # Test if charset changes after reset (utf8)
 | 
						|
connect(utf8_conn,localhost,root,,,,,CHARSET=utf8);
 | 
						|
connection utf8_conn;
 | 
						|
SELECT IF(@@character_set_client='utf8mb3','OK', 'FAIL') AS RESULT;
 | 
						|
--reset_connection
 | 
						|
SELECT IF(@@character_set_client='utf8mb3','OK', 'FAIL') AS RESULT;
 | 
						|
disconnect utf8_conn;
 | 
						|
 | 
						|
--echo # Test if charset changes after reset (latin1)
 | 
						|
connect(latin1_conn,localhost,root,,,,,CHARSET=latin1);
 | 
						|
connection latin1_conn;
 | 
						|
SELECT IF(@@character_set_client='latin1','OK', 'FAIL') AS RESULT;
 | 
						|
--reset_connection
 | 
						|
SELECT IF(@@character_set_client='latin1','OK', 'FAIL') AS RESULT;
 | 
						|
disconnect latin1_conn;
 | 
						|
 | 
						|
--enable_service_connection
 |