Subject Re: [firebird-support] IB 5.6 / Firebird GROUP BY / ORDER BY Problem
Author Helen Borrie
At 09:56 AM 2/04/2004 +0000, you wrote:
>Hi Elmar,
>
>Thanks for the reply. I guess it doesn't make a difference if you sort
>on MAX(aField) or the field itself?, because the MAX of a field for each
>record is the field value itself.

No, it's not the field per record, but the a MAX or MIN aggregate of those
values for the group. That makes it valid at the level of the group,
whereas the individual values are not.

> > Was working under IB 5.6

And now it's been fixed.


>What did IB 5.6 do there?

Broke the rules.

/hb