1487768 - Datetime searches are not calendar-wise

Status: UNCONFIRMED

(Bugzilla :: Query/Bug List, defect)

Description

[marcelo.leitner]

User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36

Steps to reproduce:

A search by last-changed time, and used a relative date of "4m".



Actual results:

As today is day 31th, the query failed because bugzilla simply did "today's month - 4 months", resulting in 2018-04-31 which doesn't exist.

Server error: <Fault -32000: 'DBDst execute failed: ERROR:  date/time field value out of range: "2018-04-31 +09:08:35"

query part: op=delta_ts&o$op=lessthan&v$op=4m



Expected results:

It should have done a calendar-wise operation, and have resulted in 2018-05-01 instead.

Reproduced on bugzilla.redhat.com, but reporting here as I couldn't find any document stating that it will do a calendar-wise operation, so I'm assuming the bug is upstream.