Employees sample database - storage_engine option deprecated and removed in MySQL 5.7.5

Bug #1359263 reported by Daniel Price on 2014-08-20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Sample database with test suite

Bug Description


The "storage_engine" option that used in employees.sql, is deprecated and will be removed in MySQL 5.7.5, as noted here:


The "default_storage_engine" option should be used instead. Here is the section in the employees.sql file that should be updated to use default_storage_engine".

    set storage_engine = InnoDB;
-- set storage_engine = MyISAM;
-- set storage_engine = Falcon;
-- set storage_engine = PBXT;
-- set storage_engine = Maria;

select CONCAT('storage engine: ', @@storage_engine) as INFO;

Thank you,

Dan Price
MySQL Documentation Team

Changed in test-db:
status: New → Fix Committed
Evan Carroll (evancarroll) wrote :

It says fix committed but I'm not seeing it fixed. This problem is still very much there in this download:


In what version was it fixed, and how. As a side note there is a new variable now default_storage_engine. I'm not sure if it does the same thing.


Evan Carroll (evancarroll) wrote :

Ahh. There is no newer version uploaded than 1.0.6. It was fixed in the repo only. What a PITA.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers