Closed Bug 350237 Opened 19 years ago Closed 19 years ago

checksetup does not properly add a short_desc index to old installations

Categories

(Bugzilla :: Installation & Upgrading, defect)

2.23
defect
Not set
critical

Tracking

()

RESOLVED FIXED
Bugzilla 3.0

People

(Reporter: mkanat, Assigned: mkanat)

References

Details

(Keywords: regression)

Attachments

(1 file)

checksetup now fixes the short_desc index to not be fulltext, but it doesn't add a short_desc index if the installation is so old that it doesn't have one.
Attached patch v1Splinter Review
Granting review myself as module owner for DB and installation.
Attachment #235488 - Flags: review+
Requesting approval directly, as module owner.
Status: NEW → ASSIGNED
Flags: approval?
Is a regular index really useful for short_desc? Doesn't it only help when users search from the beginning of a short description, which they rarely do?
Flags: approval? → approval+
(In reply to comment #3) > Is a regular index really useful for short_desc? Doesn't it only help when > users search from the beginning of a short description, which they rarely do? Yeah. It's not that useful. We could probably eliminate it--I just have to make sure that the MySQL 4 LIKE optimizations don't depend on having an index. Checking in Bugzilla/Install/DB.pm; /cvsroot/mozilla/webtools/bugzilla/Bugzilla/Install/DB.pm,v <-- DB.pm new revision: 1.12; previous revision: 1.11 done
Status: ASSIGNED → RESOLVED
Closed: 19 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: