Bug #10688 Unable to show result of variable selection
Submitted: 17 May 2005 14:06 Modified: 17 May 2005 21:49
Reporter: [ name withheld ] (Basic Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.9 OS:Windows (Windows 2000 sp4)
Assigned to: CPU Architecture:Any

[17 May 2005 14:06] [ name withheld ] 
Description:
The MySQL Query Borwser is unable to show the result of a:
SELECT @@sql_mode;
It just displays a grey cell in the result panel.
The query gets executed and the time elapsed is showed at bottom left

How to repeat:
Run:
SELECT @@sql_mode;
[17 May 2005 21:49] Hartmut Holzgraefe 
Query Browser always resets the sql_mode if the server is >= 4.1

This itself may be questionable but the query result itself is displayed correctly as sql_mode is now empty
[18 May 2005 7:45] [ name withheld ] 
>Query Browser always resets the sql_mode if the server is >= 4.1

I don't understand, this is a server setting that can modify SQL syntax and server behaviour, there is no point in having a client tool reset it.
I believe this is an incorrect behaviour.
Regards