Re: Oracle vs Informix...

Posted in 1995

Scott Ellard — 12 Apr 1995 07:22:36 GMT — source: Informix-list mailing list archive (1991-1998)

In article <1995Apr11.095822.1@orion.yorku.ca> as360114@orion.yorku.ca writes: >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. > >Informix is a Hyndai with power windows. You can dress it up, but it still >is trash. > >When working with Informix, I just LOVE when the manual states many of the >SQL standard call are not implemented. It's also real fun when you find >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. Would you care to clarify which SQL standard calls are not implemented and in what way the outer join logic is wrong? Scott