It's incredible
Posted in 1995
Topics: SQL Development & Query Writing, Connectivity: ESQL/C, 4GL & Embedded SQL
I find it incredible that developers actually try to defend INFORMIX as if by some mixed up loyalty. Anyone that has developed (or tryed to) a major application in INFORMIX will tell you that they have been hit by bug after bug in the dev' sys', not to count the core bugs in the SQL engine. There was even a serious bug in the 4.0 SE engine that ment NULL values were not returned properly & required changing the table schemas to NON NULL The 4.1 release corrected this but did not mention it (keep it under the carpet boys). I spent weeks trying to correct this, thinking it was my fault, until I got 4.1 & the problem disappeared. INFORMIX is too far away from the user base. They have even got rid of most of there distributers. It would be nice if INFORMIX would at least list their products shortcomings or tell their customers of any serious known bugs. They dont do this & I can not forgive them for it. 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. Regards Chris "seize that engine" Moore