Re: Outer Join Bug (was It's Incredible)
Posted in 1995
I too want to see what Informix says about the alleged outer join bug. I just returned from Tucson where I spent 3 days tweaking a PowerBuilder application that was running against a Watcom backend, but is now running against Online 5.0 There are a number of outer joins in the app, and they all returned the same thing in Informix that they did in Watcom, and both returned what I expected. I asked the guy who originally posted the message about the outer join bug to elaborate. He wrote back that he hadn't used Informix for 2 years. It's entirely possible that therer was a bug two years ago that isn't there now. I saw someone else (under the "Incredible" thread) say he had no problems with outer joins, and I saw another person say that his server crashed on certain outer joins. Crashing is bad, but incorrect result sets would be worse. Can anyone speak authoritatively on this (hint to the Informix people, please say something about this)? If there is a bug, I want to know about it, since it will be bad news for me, but I am wondering if there really is one or not. Thanks, Bill MacLean