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

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

Bug Description

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

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:

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) 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