Hi,

> 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

just

> 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

any

> 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.


Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81