Hi
I have come accross what I assume is a known bug in 1.5

select
sum(qty),0,sum(bond),pid
from otw_products where whs='' and pid=:pid
group by 2,4

goes crazy - returns infinite number of lines, where as

select
sum(qty),0,sum(bond)
from otw_products where whs='' and pid=:pid
group by 2

works fine. Variations of putting constants and fields between and after
the sum()s either work, crash the server or return infinite lines.

I need this crazy patern in the select for a union clause to match the
columns in the other part.

Is there a way round?

Regards
Paul


[Non-text portions of this message have been removed]