Re: On-Line 7.11UC1 bug (problem)

russell@oncontact.com (Russ Kahler) wrote: > >Just a warning. We have an application that uses the following logic. >begin work > create temp table b1 (f1 integer) with no log > insert into b1 values (1)>commit work >begin work > drop table b1 > create temp table b1 (f1 integer) with no log > insert into b1 values (2)>rollback work >select * from b1 >This select statement crashed with the error >(table b1 is not a defined table). >Informix admitted this to be a bug and we are waiting for the upgrade >to be finished. >If any one is interested I will mail out the problem number and bug number >as we recieve them. >Russ... > >Russell P. Kahler |||||/// ---------- >Internet: russell@oncontact.com ======== / Uh... >on!contact Software . | O O | /Just reboot >W67 N250A Evergreen Blvd | v_' / --> that will / >Cedarburg, WI 53012 # _| |_ fix it / >(414) 375-6555 (#) ( ) ---------- > # //|* *| > #//( * )/ > # ===== > # ( ) >Blah, Blah, Blah. # || || > .#---'| |----. > #----' ----- I had a similar problem where I had: select * from a_table into temp temp_table with no log select rowid, * from temp_table this would get an error -859, it works if you do: select * from a_table into temp temp_table select rowid, * from temp_table or if you do: select * from a_table into temp temp_table with no log select * from temp_table I never got around to calling Informix since I found a work around!! Javier Arroyo Automated Environments * Roseville, CA email 74734.162@compuserve.com fax 916-782-8557 phone 916-782-unix