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.