[OFBIZ-9428] getResultsSizeAfterPartialList() return wrong count with distinct() for View Entity

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Trunk
• Fix Version/s: Release Branch 13.07, Release Branch 14.12, Release Branch 15.12, 16.11.04
• Assignee: Jacques Le Roux
• Reporter: Renuka Srishti
• Created: 24/Jun/17 04:40
• Updated: 05/Sep/17 07:49
• Resolved: 07/Aug/17 12:29

Description

Here is the code sample to test the issue

EntityListIterator productAssocListItr = null;
productAssocListItr = from("ProductAndAssoc").distinct().queryIterator();
productAssocListSize = productAssocListItr.getResultsSizeAfterPartialList();

productAssocListSize will differ from the actual distinct records in the ProductAndAssoc View Entity.
This issue exists because it gives distinct records on the basis of the first column in the table.

Issue Links

• is related to: OFBIZ-5701 Bug SQL Count Distinct command in GenericDAO.java