Bug #23564 2 Connection options change for different windows user / Huge query text
Submitted: 24 Oct 2006 0:37 Modified: 22 Jan 2007 10:07
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.4/1.2.9 OS:Windows (WinXP/Vista)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: double quote, gravel, huge text, query browser

[24 Oct 2006 0:37] Jared S
Description:
Hi,

I have rencently deleted my windows account and re created my account.  Although I did not re-installe QB from GUI-TOOLS I have found 1 small bug where double clicking a table produce bad query text.

How to repeat:
1. Install Mysql from 1 windows account
   -create new DB mydb
   -create table called my-table

2. Create brand new windows user
3. Log onto brand new windows account
4. Run query browser
5. double click my-table from mydb to see the following text in query tab..

SELECT * FROM "my-table"

***this is wrong it should by more like***

SELECT * FROM `my-table`
[24 Oct 2006 18:57] MySQL Verification Team
Thank you for the bug report.
[5 Jan 2007 13:15] Mike Lischke
Jared, do you say that QB uses ANSI quotes for identifiers although you connected to the server without enabled ANSI quotes? Have you checked this in the connection dialog?
[8 Jan 2007 22:03] Jared S
Hi Mike, thanks for infomation, it appears you are correct, Query Browser is behaving correctly. i.e. QB loads with stupid connection options for different user.  So I guess the new bug is more like...

BUG: Why do connections options change when I am using another windows account like 'Administrator' if QB-TOOLS was installed on windows account 'Jared'?

 [X] Use compression protocol           (WRONG on non installed windows user)
 [X] Use ANSI quotes quote identifiers  (WRONG on non installed windows user)
 [ ] Use name pipe..                    (OK)

Let me know if you need new steps to reproduce.  Although it is only a matter of logging OFF 'Mike' windows account and logging onto 'new' or 'Administrator' windows account.
[9 Jan 2007 10:12] Mike Lischke
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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html
[22 Jan 2007 8:59] Jared S
Hi Mike, thanks for fixing the bugs, but another issue has now surface...

1. Install GUI-TOOLS 1.2.9
2. Create new windows account e.i. 'Duck' (I gave Administrator rights)
3. Logon to windows as Duck
4. Load Query Browser
5. Double clicked table (my table was `flat-beds`)

RESULT : The text that comes up in the F11 tab is freakin huge, like 16 point!
[22 Jan 2007 10:07] Mike Lischke
Jared, please, don't reuse old bugs for new reports.
[23 Jan 2007 1:00] MySQL Verification Team
See bug: http://bugs.mysql.com/bug.php?id=25766