MySQL Bugs: #38447: Unsupported table engines in the Table Editor

Bug #38447	Unsupported table engines in the Table Editor
Submitted:	30 Jul 2008 8:33	Modified:	26 May 2009 13:17
Reporter:	Federico Razzoli (OCA)	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
In the "Storage Engine" menu of the Table Editor, unsupported engines are listed.

How to repeat:
1. Right-click on a table
2. Click "Edit"
3. Select the "Table Options" tab
4. Take a look at the Storage Engine menu

Suggested fix:
In my opinion, the Query Browser performs a SHOW STORAGE ENGINES and checks the value of Support field: if it is 'DISABLED' the engine is not shown. But if value is 'NO' table is shown.

On Windows I see engines with 'NO' in SHOW ENGINES results in red (not in black as those that can be used), and when I try to select one of them I get a warning ("The storage engine you selected is not enabled curently"). Please, check.

I checked again to be sure. On Linux, ALL storage engines are listed in black and I get no warning if I select BerkleyDB or Isam.

All engines in black.

Attachment: Schermata-Table Editor.png (image/png, text), 38.43 KiB.

Thank you for the bug report.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

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