Article View: borland.public.interbase.sql
Article #153Re: no current record for fetch operation mining explicit left joins and implicit inner joins
From: Massimiliano Trezzi
Date: Tue, 10 Jun 2008 13:09
Date: Tue, 10 Jun 2008 13:09
29 lines
2369 bytes
2369 bytes
Please let me know what R&D decide. And remember, again, that the syntax is correct in SQL-92. Hi. Massimiliano Trezzi. "Massimiliano Trezzi" <support_leavethis_@intesanet.it> ha scritto nel messaggio news:484a54b2$1@newsgroups.borland.com... > Hi, > it's me again! > > tell this to your bosses: > > the problem we have, is that we made a lot of projects with Oracle > Hyperion business untelligence suite (the old BrioQuery), and we developed > them on Interbase 5.6; now we migrated a lot of our customers to Interbase > 2007 and we discovered that these projects don't work because Hyperion > generate the queries with implicit joins for inner join and explicit joins > for outer ones. > I don't think I'm the only one with this problem and I don't think you > like have this defect and remember that this syntax is valid in SQL-92. > Maybe Oracle could change something in its product, but their database > works fine in this context and I think they don't mind of Interbase, > because, I repeat, this syntax is standard in SQL-92. > > Hi, > Massimiliano. >
Technical Details
Message-ID:
<484e7d1d@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!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> <4848ffb4$1@newsgroups.borland.com> <48494656$1@newsgroups.borland.com> <484960e0@newsgroups.borland.com> <48497398@newsgroups.borland.com> <484a54b2$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> <4848ffb4$1@newsgroups.borland.com> <48494656$1@newsgroups.borland.com> <484960e0@newsgroups.borland.com> <48497398@newsgroups.borland.com> <484a54b2$1@newsgroups.borland.com> Subject: Re: no current record for fetch operation mining explicit left joins and implicit inner joins Date: Tue, 10 Jun 2008 15:09:49 +0200 Lines: 31 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: 88.34.236.154 Message-ID: <484e7d1d@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1213103389 88.34.236.154 (10 Jun 2008 06:09:49 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail