PRSQL9103004: Results Incorrect with GROUP BY and Sum in Views ID Number: Q70824
1.10 OS/2 buglist1.10
Summary:
PROBLEM ID: PRSQL9103004
SYMPTOMS A view created with a GROUP BY clause and an aggregate expression produces incorrect cardinality in the result set.
RESOLUTION Instead of creating a view, use a temporary table or the original table.