Re: Synonym bug in 5.02?

Ben Kelley writes: |I have been having problems with a memory leakage bug in Informix 4.1 (For |SunOS 4.1.3, but the bug could be in other versions) where your sqlturbo |process gradually grows, until it gets to the point where you get a |"-208 Memory allocation failed during query processing" error message. | |You can demonstrate the bug by running the following pseudo program (with the |appropriate databases set up): | |while true do | open database 1 | select some data from table 1 | close database 1 | | open database 2 | select some data from table 2 | close database 2 |od We have experienced a similar problem when simply accessing data through a view in a different tbconfig(using ISTAR) on the same machine. Our version is 5.02.UC1, but it also happens on 5.01.UD3. This is on an HP-UX 9.0 machine. Our test program does the following : declare cur cursor for select * from db2@star2:v2 while true foreach cur into rec.* message num let num = num + 1 end foreach end while and the virtual memory space keeps growing till the program falls over with the same error as yours I would be very interested if you get any sort of reply from Informix on this one. Regards, Richard Ridley DHL Asia Pacific (rridley@sin-pss.dhl.com)