[
https://issues.apache.org/jira/browse/OFBIZ-5115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13542677#comment-13542677 ]
Leon commented on OFBIZ-5115:
-----------------------------
Dear Jacques, I know what you mean, but the entities we used is new created for our domain, not the OFBiz OOTB ones. That's why I demonstrate an example above.
For materialized view you mentioned, it's really a great feature, but I doubt a little whether it will be too complex to keep data consistency, especially for those view with various join condition and complicated group by clause.
> 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
