[Koha-bugs] [Bug 8002] Can't add patron attribute type in newer installation

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8002

--- Comment #22 from Paul Poulain <paul.poulain at biblibre.com> ---
(In reply to comment #21)
> But it is normal MySQL does what we ask him :)

Definetly it's not normal, and it's a bug !
When you don't have a constraint and try to add one, if there are data that
would not respect the constraint, you get a message, and the constraint is not
set. Seel update22to30.pl to see how I handled this case in the past = I throw
a clear warning, with the query to run to see which data was wrong, so the
library could fix it and put the constraint.

I'm expecting from ALTER TABLE that an existing constraint is checked before
the table is altered !
Also note that, iirc, you can't put a constraint on 2 columns with different
type/size. That could be easily checked by mysql when you ALTER TABLE !

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