--- In firebird-support@yahoogroups.com, "Filipe Bortolini"
<filipe@p...> wrote:

> Hey,
>
> I'm trying to execute the following SQL under Firebird 1.5 RC7 and

I'm getting the error message "number of page buffers for cache
required". If I take the L.DATA_DOC field out of the Order By, the SQL
executes without problems. Any Idea what this could be?

Filipe, firstly install FB1.5 client software including
firebird.msg. After that you'll see real commentary on exception code.
Ordering by column not included into Group By is error.

> PS: The SQL executes without problems on FB 1.0.

Yes, this bug was present in all previous IB/FB versions and modern
IB too. In certain curcuimstances such a query can return correct
result but generally it is senseless and unpredictable.

Best regards,
Alexander.