264342 - Simple ALL query returns no results

Status: RESOLVED DUPLICATE of bug 263452

(Bugzilla :: Query/Bug List, defect)

Description

[Andy Brook]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; rv:1.7.3) Gecko/20041001 Firefox/0.10.1
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; rv:1.7.3) Gecko/20041001 Firefox/0.10.1

I cannot get 2.18rc2 to return results if I select 'All' products and no words,
nothing is returned.  If I either add a word or change to a specific product,
results are found.

Possibly related, the default 'My bugs' saved search returns nothing also, for
all users.

Reproducible: Always
Steps to Reproduce:
99% of the time.

1. set status to any value, Product to 'All'
2. Search
3.

Actual Results:  
Zarooo bugs

Expected Results:  
List of open/closed or all bugs.

Comment 1

[Dave Miller [:justdave]]

Do you have any restricted bugs?  If so, are you logged in when you run the query?

Are you deselecting all of the statuses before running the query?  The default
query usually only chooses specific statuses.  Also, try deselecting all of the
products instead of selecting all of them, it's semantically the same thing, and
the query will run faster.  (It's not restricted by product unless you choose
one or more, and not restricting it by product is the same as restricting it to
all products)

Comment 2

[Andy Brook]

If I understand 'restricted' referring to bugs protected by bug groups? yes, Ive
got 3 top level 'Products' that are bug grouped, and one test category.  I am
logged in when I perform the query, logins are enfoced in any case.  The query
Im using is the 'Find a specific' one with three options so there are no
statuses to deselect.  The advanced search works fine.

In the 'Find a specific' search, selecting status of 'all' Product 'all' I get
no results.  Open/all gets me a list of protected bugs from my three Products. 
Closed/all returns nothing, but Closed/All with words set to 'test' picks out a
list of test items from both Protected and the non bug grouped Test products.

The annoying thing is 'My Bugs' default search.  It fails intermittently, I just
deleted it when that happened and saved another search but other nove users just
get annoyed when 'their' bugs go missing.  I've just got one such user to check
it this morning and guess what, it works today, but definitely failed to return
results last week.

Comment 3

[Andy Brook]

The search just failed again.  Here is the output from the search with &debug=1,
it may yield some insights to someone!

SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status,
bugs.resolution, bugs.bug_severity, bugs.priority, bugs.rep_platform,
map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc
FROM bugs, profiles AS map_assigned_to LEFT JOIN bug_group_map ON
bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN
(6,3,10,4,1,7,9,2,5,11,8) LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 2
WHERE bugs.assigned_to = map_assigned_to.userid AND (bugs.bug_status IN
('UNCONFIRMED','NEW','ASSIGNED','REOPENED')) AND ((bug_group_map.group_id IS
NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 2) OR
(bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 2) )
GROUP BY bugs.bug_id

Comment 4

[Andy Brook]

Further to this, It seems one installation (a) it works but (b) it doesnt,
works (at least the first time I tried) for:

Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.05
Checking for    Data::Dumper (any)     ok: found v2.121
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.36)   ok: found v1.43
Checking for      DBD::mysql (v2.1010) ok: found v2.9004
Checking for      File::Spec (v0.82)   ok: found v0.88
Checking for      File::Temp (any)     ok: found v0.14
Checking for        Template (v2.08)   ok: found v2.13
Checking for      Text::Wrap (v2001.0131) ok: found v2001.0929

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v1.20
Checking for     Chart::Base (v1.0)     found v0.99
Checking for     XML::Parser (any)     ok: found v2.31
Checking for       GD::Graph (any)     ok: found v1.43
Checking for GD::Text::Align (any)     ok: found v1.18
Checking for     PatchReader (v0.9.4)  ok: found v0.9.5

If you you want to see graphical bug charts (plotting historical data over 
time), you should install libgd and the following Perl modules:

Chart:       /usr/bin/perl -MCPAN -e 'install "Chart::Base"'

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for    MySQL Server (v3.23.41) ok: found v4.0.18-max
Checking for       Net::LDAP (any)     ok: found v0.32

--

fails for:
Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.05
Checking for    Data::Dumper (any)     ok: found v2.12
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.36)   ok: found v1.43
Checking for      DBD::mysql (v2.1010) ok: found v2.9004
Checking for      File::Spec (v0.82)   ok: found v3.01
Checking for      File::Temp (any)     ok: found v0.14
Checking for        Template (v2.08)   ok: found v2.13
Checking for      Text::Wrap (v2001.0131) ok: found v2001.0929

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v1.20
Checking for     Chart::Base (v1.0)     found unknown version
Checking for     XML::Parser (any)     ok: found v2.31
Checking for       GD::Graph (any)     ok: found v1.43
Checking for GD::Text::Align (any)     ok: found v1.18
Checking for     PatchReader (v0.9.4)  ok: found v0.9.5

If you you want to see graphical bug charts (plotting historical data over 
time), you should install libgd and the following Perl modules:

Chart:       /usr/bin/perl -MCPAN -e 'install "Chart::Base"'

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for    MySQL Server (v3.23.41) ok: found v4.0.21-standard
Checking for       Net::LDAP (any)     ok: found v0.32

Comment 5

[Andy Brook]

see dependant bug, profile table got wiped, but never caused a visible error.

Comment 6

[Max Kanat-Alexander]

If this was fixed in the dependent bug, then it's WORKSFORME, now, not FIXED, I
would think, if this bug itself doesn't represent a patch... right?

Comment 7

[Max Kanat-Alexander]

OK, this is actually a *duplicate* of the dependent bug, not a blocker.

Comment 8

[Max Kanat-Alexander]

OK, this is actually a *duplicate* of the dependent bug, not a blocker.

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