12.10.FC11 GRIPE & WHINE

Posted in 2018

Topics: Installation, Setup & Upgrades, SQL Development & Query Writing, Stored Procedures & SPL, Server Administration

DAVID GROVE — Tue, 21 Aug 2018 23:23:35 — source: IIUG Forums & Mailing Lists

12.10.FC11 Solaris 10 1/13 We upgraded from FC3 to FC11. One of our SPLS broke as a result. Opened tech support case. Tech support informed us that a feature added in 12.10.XC6 causes some multi-table, ANSI notation JOINS to fail. Tech support supplied an ONCONFIG parameter (SQL_FEAT_CTRL2 0x0004) to disable this "feature". I think Informix upgrades should not break existing syntactically and semantically correct SQL. But, the worst thing is that IBM has had about 3 years to fix this defect (they themselves referred to it as a "defect"), but simply declined to do so. Existing, functioning, legal JOINs that suddenly fail, due to IBM's code modifications from several years back are unacceptable in this customer's eyes. DG

↪ replying to DAVID GROVE

JACQUES RENAUT — Wed, 22 Aug 2018 13:04:07 — source: IIUG Forums & Mailing Lists

Original post: 12.10.FC11 Solaris 10 1/13 We upgraded from FC3 to FC11. One of our SPLS broke as a result. Opened tech support case. Tech support informed us that a feature added in 12.10.XC6 causes some multi-table, ANSI notation JOINS to fail. Tech support supplied an ONCONFIG parameter (SQL_FEAT_CTRL2 0x0004) to disable this "feature". I think Informix upgrades should not break existing syntactically and semantically correct SQL. But, the worst thing is that IBM has had about 3 years to fix this defect (they themselves referred to it as a "defect"), but simply declined to do so. Existing, functioning, legal JOINs that suddenly fail, due to IBM's code modifications from several years back are unacceptable in this customer's eyes. DG Response: It is a defect and it will be corrected, but the defect was only discovered 2 weeks ago. Jacques Renaut HCL Informix Advanced Support

Glossary

onconfig