Bug #9793 SHOW COLLATION w/ 4.1.11 server returns empty resultset

• Submitted: 10 Apr 2005 16:29
• Modified: 12 Apr 2005 16:37
• Reporter: spaze
• Status: Not a Bug
• Category: MySQL Query Browser
• Severity: S1 (Critical)
• Version: 1.1.6
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any

[10 Apr 2005 16:29] spaze

Description:
When connected to 4.1.11 server (running on WXP), Query Browser returns "Query returned no resultset." when SHOW COLLATION; command is issued. In Commandline client (from the 4.1.11 distribution and from the 4.0.24 also) everything is OK:

mysql> SHOW COLLATION;
+----------------------+----------+-----+---------+----------+---------+
| Collation            | Charset  | Id  | Default | Compiled | Sortlen |
+----------------------+----------+-----+---------+----------+---------+
| big5_chinese_ci      | big5     |   1 | Yes     | Yes      |       1 |
| big5_bin             | big5     |  84 |         | Yes      |       1 |
...

How to repeat:
Start QB, connect to 4.1.11 server, issue SHOW COLLATION. You can see the column names will appear for a half-second and then will disappear and the "Query returned no resultset" appears at the bottom of the screen.

[10 Apr 2005 16:43] spaze

Open -> Not a bug, restart of QB magically fixed my problem. Sorry for bothering.