Oninit cdi / Archive
Talk to an expert →

874: General exception error has occurred in the optimizer.

Posted in 2003

Topics: Performance & Tuning, SQL Development & Query Writing, Versions, Editions & End-of-Life

Wellidy Almeida — — source: Usenet: comp.databases.informix

Hi, I'm using IDS 9.21.UC3 and when I try to execute a statement SQL containing many joins i receive the error: 874: General exception error has occurred in the optimizer. I found in the Informix site that it is a bug fixed in 9.21.xC7, then it's my problem? This conclusion is right? There is patche to fix the bug without update the version of my IDS? tks

↪ replying to Wellidy Almeida
Art S. Kagel — — source: Usenet: comp.databases.informix

On Wed, 05 Nov 2003 12:44:37 -0500, Wellidy Almeida wrote: It certainly looks that way. Though there are major advantages to upgrading. Art S. Kagel > Hi, > > I'''m using IDS 9.21.UC3 and when I try to execute a statement SQL containing > many joins i receive the error: > > 874: General exception error has occurred in the optimizer.> > I found in the Informix site that it is a bug fixed in 9.21.xC7, then it'''s my > problem? > > This conclusion is right? There is patche to fix the bug without update the > version of my IDS? > > tks

Glossary