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