Bug #10603 QB clears sql_mode on connect
Submitted: 12 May 2005 16:51 Modified: 13 Jul 2005 15:12
Reporter: Dean Ellis Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version: OS:
Assigned to: Alfredo Kojima CPU Architecture:Any

[12 May 2005 16:51] Dean Ellis 
Description:
Query Browser (silently?) clears SQL_MODE upon connection.  As this can significantly alter server behavior, particularly against MySQL 5.0, this is dangerous.

How to repeat:
SET GLOBAL sql_mode = 'ANSI_QUOTES'

execute

SHOW SESSION VARIABLES LIKE 'sql_mode'

execute

Suggested fix:
Do not clear sql_mode!
[19 May 2005 13:10] Michael G. Zinner 

 

 

  

   [13 Jul 2005 15:12]
   Alfredo Kojima        

  
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

 

 

  

   [11 Jun 2012 15:23]
   Martin Leboeuf        

  
I am using 5.1 trunk (5.1.40) and have the problem. So them may be something more to it.

 

 

  

   [11 Jun 2012 15:27]
   Martin Leboeuf        

  
sorry, wrong bug for posting. Apologies.