1SET @old_debug = @@GLOBAL.debug_dbug; 2SET debug_dbug= 'T'; 3select @@debug_dbug; 4@@debug_dbug 5T 6SET debug_dbug= '+P'; 7select @@debug_dbug; 8@@debug_dbug 9P:T 10SET debug_dbug= '-P'; 11select @@debug_dbug; 12@@debug_dbug 13T 14SELECT @@session.debug_dbug, @@global.debug_dbug; 15@@session.debug_dbug @@global.debug_dbug 16T 17SET SESSION debug_dbug= ''; 18SELECT @@session.debug_dbug, @@global.debug_dbug; 19@@session.debug_dbug @@global.debug_dbug 20 21# 22# Bug #52629: memory leak from sys_var_thd_dbug in 23# binlog.binlog_write_error 24# 25SET GLOBAL debug_dbug='d,injecting_fault_writing'; 26SELECT @@global.debug_dbug; 27@@global.debug_dbug 28d,injecting_fault_writing 29SET GLOBAL debug_dbug=''; 30SELECT @@global.debug_dbug; 31@@global.debug_dbug 32 33SET GLOBAL debug_dbug=@old_debug; 34# 35# Bug #56709: Memory leaks at running the 5.1 test suite 36# 37SET @old_local_debug = @@debug_dbug; 38SET @@debug_dbug='d,foo'; 39SELECT @@debug_dbug; 40@@debug_dbug 41d,foo 42SET @@debug_dbug=''; 43SELECT @@debug_dbug; 44@@debug_dbug 45 46SET @@debug_dbug= @old_local_debug; 47End of 5.1 tests 48# 49# Bug#46165 server crash in dbug 50# 51SET @old_globaldebug = @@global.debug_dbug; 52SET @old_sessiondebug= @@session.debug_dbug; 53# Test 1 - Bug test case, single connection 54SET GLOBAL debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.1.trace'; 55SET SESSION debug_dbug= '-d:-t:-i'; 56SET GLOBAL debug_dbug= ''; 57SET SESSION debug_dbug= ''; 58# Test 2 - Bug test case, two connections 59connection default; 60SET GLOBAL debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.2.trace'; 61SET SESSION debug_dbug= '-d:-t:-i'; 62connect con1, localhost, root; 63SET GLOBAL debug_dbug= ''; 64connection default; 65SET SESSION debug_dbug= ''; 66connection con1; 67disconnect con1; 68connection default; 69SET GLOBAL debug_dbug= ''; 70# Test 3 - Active session trace file on disconnect 71connect con1, localhost, root; 72SET GLOBAL debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.3.trace'; 73SELECT @@global.debug_dbug, @@session.debug_dbug; 74@@global.debug_dbug @@session.debug_dbug 75O,MYSQL_TMP_DIR/bug46165.3.trace O,MYSQL_TMP_DIR/bug46165.3.trace 76SET SESSION debug_dbug= '+T'; 77SELECT @@global.debug_dbug, @@session.debug_dbug; 78@@global.debug_dbug @@session.debug_dbug 79O,MYSQL_TMP_DIR/bug46165.3.trace O,MYSQL_TMP_DIR/bug46165.3.trace:T 80SET GLOBAL debug_dbug= ''; 81SELECT @@global.debug_dbug, @@session.debug_dbug; 82@@global.debug_dbug @@session.debug_dbug 83 O,MYSQL_TMP_DIR/bug46165.3.trace:T 84disconnect con1; 85# Test 4 - Active session trace file on two connections 86connection default; 87SET GLOBAL debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.4.trace'; 88SET SESSION debug_dbug= '-d:-t:-i'; 89connect con1, localhost, root; 90SET SESSION debug_dbug= '-d:-t:-i'; 91SET GLOBAL debug_dbug= ''; 92SET SESSION debug_dbug= ''; 93connection default; 94SET SESSION debug_dbug= ''; 95connection con1; 96disconnect con1; 97connection default; 98# Test 5 - Different trace files 99SET SESSION debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.5.trace'; 100SET SESSION debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.6.trace'; 101SET SESSION debug_dbug= '-O'; 102SET GLOBAL debug_dbug= @old_globaldebug; 103SET SESSION debug_dbug= @old_sessiondebug; 104