Article View: borland.public.interbase.sql
Article #107Re: no current record for fetch operation mining explicit left joins and implicit inner joins
From: Massimiliano Trezzi
Date: Wed, 04 Jun 2008 08:17
Date: Wed, 04 Jun 2008 08:17
26 lines
1971 bytes
1971 bytes
Some "evidences": It's not a workaround, because I'm not sure that it always works, but most of the time I modify the from in this way it works: I put before the "inner joined tables" ordered by number of records descending, then I put the "outer joined tables" ordered by number of records descending chosing left or right join as required by the query itself. I think this can give you a great suggestion about the source of this problem Hi, Massimiliano "Bill Todd [TeamB]" <no@no.com> ha scritto nel messaggio news:483eb8db$1@newsgroups.borland.com... > Massimiliano Trezzi wrote: > >> This is not the result of an accurate design, but this is a bug: > > This is not a bug. A bug is something that does not work as designed. > The only thing that R&D should do in this case is generate an error and > not execute the query. > > -- > Bill Todd (TeamB)
Technical Details
Message-ID:
<48464fab@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<483d879c$1@newsgroups.borland.com> <483e198f$1@newsgroups.borland.com> <483e8221$1@newsgroups.borland.com> <483eb8db$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,c962a98f7a2cfe5f X-Google-Attributes: gid114a0e,domainid0,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Massimiliano Trezzi" <support_leavethis_@intesanet.it> Newsgroups: borland.public.interbase.sql References: <483d879c$1@newsgroups.borland.com> <483e198f$1@newsgroups.borland.com> <483e8221$1@newsgroups.borland.com> <483eb8db$1@newsgroups.borland.com> Subject: Re: no current record for fetch operation mining explicit left joins and implicit inner joins Date: Wed, 4 Jun 2008 10:17:46 +0200 Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 NNTP-Posting-Host: 88.34.236.154 Message-ID: <48464fab@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1212567467 88.34.236.154 (4 Jun 2008 01:17:47 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail