Article View: borland.public.interbase.sql
Article #114Re: no current record for fetch operation mining explicit left joins and implicit inner joins
From: Bill Todd [TeamB]
Date: Fri, 06 Jun 2008 14:14
Date: Fri, 06 Jun 2008 14:14
27 lines
2390 bytes
2390 bytes
Massimiliano Trezzi wrote: > and now what are you going to do? > I think that if you won't fix it, I must know it. > I don't pretend you make a service pack for this, but knowing if > you'll resolve this for the next service pack or release, it's > important. I don't understand your question. Quinn Wildman, who is a CodeGear employee, already made the following reply earlier in this thread. "R&D has determined SQL with implicit and explicit joins is bad SQL and therefore is not supported." Therefore, if you are asking if InterBase will be changed to support SQL statements that include both implicit and explicit joins the answer is no. However, you replied to my post in which I said that IB should generate an error and not execute the query. If you are asking if the error message will be added in a future version the answer is that no one knows. If you want that to happen enter a bug report in QC indicating that an error should be returned when a statement includes both implicit and explicit joins and R&D will look at it when they begin fixing bugs in the next version. It is not likely that anyone will make a firm commitment now. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<48494656$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!feeder.ecngs.de!ecngs!feeder2.ecngs.de!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>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: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: no current record for fetch operation mining explicit left joins and implicit inner joins
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>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 63.147.41.232
Message-ID: <48494656$1@newsgroups.borland.com>
Date: 6 Jun 2008 07:14:46 -0700
X-Trace: newsgroups.borland.com 1212761686 63.147.41.232 (6 Jun 2008 07:14:46 -0700)
Lines: 27
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!feeder.ecngs.de!ecngs!feeder2.ecngs.de!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail