[
https://issues.apache.org/jira/browse/OFBIZ-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12550726
]
Joe Eckard commented on OFBIZ-1514:
-----------------------------------
To reproduce this from a clean checkout:
Load demo data, create keywords for all products. In the catalog manager, do a
keyword search for "gizmos" with a VIEW_SIZE parameter of 10. You should see
"1-10 of 19". Then manually add the keyword "gizmotron" to Big Gizmo (GZ-8544).
Do the same search again and you should see "1-10 of 20".
> Duplicates in Search Results
> ----------------------------
>
> Key: OFBIZ-1514
> URL: https://issues.apache.org/jira/browse/OFBIZ-1514
> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: SVN trunk
> Reporter: Joe Eckard
> Priority: Minor
>
> If a product has multiple keywords with identical roots and different
> relevancy weights and the product is within a set of search results that span
> multiple pages, then it will be duplicated in the results display. This is
> because ProductSearch is doing a "distinct" on productId, relevancyWeight(s)
> instead of grouping by the productId.
> I'm attaching a small proof-of-concept patch to make grouping by productId
> the default - it appears to work well with various combinations of search
> criteria (multiple keywords, features, feature cats, categories, etc.) but I
> haven't done a tremendous amount of testing. (Only using PostgreSQL and Derby)
> From the comments in the ProductSearch code it looks like it was done this
> way once, but it may have caused problems with Oracle. Does anyone know what
> that problem was, or can anyone check this patch against oracle?
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
