[Koha-bugs] [Bug 20271] Merge deleted biblio, biblioitems, biblio_metadata, and items tables

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

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

--- Comment #201 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Kyle M Hall from comment #200)
> > We could have a boolean flag is_deleted, in addition of deleted_on that
> > contains an important info. The problem is that it will not work either, as:
> > The following situation should be valid but will fail the unique constraint:
> > (id, is_deleted)
> > (42, 1)
> > (42, 0)
> > (42, 0)
> 
> I don't think I understand what scenario would create a situation such as
> this, could you elaborate?

Sorry, wrong copy/paste, it was the reverse:
(id, is_deleted)
(42, 0)
(42, 1)
(42, 1)
So barcode=42 can appear several times, but only once with is_deleted=0.
Result is the same, the constraint will fail.

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