MySQL Bugs: #38680: Results of HELP queries are not shown

Bug #38680	Results of HELP queries are not shown
Submitted:	8 Aug 2008 20:16	Modified:	14 May 2009 12:35
Reporter:	Federico Razzoli (OCA)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	Linux (Ubuntu 8.04, Windows)
Assigned to:		CPU Architecture:	Any

Description:
Results of HELP queries are not shown in the Query tabs.

How to repeat:
Execute:
HELP 'select'

Thank you for a problem report. As far as I remember HELP is mysql command line client's command, not a SQL statement. So, you should get "systax error" message ("The query could not be executed" + "You have an error in your SQL syntax..."). This is what I get on Windows.

On Linux I don't get any error. The query seems to be executed correctly, it says to me the execution time, but I don't see the results.

Anyway, HELP is also a SQL command. I'm attaching an image showing what I get with phpmyadmin.

help results

Attachment: schermatalocalhost.png (image/png, text), 106.02 KiB.

You are right. HELP is a part of SQL in MySQL (according to http://dev.mysql.com/doc/refman/5.0/en/help.html). But topic should be a string literal.

In any case, "help 'select'" statement also gives me no results in Query Browser on Windows, while it works from whatever ODBC-based client I tried. This is a bug.

Sorry for my mistake.

I think the problem is that the qurey returns a multi-line result .. and is truncate to one line.

In SQLyog same problem is there in 'GRID-mode' .. in 'text-mode' it displays properly.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. We won't fix this anymore because Workbench already has another solution here.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/