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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24741 --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to David Gustafsson from comment #1)

I'm not 100%, but think a correct query to remove duplicates could be written like:

DELETE FROM library_groups WHERE id NOT IN ( SELECT MIN(id) FROM ( SELECT * FROM library_groups ) AS lg GROUP BY parent_id, branchcode ) AND NOT(parent_id IS NULL OR branchcode IS NULL);

This query looks correct to me. Could you submit a patch? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.