Bug #96968 Some database engines seems not to be really working
Submitted: 23 Sep 2019 6:34 Modified: 1 Oct 2019 15:50
Reporter: Stefano Remigio Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.17 OS:Any
Assigned to: CPU Architecture:Any
Tags: Aria, engine

[23 Sep 2019 6:34] Stefano Remigio 
Description:
The workbench allows to select up to 21 different database engines,
but only 9 of them seems to be enabled.

For instance, if I select "Aria" Engine, when executing the script I get the following response: 

ERROR: Error 1286: Unknown storage engine 'Aria'
SQL Code:
        -- -----------------------------------------------------
        -- Table `mydb`.`table1`
        -- -----------------------------------------------------
        CREATE TABLE IF NOT EXISTS `mydb`.`table1` (
          `col1` INT NOT NULL,
          `col2` VARCHAR(45) NULL,
          PRIMARY KEY (`col1`))
        ENGINE = Aria

How to repeat:
Create a table selecting Aria Engine in the Workbench
[23 Sep 2019 10:33] MySQL Verification Team 
Hello Stefano,

Thank you for the report.
Imho, if your server doesn't support a specific storage engine then you may get the same from the CLI session too.

regards,
Umesh
[23 Sep 2019 11:30] Stefano Remigio 
>> Imho, if your server doesn't support a specific storage engine then you may get the same from the CLI session too.

Sorry, I can't get what you are meaning to say...
[1 Oct 2019 15:50] Christine Cole 
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.19 release, and here's the changelog entry:

Storage engines not supported by MySQL were listed as possible engines
that could be selected for tables. Unsupported storage engines now are
removed from the suggestion list.

Thank you for the bug report.