Re: Oracle vs Informix...

In <D6tqIH.FDr@zcias2.ziff.com> barry_roomberg@iacnet.com (Barry Roomberg) writes: > >In article <mswph.6.001852B1@SunBelt.Net>, mswph@SunBelt.Net says: >> >>help ! >>If you have any experience on RDBMS, please feel free to send me an email ! >> >>Q: What do you think about Informix, Oracle 7 and Sybase ? >> > >Having worked with Oracle since V5 (now on 7.1.4), and Informix (don't >know revs since it was blissfully short) I came to rhe following conclusion. > >Oracle's like a 63 Splitback Vette. Great performance, incredible control, >but a bit bumpy ride and takes a while to master. >out the outer join logic just is plain WRONG! I got Informix >support/engineering to admit this when we stepped through the logic of >what it was returning, and they promised a fast fix, but then found out >a bunch of customers were relying on the current behaviour, so they >ignored it. I hope I'm never forced to work with it again. > Can you please tell me how the outer join is flawed? I have an application that I just ported to Informix, and this would be a big problem that I need to be aware of. Thanks, Bill MacLean