Searching on Due Date Is Empty does not work anymore

RESOLVED FIXED

Status

()

bugzilla.mozilla.org
General
RESOLVED FIXED
4 years ago
4 years ago

People

(Reporter: st3fan, Assigned: glob)

Tracking

(Blocks: 1 bug)

Production
x86
Mac OS X

Details

(Reporter)

Description

4 years ago
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)

Updated

4 years ago
Assignee: nobody → glob
(Assignee)

Comment 1

4 years ago
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.
(Assignee)

Comment 2

4 years ago
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
Last Resolved: 4 years ago
Resolution: --- → FIXED
(Reporter)

Comment 3

4 years ago
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
(Assignee)

Comment 5

4 years ago
(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 :)
(Reporter)

Comment 6

4 years ago
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 → ---
(Assignee)

Comment 7

4 years ago
(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
Last Resolved: 4 years ago4 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.