🚀 go-pugleaf

Hi Arjan,

> We have an existing installation of IB Server 6 which I was updating to incorporate some new views. When testing I ran 
> across the following problem.
> I have a view, which results depend on the existing of matching data in another view, like this:
...

I'm not sure about the reason of the crash, but if it's due the PLAN try to use aliasses and see if that helps 
(workaround of course).

SELECT
  l.LocatieOID, l.Verwijderd, l.Naam, l.Tellergebruik,
  l.Tellersaan, k.KlantOID, k.Naam, a.Plaats
FROM
  Locaties l
  JOIN Klanten k ON (l.KlantOID = k.KlantOID)
  JOIN Adressen a ON (l.AdresOID = a.AdresOID)
WHERE
  (EXISTS (SELECT t.TijdelijkOID FROM Tijdelijk t
    WHERE t.LocatieOID = l.LocatieOID))
  OR
  (EXISTS (SELECT vla.LOCATIEOID FROM VIEWLOCAUTMCOUNT vla
    WHERE vla.LocatieOID = l.LocatieOID))

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Nederlandse firebird nieuwsgroep:
  news://newsgroups.firebirdsql.info

Firebird open source database with many powerful SQL features:
  http://www.firebirdsql.org
  http://www.firebirdsql.info

General database developer support:
  http://www.databasedevelopmentforum.com

Support list for Interbase and Firebird users:
  firebird-support@yahoogroups.com