Subject | Re: [ib-support] Ambiguous SQL :: Your Views Please |
---|---|
Author | Andrew S. Vaz |
Post date | 2001-08-28T05:32:28Z |
Helen,
IMHO, it's an error. So, chop it off.
Andrew
contradictory, even, if you compare database versions.
The plan is to make it throw an error in Rls 2.
preference is to bite bullet and have it activated now.
IMHO, it's an error. So, chop it off.
Andrew
> Hi all Firebird users or intending usersHoogstraat):
>
> 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
>compname to order by and the results are somewhat unpredictable -
> 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
contradictory, even, if you compare database versions.
>as this will be detected. Currently, it simply causes a silent warning.
> In Firebird, Claudio has tidied up the dyn code so that an ambiguity such
The plan is to make it throw an error in Rls 2.
>an error, rather than a warning which is not detectable.
> However, there are voices in devel who would like to make even Rls 1 throw
>in your applications where you are using such ambiguous statements.
> The effect of the change - when it happens - will be to cause exceptions
>are for Rls 1, knowing that the axe will fall in Rls 2; or whether your
> What we'd like discussed is whether you want to keep things the way they
preference is to bite bullet and have it activated now.
>
> Thanks all,
> Helen
>
>
>
> All for Open and Open for All
> InterBase Developer Initiative � http://www.interbase2000.org
> _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>