Closed Bug 850429 Opened 7 years ago Closed 7 years ago

Searching on Due Date Is Empty does not work anymore

Categories

(bugzilla.mozilla.org :: General, defect)

Production
x86
macOS
defect
Not set

Tracking

()

RESOLVED FIXED

People

(Reporter: st3fan, Assigned: glob)

References

Details

I am doing a search with:

product = mozilla.org
component = Security Assurance: Review Request
Match any of the following: "Due Date" "is empty"

This is supposed to return a couple dozen bugs but instead it returns zero. This behaviour changed with the last upgrade I think.

If I change to "Due Date" "is not empty" then I see all bugs including bugs that have an empty Due Date.
Assignee: nobody → glob
4.2's search coalesce's dates to an epoch date, instead of leaving them as null:

 (COALESCE(bugs.cf_due_date, '1970-01-01 00:00:00') IS NULL
  OR COALESCE(bugs.cf_due_date, '1970-01-01 00:00:00') = '')

in fact it looks like most null values are coalesced.
after walking through the code, only bug_id and dateatime custom fields require special handling, which greatly simplified this patch (you don't want to see some of my earlier revisions!).

Committing to: bzr+ssh://bjones%40mozilla.com@bzr.mozilla.org/bmo/4.2/
modified Bugzilla/Search.pm
Committed revision 8656.
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → FIXED
Thanks for the quick response Byron.

How do these fixes usually get pushed to Bugzilla? What is the timeframe?
(In reply to Stefan Arentz [:st3fan] from comment #3)
> Thanks for the quick response Byron.
> 
> How do these fixes usually get pushed to Bugzilla? What is the timeframe?

Should be live as of last night.

dkl
(In reply to Stefan Arentz [:st3fan] from comment #3)
> How do these fixes usually get pushed to Bugzilla? What is the timeframe?

we push weekly, generally late wednesday/early thursday.
follow blog.glob.com.au (or planet.mozilla.org) if you want to keep abreast of the pushes :)
I am reopening this bug because I am seeing the exact same behaviour as described in the first comment again. Looks like a regression?

Is there a better way to filter on: "Due Date" "is empty" ?
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
(In reply to Stefan Arentz [:st3fan] from comment #6)
> I am reopening this bug because I am seeing the exact same behaviour as
> described in the first comment again. Looks like a regression?

we need to file a new bug for this -- when you reopen a bug which has been marked as fixed, it makes it very hard to track both changes (the fixes may be different, made by different people, etc).

i've filed bug 884345.
Status: REOPENED → RESOLVED
Closed: 7 years ago7 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.