[Koha-bugs] [Bug 24741] Recent creation of unique index on library_groups erroneously removes rows

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

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

--- Comment #4 from Stefan Berndtsson <stefan.berndtsson at ub.gu.se> ---
(In reply to Jonathan Druart from comment #2)
> I tried again.
> For me it does not remove non-duplicate entries, but it removed an empty
> subgroup:
> 
> Before: https://snipboard.io/20aTY9.jpg
> After : https://snipboard.io/lKzaeE.jpg
> 
> Subgroup 'yyyy' has been removed (not correct), however 'FPL' has not been
> removed from the first 'xx' group.
> 
> Did you notice another behavior?

Yes.

In our case we had:

https://snipboard.io/cLhEY7.jpg

Since I've restored the data, I don't have an after-image, but after the
migration ACQ was the only one left under __SEARCH_GROUPS__. All the others had
been removed, with their entire substructure.

ACQ is the one with the lowest "id", and MIN(id) therefor kept that one.

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