Closed Bug 197482 Opened 21 years ago Closed 19 years ago

query for field = value OR field changed from value doesn't work

Categories

(Bugzilla :: Query/Bug List, defect)

Product:
Bugzilla
Component:
Query/Bug List
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED FIXED
Milestone:
Bugzilla 2.20

People

(Reporter: justdave, Assigned: bugreport)

References

Details

Under the following circumstances: (exmample)

File a new bug and set the version field to 1.0.

Advanced query is used and search for:
  version    is equal to    1.0
OR
  version    changed from   1.0

Search doesn't return any results, even though there's a known bug with version
equal to 1.0.

As discussed on IRC, root cause appears to be that the activity table is pulled
in with an inner (comma) join instead of a left join, even though it's possible
that the activity table won't have any matching rows.
Assignee: endico → nobody
I suspect this is fixed already in 2.19

fixed by bug 252889 for 2.19+. No 2.18 backport.
Status: NEW → RESOLVED
Closed: 19 years ago
Depends on: 252889
Resolution: --- → FIXED
Target Milestone: --- → Bugzilla 2.20
Assignee: nobody → bugreport
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.