[Koha-bugs] [Bug 23487] Utf8mb4 collation causes problems with missing tables when upgrading the database

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

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

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #2 from David Cook <dcook at prosentient.com.au> ---
(In reply to Katrin Fischer from comment #1)
> This has been reported 4 years ago and I believe it might have been caused
> by a changed collation on the borrowers table.
> Should this be marked WONTFIX at this point?

I think this could be marked as WONTFIX.

It sounds like an unfortunate migration issue, but I think "dave" and "davé"
probably should be considered as equivalent for a unique index. 

When I try to make two patron records with those as the userid and cardnumber,
I get the following warning:

The following fields are wrong. Please fix them.

Username already exists or could not create unique new one.
Cardnumber already in use.

So I think that sounds right to me.

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