Subject | Re: [ib-support] Ambiguous SQL :: Your Views Please |
---|---|
Author | Martijn Tonies |
Post date | 2001-08-26T08:56:10Z |
Hi,
I would say: reject it - throw an error in FB1. It's simply wrong...
In FB2 it would, why not now?
--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
Upscene Productions
http://www.upscene.com
"This is an object-oriented system.
If we change anything, the users object."
"Helen Borrie" <helebor@...> wrote in message
news:4.2.0.58.20010826183113.0252c700@......
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.
I would say: reject it - throw an error in FB1. It's simply wrong...
In FB2 it would, why not now?
--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
Upscene Productions
http://www.upscene.com
"This is an object-oriented system.
If we change anything, the users object."
"Helen Borrie" <helebor@...> wrote in message
news:4.2.0.58.20010826183113.0252c700@......
> 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/
>
>
>