MySQL Bugs: #6044: Optimal_fieldtype column missing for PROCEDURE ANALYSE()

Bug #6044	Optimal_fieldtype column missing for PROCEDURE ANALYSE()
Submitted:	12 Oct 2004 14:35	Modified:	12 Oct 2004 17:05
Reporter:	John Paul Ashenfelter	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.07 beta	OS:	Windows (Win XP SP2)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Using PROCEDURE ANALYSE in the GUI returns a result set that is *missing* the optimal_fieldtype column (arguably the whole point of the command). If I use the "GUI Command Line", I get the expected result.

I am using MySQL 4.1.5-gamma running locally. The mysql client also works fine with this command.

How to repeat:
I'm using your world demo database and running queries like

SELECT name FROM city WHERE population > 250000 PROCEDURE ANALYSE()

Suggested fix:
Not sure, but could it be related to Bug 2813?

Hi,

Thank you for the report, but I wasn't able to repeat it with Query Browser 1.0.8