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

[Daniel Price]

Hi,

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

http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-5.html

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

[Evan Carroll (evancarroll)]

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

https://launchpadlibrarian.net/24493586/employees_db-full-1.0.6.tar.bz2

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.

http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_default-storage-engine

[Evan Carroll (evancarroll)]

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