Article View: borland.public.interbase.sql
Article #520Re: Using EXISTS in views crashed IB (6.0)??
From: Arjan de Haan
Date: Wed, 14 Nov 2007 13:11
Date: Wed, 14 Nov 2007 13:11
22 lines
1883 bytes
1883 bytes
"Arno Brinkman" <bnewsgroups @ REMOVE_ME abvisie.nl> wrote in message news:473abb2c@newsgroups.borland.com... > 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). Arno, thanks for the SQL, but it does not solve the problem. The server still crashes. In the mean time I searched QC, but couldn't find anything that makes this a known bug. It still is a bug, but I'll need to work around it for now, or have the client upgrade their installation. Tx. ...Arjan...
Technical Details
Message-ID:
<473af3ed$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<473a11f4@newsgroups.borland.com> <473abb2c@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,2745675ecdb62401 X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Arjan de Haan" <2x nospam nospam adwhaan AT hotpop.com> Newsgroups: borland.public.interbase.sql References: <473a11f4@newsgroups.borland.com> <473abb2c@newsgroups.borland.com> Subject: Re: Using EXISTS in views crashed IB (6.0)?? Date: Wed, 14 Nov 2007 14:11:10 +0100 Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-RFC2646: Format=Flowed; Response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 NNTP-Posting-Host: 77.61.105.250 Message-ID: <473af3ed$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1195045869 77.61.105.250 (14 Nov 2007 05:11:09 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail