MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Ingo Strüwing Date:April 9 2009 3:11pm
Subject:Re: bzr commit into mysql-6.0-backup branch (ingo.struewing:2810)
Bug#44068
View as plain text  
Hi Guilhem,

Guilhem Bichot, 08.04.2009 13:16:

...
> A next attempt is to have this kind of logic in the test:
> 
> if session.debug already contains "d:":
>    SET debug='+d:+d,key_cache_write_block_error';
> else:
>    SET debug=+d,key_cache_write_block_error';
> ?
> 
>> It doesn't work, because an empty list of keywords means all keywords.
>> When adding a single keyword, the list is no longer empty, hence the
>> logic changes to suppress all keywords, but the given one.
> 
> But the d: above avoids that, normally.
> 
>> The effect is not that obvious if the 't' (trace) option is also active.
>> It isn't influenced by the debug keyword list. One needs to look twice
>> to see that the debug output is missing between the trace output. I use
>> to grep for "query:". So I see the +d,keyword statement and next is the
>> statement behind the -d,keyword statement. Thus, the debug output is
>> suppressed in between.
> 
> Yes, but with d: I don't have this problem in my tests.

It didn't work for me, and I am pretty sure, it cannot work. When you do
further experiments, please have SELECT @@debug; before and after
setting the debug variable. It should show, what's going on.

BTW, working on another bug, I noticed that +d,keyword followed by
-d,keyword leaves full debugging enabled (with an empty keyword list).
When run without --debug, the debug output ends up in the error log. It
seems there is no way around resetting the debug variable from a value
saved at test case start.

let $debug= `SELECT @@debug`;
...
--echo # Reset debug variable to its original value.
--disable_query_log
eval SET debug= '$debug';
--enable_query_log

Regards
Ingo
-- 
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder, Wolfgang Engels, Dr. Roland Bömer
Vorsitzender des Aufsichtsrates: Martin Häring   HRB München 161028
Thread
bzr commit into mysql-6.0-backup branch (ingo.struewing:2810) Bug#44068Ingo Struewing7 Apr
  • Re: bzr commit into mysql-6.0-backup branch (ingo.struewing:2810)Bug#44068Guilhem Bichot7 Apr
    • Re: bzr commit into mysql-6.0-backup branch (ingo.struewing:2810)Bug#44068Ingo Strüwing8 Apr
      • Re: bzr commit into mysql-6.0-backup branch (ingo.struewing:2810)Bug#44068Guilhem Bichot8 Apr
        • Re: bzr commit into mysql-6.0-backup branch (ingo.struewing:2810)Bug#44068Ingo Strüwing8 Apr
          • Re: bzr commit into mysql-6.0-backup branch (ingo.struewing:2810)Bug#44068Guilhem Bichot8 Apr
            • Re: bzr commit into mysql-6.0-backup branch (ingo.struewing:2810)Bug#44068Ingo Strüwing9 Apr