At 2:44 PM +0400 11/13/07, Alexey Botchkov wrote:
>> Can you please point me at the manual page where SET
>>...=default is explained?
>Unfortunately no.
>I just saw this trick used in tests with other system variables.
http://dev.mysql.com/doc/refman/5.0/en/set-option.html says:
"To set a SESSION variable to the GLOBAL value or
a GLOBAL value to the compiled-in MySQL default
value, use the DEFAULT keyword. For example, the
following two statements are identical in setting
the session value of max_join_size to the global
value:
SET max_join_size=DEFAULT;
SET @@session.max_join_size=@@global.max_join_size;
Not all system variables can be set to DEFAULT.
In such cases, use of DEFAULT results in an
error."
>
>Regards
>HF
>
>
>
>----- Original Message ----- From: "Ingo Strüwing" <ingo@stripped>
>To: "Alexey Botchkov" <holyfoot@stripped>
>Cc: <commits@stripped>
>Sent: Monday, November 12, 2007 6:24 PM
>Subject: Re: bk commit into 4.1 tree (holyfoot:1.2688) BUG#31305
>
>>Hello Alexey,
>>
>>Alexey Botchkov, 12.11.2007 10:07:
>>...
>>>--disable_query_log added
>>
>>Great idea! Another idea would be to have one INSERT before the loop
>>(for the result file) and then "--echo # repeating the above 302 times."
>>
>>...
>>>Previous statement was INSERT, and we needed bigger record
>>>size for UPDATE to make table full as it uses the old record's
>>>space as well.
>>
>>Oh yes. I missed that the second was an update. Sorry.
>>
>>...
>>>No need to store in fact - just 'default' value used.
>>
>>Interesting. I didn't know that this is possible. I didn't find it in
>>the manual. Can you please point me at the manual page where SET
>>...=default is explained?
>>
>>>
>>>As i didn't modify the code, i assume 'ok to push' from you,
>>
>>Yes. It is.
>>
>>>though you welcome to take a look at the last patch,
>>
>>I did. Good work.
>>
>>Regards
>>Ingo
>>--
>>Ingo Strüwing, Senior Software Developer
>>MySQL GmbH, Dachauer Str. 37, D-80335 München
>>Geschäftsführer: Kaj Arnö - HRB München 162140
>>
>
>
>--
>MySQL Code Commits Mailing List
>For list archives: http://lists.mysql.com/commits
>To unsubscribe: http://lists.mysql.com/commits?unsub=1
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
