MySQL Bugs: #78368: Sakila-spatial database can only be used with MySQL 5.7

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

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.

Patch to make the Sakila spatial database usable from any MySQL 5.x

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

Simple schema+data load files

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

Hello Giuseppe,

Thank you for the feature request and contribution.

Thanks,
Umesh

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.

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.