244503 - inconsistency with database fields bugs.target_milestone and milestones.value

Status: RESOLVED INVALID

(Bugzilla :: Bugzilla-General, defect)

Description

[Daniel Raichle]

In the "milestones"-table the field "value" is varchar(64) but in the
"bugs"-table the field "target_milestone" is only varchar(20).
This leads to some errors when using milestones which are longer than 20 characters:
- show_bug.cgi does not show the right milestone for this bug
- Sanity-check produces the warning: "Bad values xxx, yyy found in
bugs.product_id / bugs.target_milestone (bug zzz)" where xxx is the product-id,
yyy is the selected milestone (shortened to 20 characters) and zzz is the bug-id

Comment 1

[Daniel Raichle]

sorry, I found that this "milestones.value"-field is originally varchar(20).
Here in our bugzilla-installation we did a local modification to varchar(64) and
forgot to change the "bugs.target_milestone"-file, too.

=> no bug...