Re: [Firebird-devel] who is correct

[Helen B. <he...@di...>]

At 09:30 AM 23-08-01 -0600, you wrote:
>Create table Company (uniqnum integer not nul,=20
>                       compname varchar(40),
>                       primary key (uniquenum))
>
>Create table Employee (uniqnum integer not nul,=20
>                        empno   integer not nul
>                        compname varchar(40),
>                        primary key (uniquenum,empno))=20
>
>Well, the displayed order by company name of
>
>select a.compname from company a , employee b=20
>   where a.compname =3D b.compname
>   and b.empno =3D :empno
>   order by compname
>
>ordering was fine with IB6
>
>Then I installed FB1..2b. and ordering result is random
>
>It turns out that old IB6 ordered by compname from=20
>Company and the new FB1 by compname of Employee.
>
>Of course order by a.company fixes it.
>
>Question, who is correct IB6 or FB2, or undefined ?


Undefined, I guess - both are "correct" in the sense that they behaved un=
predictably with an ambiguous query.  It's encouraging that their unpredi=
ctable behaviour produced different results.  Quite a big chunk of work h=
as been done in the DSQL area of Firebird by Claudio to tidy up some incr=
edibly buggy code there.

-- helen



All for Open and Open for All=20
InterBase Developer Initiative =B7 http://www.interbase2000.org
_______________________________________________________