Re: -640 : QPlan sanity failure (2139.3).

Posted in 2003

Mark D. Stock — Mon, 15 Sep 2003 10:52:41 +0100 — source: Usenet: comp.databases.informix

Leonid Vorontsov wrote: > Hi All! > ------------------------- > C:\\INFORMIX>ver > Windows NT Version 4.0 > C:\\INFORMIX>onstat - > Informix Dynamic Server Version 7.31.TD6 -- On-Line -- Up 6 days > 22:23:23 -- > 1706560 Kbytes > C:\\INFORMIX> > ------------------------- > Attached script gives subj error. Any comments? Have you done what the error description suggests? Mind you, if I was a query optimiser, I think one look at your SQL, and I'd vomit as well. I'd have to check the manual to see if some of that is legal SQL, but I'm sure you've done that already. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list