Bug #78368 Sakila-spatial database can only be used with MySQL 5.7
Submitted: 8 Sep 2015 14:06 Modified: 18 Sep 2015 17:08
Reporter: Giuseppe Maxia (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[8 Sep 2015 14:06] Giuseppe Maxia
Description:
The Sakila database has been enhanced to use features that were introduced in MySQL 5.6 and 5.7.
The latest release (so called sakila-spatial) is only available in MySQL 5.7. It would be useful to make the new features to be added conditionally, so that InnoDB fulltext is used for MySQL 5.6+ and spatial features are added if using MySQL 5.7.

How to repeat:
Try to load the Sakila spatial database in MySQL 5.6 or 5.5.

Suggested fix:
I am attaching a patch.
[8 Sep 2015 14:07] Giuseppe Maxia
Patch to make the Sakila spatial database usable from any MySQL 5.x

Attachment: sakila-spatial-patch.zip (application/zip, text), 1.24 MiB.

[8 Sep 2015 14:11] Giuseppe Maxia
Simple schema+data load files

Attachment: sakila-multiversion.zip (application/zip, text), 653.11 KiB.

[9 Sep 2015 13:20] MySQL Verification Team
Hello Giuseppe,

Thank you for the feature request and contribution.

Thanks,
Umesh
[12 Sep 2015 1:37] Philip Olson
Excellent contribution! These (and related) changes have been committed, and this bug report will be updated after all of the changes are confirmed on dev.mysql.com.
[18 Sep 2015 17:08] Philip Olson
The following were updated according to this bug report:

This now only lists a single sakila:
  http://dev.mysql.com/doc/index-other.html

The documentation was updated accordingly:
  http://dev.mysql.com/doc/sakila/en/index.html

Mainly these pages:
  http://dev.mysql.com/doc/sakila/en/sakila-installation.html
  http://dev.mysql.com/doc/sakila/en/sakila-news-1.0.html
  http://dev.mysql.com/doc/sakila/en/sakila-acknowledgments.html

The downloads now only contain this new sakila, although the bundled sakila
model file (for Workbench) did not change but that is a separate issue.

Lastly, as agreed upon, the acknowledgements were moved from the sakila SQL
files to dev.mysql.com.

Again, thank you for this wonderful contribution and for making the sakila
installation much simpler.