1413816 - query.cgi: list of distinct components incorrectly ignores case

Status: UNCONFIRMED

(Bugzilla :: Query/Bug List, defect)

Description

[Robert Fleming]

Attachment: query.cgi_screenshot.png

User Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:56.0) Gecko/20100101 Firefox/56.0
Build ID: 20171003101344

Steps to reproduce:

1. create new Bugzilla installation using PostgreSQL
2. create 2 classifications, each with 1 product, each product with 1 component:

"Classification A" -> "Product A" -> "component a"
"Classification B" -> "Product B" -> "Component A"

3. file 1 new bug for each of these 2 components
4. go to query.cgi

5a: click "Classification A"
5b: click "Classification B"


Actual results:

When arriving at query.cgi, under Component there are only 3 items: "component a" and "TestComponent".

When clicking "Classification A", Components correctly contains only "component a".
When clicking "Classification B", Components incorrectly contains (only) "component a".

When searching "Classification B" with "component a" selected: Zarro Boogs found

--------
Database looks like:
>  classification_id |       name       | product_id | product_name | component_id | component_name | bug_id 
> -------------------+------------------+------------+--------------+--------------+----------------+--------
>                  1 | Unclassified     |          1 | TestProduct  |            1 | TestComponent  |       
>                  2 | Classification A |          2 | Product A    |            2 | component a    |      1
>                  3 | Classification B |          3 | Product B    |            3 | Component A    |      2
> (3 filas)

query:
> SELECT classifications.id AS classification_id, classifications.name,
>        products.id AS product_id, products.name AS product_name,
>        components.id AS component_id, components.name AS component_name,
>        bugs.bug_id
>   FROM classifications
>   JOIN products ON products.classification_id=classifications.id
>   JOIN components ON components.product_id=products.id
>   LEFT OUTER JOIN bugs ON bugs.component_id=components.id;



Expected results:

When arriving at query.cgi, under Component should be 3 items: "component a", "Component A" and "TestComponent".

When clicking "Classification B", Components should contain (only) "Component A".

When searching "Classification B" with "component a" (sic) selected, one might expect 1 bug to be found.

Comment 1

[Robert Fleming]

(In reply to Robert Fleming from comment #0)
> Actual results:
> 
> When arriving at query.cgi, under Component there are only 3 items:
> "component a" and "TestComponent".

Correction: "When arriving at query.cgi, under Component there are only *2* items"

Comment 2

[Robert Fleming]

This is still a bug as of Bugzilla 5.0.4.