Subject Re: [firebird-support] Re: BAD BLR ??? Whats? Select Sum in View
Author Ann W. Harrison
Kurt Schneider wrote:
> Hello... An Ideia to resolve BAD BLR? The firebird have and configuration to
> expand the number of relations permited.? Its really bad to database
> utility, my project is serius affected for this problem, a time to other
> database in stude.
>
> someone help is welcome.

Without seeing your view and query definitions, it's hard to
say how to fix the problem. One possibility is to download
a Firebird 2 release candidate and see if the changes in the
optimizer for V2 allow it to handle your query. Other than
that, the choices are to emulate the query with a stored
procedure that breaks it into separate statements or to
simplify the query.


Regards,


Ann