Version 14.10 bug
Art Kagel warned that CREATE OR REPLACE PROCEDURE/FUNCTION in 14.10.FC1 does not save source in the catalog, so dbschema errors on sysprocbody and myschema skips the routines; existing source gets wiped. Rainer von Bongartz lost procedures in a 12.10 migration. Fixed in 14.10.FC2, confirmed by Art, Eric Vercelletto and SangGyu Jeong.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
FYI: If anyone is installing version 14.10 for production or even testing purposes, DO NOT USE the new CREATE OR REPLACE PROCEDURE/FUNCTION feature in the 14.10.FC1 release! The procedures so installed will work correctly, however, their source code will not be saved in the database catalog and dbschema will get an error trying to access the sysprocbody table (myschema will not return an error but it will ignore those procedures and functions). It is my understanding that this bug will be fixed in the 14.10.FC2 release due out soon.
------------------------------
Art S. Kagel
------------------------------
#Informix
Wow, it's really dangerous. I thought it was a useful feature, but when I use it, the SPL code disappears altogether.
Thank you for informing us.
<example>
$ dbaccess stores_demo -Database selected.
> create procedure myproc ()> define a int;
> end procedure;
Routine created.
> create or replace procedure myproc ()
> define b int;
> end procedure;
Routine created.
$ dbschema -d stores_demo -f myprocDBSCHEMA Schema Utility INFORMIX-SQL Version 14.10.FC1
**
Illegal SPL Routine Entry.
Routine Name: myproc, Owner: informix
Buffer Detail:
------------------------------
SangGyu Jeong
------------------------------
Yes, even if the procedure's source was previously there in the database, it is wiped out. Found out the hard way when I was testing the new myschema feature to generate procedure and function definitions using CREATE OR REPLACE instead of just CREATE. I used it to generate code for every proc and func in one of my test database which included some datablade code. When I tested the generated script, all of the source was gone, including built-in procs and funcs! Obviously it is a high priority fix for 14.10.FC2 ------------------------------ Art Kagel ------------------------------
No Patch Scheduled before FC2 ? ------------------------------ [eric] [Verceletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] ------------------------------
I am no aware of any interim patch scheduled before .FC2. ------------------------------ Art Kagel ------------------------------
Please be Aware that this bug might influence the Migration from 12.10 to 14.10FC1 . We lost a couple of procedures during this Migration and had to re-create it afterwards ------------------------------ Rainer von Bongartz ------------------------------
Folks, 14.10 .xC2 has been released a few days ago. A friend has QA'ed successfully the fix of 'lost procedures' issue. I am not sure you can find it everywhere it should be ( Passport Advantage, Fix Central etc.. I have been told it was not there yet) but I know you can find it there http://bit.ly/ifmxdev ------------------------------ [eric] [Verceletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] ------------------------------
I downloaded Informix 14.10.FC2 from the IBM Software Access Catalog. In an environment running version 14.10, Informix should be patched as soon as possible. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Yes, I have tested it as well. I confirm that this bug is fixed in 14.10.FC2 Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ------Original Message------ Folks, 14.10 .xC2 has been released a few days ago. A friend has QA'ed successfully the fix of 'lost procedures' issue. I am not sure you can find it everywhere it should be ( Passport Advantage, Fix Central etc.. I have been told it was not there yet) but I know you can find it there http://bit.ly/ifmxdev ------------------------------ [eric] [Verceletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] ------------------------------ #Informix