Subject RE: [IBDI] Ambiguous SQL :: Your Views Please
Author Christian G├╝tter
Please change it now!

An error is an error and should
not be tolerated.


Cheers,

Christian


> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Sunday, August 26, 2001 9:47 AM
> To: ib-support@yahoogroups.com; ibdi@yahoogroups.com
> Subject: [IBDI] Ambiguous SQL :: Your Views Please
>
>
> Hi all Firebird users or intending users
>
> and
>
> HI DIANE <---- we could use your opinion here too!
>
> An old bug in IB has been tidied up. Here is an example
> (thanks, Hans Hoogstraat):
>
> select a.compname from company a , employee b
> where a.compname = b.compname
> and b.empno = :empno
> order by compname
>
> The ambiguity here is that the statement does not identify
> which table's compname to order by and the results are
> somewhat unpredictable - contradictory, even, if you compare
> database versions.
>
> In Firebird, Claudio has tidied up the dyn code so that an
> ambiguity such as this will be detected. Currently, it
> simply causes a silent warning. The plan is to make it throw
> an error in Rls 2.
>
> However, there are voices in devel who would like to make
> even Rls 1 throw an error, rather than a warning which is not
> detectable.
>
> The effect of the change - when it happens - will be to cause
> exceptions in your applications where you are using such
> ambiguous statements.
>
> What we'd like discussed is whether you want to keep things
> the way they are for Rls 1, knowing that the axe will fall in
> Rls 2; or whether your preference is to bite bullet and have
> it activated now.
>
> Thanks all,
> Helen