Re: [Modeling-users] Double Result

[<Jer...@fi...>]

On Wednesday 30 July 2003 16:52, Sebastien Bigaret wrote:
>         Hi,
>
>   Good to know this fixed your problem. May I ask you to be a little
> more explicit about the version of mysql you use? --possibly off-list,
> if for any reasons you don't want to expose it publicly.
>
>   I'm asking this because I'm trying to know whether this should be
>   included in the core, or if I just need to add a warning (along w/ the
>   patch) for versions<x.y.z in the User's Guide (I cannot possibly have
>   all versions of mysql installed here to test ;). Moreover, I would
>   like to ask you to try some sample sql statements on your db, if
>   possible, against the tests databases (author_books and
>   store_employees).
>
>      Thanks in advance,
>
> - S=E9bastien.
>


Hum i'm quite sure that it isn't a MySQL bug .. but a SQL one .=20
This kind of 'too much result' usually occur while using a wrong
'LEFT OUTER JOIN' or 'GROUP' directive . Pay caution that=20

select * from t1 left outer join t2 on t1.ID =3D=3D t2.FK_t1 is different=20
from=20
select * from t2 left outer join t1 on t1.ID =3D=3D t2.FK_t1.=20
Even thought you will get the same kind of result.=20


Bye bye ..=20