Outer Join Bug (was It's Incredible)

Hi Bob. I am not sure the exact nature of the Outer Join bug but under another thread recently (Oracle vs. Informix article 17644) it was stated and confirmed by two Informix users that under certain circumstances the Outer Join will exclude records which should appear in the result set. Since Outer Join semantics is not always clear I would be interested in getting further information about this problem, particularly from Informix. Hope this helps. Regards, Rich In article <3n454k$dr9@cssun.mathcs.emory.edu> inf_bb@hermes1.sps.mot.com (Bob Baskett) writes:>From: inf_bb@hermes1.sps.mot.com (Bob Baskett) >Subject: Re: It's incredible >Date: 19 Apr 1995 19:08:04 -0400 >ok guys, please enlighten the rest of us on the problem with the outer join >in informix! >> Hi Chris. I would be interested in any comments that anyone might have to your message. >} Clearly it opens up some major issues. The outer join problem is something >} that I was not aware of until the recent messages on this forum. I would agree>} with you that this is a major issue since it goes to the heart of the >} reliability of the engine. If answers "may be" correct I think there is a >} major problem. Since this problem has been confirmed by others in the forum I >} would also be interested in any Informix response to this issue. Regards, Rich The amazing OUTER JOIN bug is so serious that I can't believe people just take it in their stride. Someone said - it is core code & probably will never be fixed - b-locks - we pay a lot of money for SQl - fix it. I'm sorry but I have no simpathy INFORMIX shpuld sort out MAJOR problems like this !!!! I have wriiten 200,000 lines of INFORMIX code & half (estimate) of my time has been spent getting around INFORMIX 4GL & SQL bugs. >>Anyone had similar experience. Chris Richard Finkelstein, Performance Computing, Inc.