Article View: borland.public.interbase.sql
Article #118Re: no current record for fetch operation mining explicit left joins and implicit inner joins
From: Massimiliano Trezzi
Date: Sat, 07 Jun 2008 08:48
Date: Sat, 07 Jun 2008 08:48
40 lines
2851 bytes
2851 bytes
Hi, Ok, suppose (only suppose) it's not a bug, is it a good thing? If you look all the thread you'll se I'm the only one who thinks so. I can't understand the last sentence: > There are too many move valuable things that R&D can spend time on to > invest their time in making IB support mixed mode joins. I translate it in my own spaghetti English: "We have so many things to work on that we cannot pay attention to this issue" Is it so? Hi, Massimiliano "Bill Todd [TeamB]" <no@no.com> ha scritto nel messaggio news:48497398@newsgroups.borland.com... > Massimiliano Trezzi wrote: > >> It's a bug and it's clear that it's not designed to be so. > > "As designed" means as designed by the software engineers responsible > for the product. It may not work the way you want it to and it may not > work the way the SQL standard says it should but, as Quinn stated, it > does work the way the R&D team intended. Therefore, this behavior is > not a bug. If you disagree with this please look in any dictionary of > software engineering terms for the definition of a bug. > > I certainly agree with you that IB should be changed so that SQL that > does not execute correctly either does not execute at all or that it > does execute correctly. I do disagree with you in that I think the best > fix for IB is to generate an error message and not execute the SQL. > There are too many move valuable things that R&D can spend time on to > invest their time in making IB support mixed mode joins. > > -- > Bill Todd (TeamB)
Technical Details
Message-ID:
<484a4b69@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!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>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> Subject: Re: no current record for fetch operation mining explicit left joins and implicit inner joins Date: Sat, 7 Jun 2008 10:48:40 +0200 Lines: 42 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: <484a4b69@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1212828521 88.34.236.154 (7 Jun 2008 01:48:41 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail X-Original-Bytes: 2688