Closed
Bug 850429
Opened 11 years ago
Closed 11 years ago
Searching on Due Date Is Empty does not work anymore
Categories
(bugzilla.mozilla.org :: General, defect)
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.
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: 11 years ago
Resolution: --- → FIXED
Reporter | ||
Comment 3•11 years ago
|
||
Thanks for the quick response Byron. How do these fixes usually get pushed to Bugzilla? What is the timeframe?
Comment 4•11 years ago
|
||
(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 :)
Reporter | ||
Comment 6•11 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 → ---
(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: 11 years ago → 11 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•