Debian Codegraph @

mysql-test/suite/sys_vars/r/debug_dbug_func.result

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