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

Bug #1359263 reported by Daniel Price
20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Sample database with test suite
Fix Committed
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
Revision history for this message
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

Revision history for this message
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.