MySQL Bugs: #25072: schema in tree stays on "Fetching data..." when lacking "show tables" privilege

Bug #25072	schema in tree stays on "Fetching data..." when lacking "show tables" privilege
Submitted:	14 Dec 2006 13:07	Modified:	22 Jan 2007 10:11
Reporter:	Yahoo Serious (Silver Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.8	OS:	Windows (Windows 2000 SP4)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
When clicking a schema in the schemata tree(?), it show "Fetching data...".  
If I have no permissions  to view the contents of this schema (the table list) I  get an error.  
NB: this only happens for MySqlServer 4.1.21 (5.0.27 seems to have a bug for privileges for SHOW TABLES: Bug #25071)

However the schemata tree still shows "Fetching data...".  I think this should be changed to "Could not fetch data" (or use some fancy icon implying the latter).

Besides, the last sentence of the error message is obscure: "A MySQL error was encountered.  The message is:  Could not fetch schema tables.  The following error occurred: (0)".  I think the message should at least mention the schema involved.
That may be a MySqlServer error though.

How to repeat:
- set up a db which is forbidden for a certain user
- open QB as that user
- click on the unfold-arrow next to that db in Schemata
- notice the obscure text in the error message 
- click ok on the error message 
- notice the unfolded db in Schemata, with a daughter stating "Fetching data..."

Suggested fix:
- fix unfolding: change text or fold it 
- fix error sentence
- check for 5

(Corrected ill synopsis - what was I pasting?)

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

screenshot

Attachment: bug25072.jpg (image/jpeg, text), 51.63 KiB.

Thank you for the additional comment.

I see correct error message now: "....Access denied for....", but still see "Fetching data..." message in the Schemata tab. This message is not expiring even if I close error dialog.

I attached screenshot of this behaviour. Is it same picture you see?

Yes,
One part of the bug is fixed:
- the error message is correct
But one part still remains:
- the "Fetching data..." still does not expire

Thank you for the feedback.

Marked as verified.

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