Closed
Bug 95564
Opened 24 years ago
Closed 24 years ago
buglist.cgi uses an INNER JOIN, not supported in MySQL 3.22.5
Categories
(Bugzilla :: Bugzilla-General, defect, P1)
Tracking
()
RESOLVED
FIXED
Bugzilla 2.14
People
(Reporter: myk, Assigned: myk)
References
Details
(Keywords: regression)
Attachments
(1 file)
|
780 bytes,
patch
|
Details | Diff | Splinter Review |
INNER JOINs are supported on mysql version 3.23.0 and up, and mysql version
3.23.17 and up supports the ANSI SQL syntax for this command. Bugzilla,
however, requires only mysql 3.22.5, so it should either not contain INNER JOINs
or Bugzilla should require a newer version of mysql.
Requiring a newer version is a more complex issue that should probably involve,
among other things, polling Bugzilla installations, so in the meantime I am
attaching a patch to remove the INNER JOIN from buglist.cgi and replace it with
an equivalent expression supported by all relevant versions of mysql.
|
Assignee | |
Comment 1•24 years ago
|
||
|
|
Assignee | |
Comment 2•24 years ago
|
||
Seems like this should be in the 2.14 timeframe.
|
||
Updated•24 years ago
|
Severity: normal → critical
Keywords: regression
Priority: -- → P1
Summary: buglist.cgi uses an INNER JOIN → buglist.cgi uses an INNER JOIN, not supported in MySQL 3.22.5
|
|
||
Comment 4•24 years ago
|
||
I agree that we shouldn't up the mimimum version w/out finding out how willing
sites using bugzilla are to upgrade, esp. when there's fairly simple work
around. Testing looks good.
r=jake, checked in.
Status: ASSIGNED → RESOLVED
Closed: 24 years ago
Resolution: --- → FIXED
|
||
Comment 5•24 years ago
|
||
Moving to Bugzilla product
Component: Bugzilla → Bugzilla-General
Product: Webtools → Bugzilla
Version: Bugzilla 2.13 → unspecified
|
||
Updated•13 years ago
|
QA Contact: matty_is_a_geek → default-qa
You need to log in
before you can comment on or make changes to this bug.
Description
•