[Koha-bugs] [Bug 21809] Deleting a request does not delete its log entries

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21809

--- Comment #2 from Andrew Isherwood <andrew.isherwood at ptfs-europe.com> ---
illrequests.illrequest_id is an auto_increment column, which is inline with the
vast majority of primary key columns in Koha. Googling around suggests that
MySQL/MariaDB shouldn't reuse deleted values in auto_increment columns, which
was always my understanding also.

However, I'm seeing log entries associated with requests where the log entries
are dated before the request was created. My assumption was that IDs were being
re-used, though, I have failed to replicate that behaviour. So perhaps the
problem is not caused by that after all.

I believe though that the bug is still valid. If a request is deleted, its log
entries should be also. Due to the inability to create a foreign key on
action_logs.object (due it potentially referring to many different keys), and
therefore the inability to create a cascade, I believe we should do this
cleanup manually.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.