Re: Informix bug???

Posted in 1998

Arun Shastry — Thu, 17 Sep 1998 14:58:00 -0400 — source: Informix-list mailing list archive (1991-1998)

Alexander V.Didytch wrote: > Jonathan Leffler wrote: > > > It sounds like a bug, but we need to know a good deal more before > > deciding. For starters, which version of OnLine or SE are you using? > > On which platform? > > Be sure, its a bug -- we are using Informix 7.3TC3 on WinNt4.0 > > and the following script > > create procedure check () > returning char(20);> > define name char(20); > > let name = 'AAAAA'; > LET name = (SELECT name from code_table where code=1); > return name; > end procedure; > I'm wondering why this statement is structured this way. I've always used SELECT name INTO name FROM code_table WHERE code = 1; Is it possible that the above statement is trying put the status of the SELECT run in 'name' and the user is expecting the data from the table??? Arun > > <snip>