302651 - searches with days since bug changed to_days chart cause search to fail

Status: RESOLVED DUPLICATE of bug 302599

(Bugzilla :: Query/Bug List, defect)

Description

[A. Karl Kornel]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)

With the capitalization of TO_DAYS() in SQL, any searches (bookmarked or saved)
that refer to the older to_days() field generate an error when the search is run.

Reproducible: Always

Steps to Reproduce:
1. In Bugzilla 2.19.2 or earlier, create a search involving the "Days since bug
changed" boolean chart.
2. Either bookmark the search URL, or save the search
3. In Bugzilla 2.19.3, either run the saved search or go to the bookmarked URL.

Actual Results:  
I get the error "Can't use (to_days(now()) - to_days(bugs.delta_ts)) as a field
name."

Expected Results:  
The search should have executed as it did in 2.19.2 and earlier.

The URL points to a site running BUGZILLA-2_20-BRANCH so you can see the error
in action.

Based on a conversation in the newsgroup, it seems that this may be a regression
of bug 237862 (checked in 16 Feb.) or bug 280499 (checked in 19 Feb.).

Comment 1

[A. Karl Kornel]

Never mind.  It looks like this was already filed!

*** This bug has been marked as a duplicate of 302599 ***