600496 - Can't search for bugs created before a certain date ([Bug creation] is broken)

Status: RESOLVED FIXED

(Bugzilla :: Query/Bug List, defect)

Description

[Gervase Markham [:gerv]]

I want to find all bugs created before 2000-06-17.

4.0: https://landfill.bugzilla.org/bugzilla-4.0-branch/buglist.cgi?chfieldto=2000-06-17&chfield=[Bug%20creation]

=> 11 bugs found.

Tip: https://landfill.bugzilla.org/bugzilla-tip/buglist.cgi?chfieldto=2000-06-17&chfield=[Bug%20creation]

=> Error: "Can't use [Bug creation] as a field name."

Comment 1

[Max Kanat-Alexander]

Well, the code is still there:

  if (grep { $_ eq '[Bug creation]' } @fields) {

So not sure what's happening. Will have to investigate.

Comment 2

[Max Kanat-Alexander]

Attachment: v1

The problem was that we didn't properly deal with the fact that [Bug creation] isn't a valid field name. So, instead of worrying about that, now I translate it into creation_ts, which is a valid field name.

Comment 3

[Max Kanat-Alexander]

Comment on attachment 480408 [details] [diff] [review]
v1

Actually, this patch doesn't work, because it tries to find times when creation_ts changed, which never happens.

Comment 4

[Max Kanat-Alexander]

Attachment: v2

Okay, I instead developed a more-architecturally-ideal fix, where the "changedafter" and "changedbefore" operators now work as one would probably expect them to with the creation_ts field, so we don't need special code for creation_ts in that _special_parse function in Search.pm.

Comment 5

[Max Kanat-Alexander]

Committing to: bzr+ssh://bzr.mozilla.org/bugzilla/trunk/                       
modified Bugzilla/Search.pm
modified xt/lib/Bugzilla/Test/Search/Constants.pm
Committed revision 7503.