Wed, 18 Jun 1902 08:00:00 GMT

InterBase 4.2 bug with left outer joins

Quote
> Does anyone have an idea why the following sql-statement gives wrong results
> under interbase, whilst it works just fine under ms-sql and sybase???

> select a.id id1,b.id id2,c.id id3
> from table1 a
> left outer join table1 b on (b.id=a.id and b.id<=50)
> left outer join table1 c on (c.id=a.id and c.id>50)

> output should be something like:

> ID1     ID2     ID3
> ====    ====    ====
> 1       1
> 50      50
> 100             100

I should have added that what Interbase really does is the following:

ID1     ID2     ID3
====    ====    ====
100             100

______________________________________________________\_______Brendan W. Breede
                                                       \
email: bren...@t-online.de                              \
faxmail: +49-421-2439806                                 \
voicemail: +49-421-2439883                                \
snailmail: Brucknerstr. 12; D-28359 Bremen                 \
PSION-SW: http://www.informatik.uni-bremen.de/~brendan/     \
_____________________________________________________________\_________________
[ Life is like a Ferrari: too fast - but so what, you can't afford it anyway! ]