88621 - Inconsistent db column size for storing version (version & bug table)

Status: RESOLVED DUPLICATE of bug 9352

(Bugzilla :: Bugzilla-General, defect)

Description

[Chris Hagner]

An admin created a version with > 16 chars. This is okay, since the version
table's version field is tinytext(64 char). However, the version column in the
bug table is only 16 chars. Thus, when entering a bug for this version, only 16
chars get stored in the db.

Well, the real problem occurs when pulling up the same bug later. The page
shown basically says something has gone wrong and to contact your bugzilla adin.

Now, the sanity report does show the inconsistency, but the only way to resolve
it (without modifying the code) is to log in to mysql and issue an update to
reset the bug's version value to one that is actually <= 16 chars.

Please let me know if any of this seems fishy. To the best of my knowledge, we
are running a stock 2.12 system, thus my desire to report this issue to you.

Thanks. Bugzilla is king.

Comment 1

[Dave Miller [:justdave]]

*** This bug has been marked as a duplicate of 9352 ***

Comment 2

[Dave Miller [:justdave]]

Bug 9352 is already fixed, btw.  This will be in the 2.14 release, or you can 
update from cvs if you want it now.

Comment 3

[Dave Miller [:justdave]]

moving to Bugzilla product
reassign to default owner/qa for INVALID/WONTFIX/WORKSFORME/DUPLICATE