[
https://issues.apache.org/jira/browse/OFBIZ-5115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13540829#comment-13540829 ]
Jacques Le Roux commented on OFBIZ-5115:
----------------------------------------
Thanks Leon, actually I was not asking for an explanation and the generated SQL. I understood your issue. I was more looking for a ready made use case in term of OFBiz code (entity conditions). Because I want to run tests (ant load-demo run-tests) with it before committing and backporting.
If all entity conditions are embedded within your view entity, maybe a copy could help also. I try to minimize the work on my side, and also by reusing you r experience avoid any issues.
Also speaking about static view entity, if you are interested by performance for those, hopefully we will soon commit OFBIZ-4041...
> wrong COUNT DISTINCT if there's GROUP BY clause
> -----------------------------------------------
>
> Key: OFBIZ-5115
> URL:
https://issues.apache.org/jira/browse/OFBIZ-5115> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Leon
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: OFBIZ-5115.patch
>
>
> if there's a "group by" and distinct find options set, then the count of select returned is always the total number of non-distinct.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Locked
