summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/r/debug_dbug_func.result
blob: d0c002cf111e36a2ecf8665ccb5e8a1ceb1ee79b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
SET @old_debug = @@GLOBAL.debug_dbug;
SET debug_dbug= 'T';
select @@debug_dbug;
@@debug_dbug
T
SET debug_dbug= '+P';
select @@debug_dbug;
@@debug_dbug
P:T
SET debug_dbug= '-P';
select @@debug_dbug;
@@debug_dbug
T
SELECT @@session.debug_dbug, @@global.debug_dbug;
@@session.debug_dbug	@@global.debug_dbug
T	
SET SESSION debug_dbug= '';
SELECT @@session.debug_dbug, @@global.debug_dbug;
@@session.debug_dbug	@@global.debug_dbug
	
#
# Bug #52629: memory leak from sys_var_thd_dbug in 
#  binlog.binlog_write_error
#
SET GLOBAL debug_dbug='d,injecting_fault_writing';
SELECT @@global.debug_dbug;
@@global.debug_dbug
d,injecting_fault_writing
SET GLOBAL debug_dbug='';
SELECT @@global.debug_dbug;
@@global.debug_dbug

SET GLOBAL debug_dbug=@old_debug;
#
# Bug #56709: Memory leaks at running the 5.1 test suite
# 
SET @old_local_debug = @@debug_dbug;
SET @@debug_dbug='d,foo';
SELECT @@debug_dbug;
@@debug_dbug
d,foo
SET @@debug_dbug='';
SELECT @@debug_dbug;
@@debug_dbug

SET @@debug_dbug= @old_local_debug;
End of 5.1 tests
#
# Bug#46165 server crash in dbug
#
SET @old_globaldebug = @@global.debug_dbug;
SET @old_sessiondebug= @@session.debug_dbug;
# Test 1 - Bug test case, single connection
SET GLOBAL  debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.1.trace';
SET SESSION debug_dbug= '-d:-t:-i';
SET GLOBAL  debug_dbug= '';
SET SESSION debug_dbug= '';
# Test 2 - Bug test case, two connections
connection default;
SET GLOBAL  debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.2.trace';
SET SESSION debug_dbug= '-d:-t:-i';
connect  con1, localhost, root;
SET GLOBAL  debug_dbug= '';
connection default;
SET SESSION debug_dbug= '';
connection con1;
disconnect con1;
connection default;
SET GLOBAL  debug_dbug= '';
# Test 3 - Active session trace file on disconnect
connect  con1, localhost, root;
SET GLOBAL  debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.3.trace';
SELECT @@global.debug_dbug, @@session.debug_dbug;
@@global.debug_dbug	@@session.debug_dbug
O,MYSQL_TMP_DIR/bug46165.3.trace	O,MYSQL_TMP_DIR/bug46165.3.trace
SET SESSION debug_dbug= '+T';
SELECT @@global.debug_dbug, @@session.debug_dbug;
@@global.debug_dbug	@@session.debug_dbug
O,MYSQL_TMP_DIR/bug46165.3.trace	O,MYSQL_TMP_DIR/bug46165.3.trace:T
SET GLOBAL  debug_dbug= '';
SELECT @@global.debug_dbug, @@session.debug_dbug;
@@global.debug_dbug	@@session.debug_dbug
	O,MYSQL_TMP_DIR/bug46165.3.trace:T
disconnect con1;
# Test 4 - Active session trace file on two connections
connection default;
SET GLOBAL  debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.4.trace';
SET SESSION debug_dbug= '-d:-t:-i';
connect  con1, localhost, root;
SET SESSION debug_dbug= '-d:-t:-i';
SET GLOBAL  debug_dbug= '';
SET SESSION debug_dbug= '';
connection default;
SET SESSION debug_dbug= '';
connection con1;
disconnect con1;
connection default;
# Test 5 - Different trace files
SET SESSION debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.5.trace';
SET SESSION debug_dbug= '+O,MYSQL_TMP_DIR/bug46165.6.trace';
SET SESSION debug_dbug= '-O';
SET GLOBAL  debug_dbug= @old_globaldebug;
SET SESSION debug_dbug= @old_sessiondebug;