RE: Informix Bug? 1206

Stick an update statistics for procedures at the end of your standard table update stats scripts Paul Watson # WF Software Ltd # If in doubt Tel: +44 1436 674729 # make it up Fax: +44 1436 678693 # www.wfsoftware.com # > -----Original Message----- > From: yener@my-deja.com [mailto:yener@my-deja.com] > Sent: Friday, August 25, 2000 7:02 AM > To: informix-list@iiug.org > Subject: Re: Informix Bug? 1206 > > > Art, > > It happenned again. When I try to update statistics for procedure, it > runs without giving an error. > > How can I prevent my system to give such nonsense errors. Update > statistics for all stored procedures daily basis? > > Thanks in advance. > > Yener. > > In article <3989B83F.EBE1ACD6@bloomberg.net>, > kagel@bloomberg.net wrote: > > Next time it happens try running UPDATE STATISTICS FOR > PROCEDURE ...; > > Sounds like something that the procedure accesses has been altered > > but the engine did not detect it and auto-update the query plan. It > > happens to some procedures and not others depending on the code the > > optimizer MAY or MAY NOT detect that the procedure needs to be > > recompiled. > > > > Art S. Kagel > > > > yener@my-deja.com wrote: > > > > > > I am experiencing an informix bug. I don't if it is a real bug. I > > > expected it to be a bug. Because, there is not definition of the > > > problem I experienced. > > > > > > Sometimes a stored procedures gives an error. Error 1206, But it > > > shouldn't give this error. > > > > > > During investigation of this error, I backup the original stored > > > procedure and re-created it using a differect name. When I run the > re- > > > created SPL, I saw that it is run successfully. Vow. Is > it possible > > > that a SPL under a different name is error free while as the > original > > > program gives an error. > > > > > > Then I drop and re-created the original program again by > using it's > > > original SPL name. What I have expected is occured. The re-created > > > program run without giving an error. > > > > > > Does anyone has ever heard a bug like that? Any solution? Idea? > > > > > > Regards, > > > > > > Yener > > > > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > > > > > Sent via Deja.com http://www.deja.com/ > Before you buy. > ********************************************************************** The contents of this e-mail are confidential to the ordinary user(S) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. **********************************************************************