Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Product Name Grouping in PNE #173

Open
memeeerit opened this issue Oct 19, 2023 · 0 comments
Open

Product Name Grouping in PNE #173

memeeerit opened this issue Oct 19, 2023 · 0 comments

Comments

@memeeerit
Copy link
Contributor

In the PNE, there was a sql command "SELECT cve_id, cpe FROM affectedproduct WHERE cve_id = ? GROUP BY product_name, affected_product_id ORDER BY cve_id DESC, version ASC;";.

It's grouping by product_name and affected_product_id simultaneously, and since the id is unique this does not grouping at all. This query is being updated to reflect new architecture and is not keeping the inert grouping, but SHOULD we be doing grouping on product? And how would we select the appropriate cpe string if we are?

This is an investigative issue to confirm that no grouping is desired, not necessarily a bug.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant