Subject Re: [firebird-support] SELECT limitation with UNION/GROUP BY
Author Arno Brinkman

> I am trying to run a SELECT statement that UNIONS a number of reasonably
> complex VIEWS. This causes a nasty error that crashes the FB server (I
> updated from 1.03 to 1.5 RC5 in the vain hope that this would go away.)
> The error I am getting is "Unsuccessful execution caused by a system error
> that precludes successful execution of subsequent statements.
> internal gds software consistency check (missing pointer page in
> DPM_data_pages (243))."
> Does this mean anything to anybody?
> I believe that this is a system limitation as I can run the SELECT with
> 8 of the 9 UNIONs.

Looking at your metadata i think it exceeds the internal 255 limit.

Your view uses ((3 tables + 1 aggregate) * 5) + 4 unions = 24
Your main select ((24 + 1 for view self) * 9) + 8 unions = 233
1 select more and you exceed the 255.

Not that it should crash!
I don't think there's a workaround for this.

Thank you for the detailed report. I think i can reproduce this.

Arno Brinkman

Firebird links :

Nederlandse firebird nieuwsgroep :