Bug #69728 | sakila Sample Database has loops which would allow inconsistent data | ||
---|---|---|---|
Submitted: | 12 Jul 2013 0:04 | Modified: | 3 Oct 2019 16:03 |
Reporter: | Thomas Turrell-Croft | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | Version 0.8 | OS: | Any |
Assigned to: | Paul DuBois | CPU Architecture: | Any |
[12 Jul 2013 0:04]
Thomas Turrell-Croft
[18 Jul 2013 19:31]
Sveta Smirnova
Thank you for the report. Your complain is valid and can be solved either the way you propose or by adding an INSERT/UPDATE trigger on table rental.
[3 Oct 2019 16:03]
Paul DuBois
Posted by developer: The database implementation was left as is since the issue, as noted by the bug reporter, "isn't very important." Instead, we mention the problem in the docs as a known issue left as a reader exercise, with some suggestions from the bug report about how the reader could tackle the problem. See https://dev.mysql.com/doc/sakila/en/sakila-known-issues.html.