[Libreoffice-qa] Bugzilla Query puzzling

[Petr Mladek]

Rainer Bielefeld píše v So 12. 11. 2011 v 17:20 +0100:
> Hello,
> 
> I am just trying to create a reliable "bug needs review for Confirmation".
> 
> 1. step was
> <https://bugs.freedesktop.org/buglist.cgi?emailtype2=substring&list_id=10914&emaillongdesc1=1&field0-0-0=status_whiteboard&emailtype1=notregexp&chfieldto=Now&query_format=advanced&chfield=[Bug%20creation]&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=PLEASETEST&email2=libreoffice-bugs%40lists.freedesktop.org&email1=LibreOffice%40bielefeldundbuss.de%20%20%20detective.conan.1412%40gmail.com%20%20iamtester8%40gmail.com%20jbf.faure%40orange.fr%20%20%20fyvaao%40ya.ru%20%20vitriol_vitriol%40katamail.com%20andre.schnabel%40gmx.net%20drew%40baseanswers.com%20%20%20maand%40gmx.de%20%20wope%40gmx.com%20%20baur.steven%40googlemail.com%20%20dmx404%40gmail.com%20jeffdchang%40gmail.com%20%20yfjiang%40novell.com%20%20%20%20jr%40natural-computing.de%20%20&emailassigned_to2=1&type0-0-0=notsubstring&value0-0-0=CONFIRMED&product=LibreOffice>
> 
> 2. Step was
> <https://bugs.freedesktop.org/buglist.cgi?emailtype2=substring&emaillongdesc1=1&field0-0-0=status_whiteboard&emailtype1=notregexp&chfieldto=Now&query_format=advanced&chfield=[Bug%20creation]&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=PLEASETEST&email2=libreoffice-bugs%40lists.freedesktop.org&email1=LibreOffice%40bielefeldundbuss.de%20%20%20detective.conan.1412%40gmail.com%20%20iamtester8%40gmail.com%20jbf.faure%40orange.fr%20%20%20fyvaao%40ya.ru%20%20vitriol_vitriol%40katamail.com%20andre.schnabel%40gmx.net%20drew%40baseanswers.com%20%20%20maand%40gmx.de%20%20wope%40gmx.com%20%20baur.steven%40googlemail.com%20%20dmx404%40gmail.com%20jeffdchang%40gmail.com%20%20yfjiang%40novell.com%20%20%20%20jr%40natural-computing.de%20%20&emailassigned_to2=1&type0-0-0=notsubstring&value0-0-0=CONFIRMED&product=LibreOffice>



> I would have expected more or less the same number of bugs, but 1. has 
> 2767 hits, 2. 2316 ones.

Strange, both queries give me 2781 bugs now.


>  At the end of the list may be 50 can miss, 
> that's inteded, but within the line In 2. are missing Bugs 35041, 35393, 
> 36992, 37222, 37276, 37312, 37721, 38273, 

At least 38273 is include in both queries.


> Intention for step 2 only was to shift the Status info to "Custum 
> Search" to exclude NEW after a particular Bug No (41983, Ocotober-16, 
> new Bugzilla)

Heh, I tried to add the condition:

AND
"Status"           "string contains"     "UNCONFIRMED"  OR
"Creation Date"    "changed before"      "2011-10-16"
AND

It should ignore bugs in the state "NEW" that were created after
"2011-10-16".

Heh, I tried to modify the query from the wiki page
https://wiki.documentfoundation.org/BugTriage. I realized that I forgot
to check for status "PLEASETEST", so I tried to add:

AND
"Status"           "string contains"     "UNCONFIRMED"  OR
"Status"           "string contains"     "PLEASETEST"   OR
"Creation Date"    "changed before"      "2011-10-16"
AND

I played also with "is equal to" and "contains the string (exact case)"
Then bugzilla got mad and showed only bugs with the status "UNCONFIRMED"

I think that it does not make sense.

I think that there is either a bug in bugzilla and condition processing.

Or there is a problem with caches. I quess that bugzilla caches some
queries and it reuses the cache a wrong way. In some cases, your
modifications in a query might be ignored.

> I can't find out why, can you help?

I am a bit lost as well. Maybe, it is better to wait until morning and
hope that the broken caches will get lost.


Best Regards,
Petr