Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Version 14.10 bug

  • 1.  Version 14.10 bug

    Posted Wed July 31, 2019 09:20 AM
    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
    ------------------------------


  • 2.  RE: Version 14.10 bug

    Posted Thu August 01, 2019 10:15 AM
    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 myproc

    DBSCHEMA Schema Utility INFORMIX-SQL Version 14.10.FC1








    **
    Illegal SPL Routine Entry.

    Routine Name: myproc, Owner: informix
    Buffer Detail:


    ------------------------------
    SangGyu Jeong
    ------------------------------



  • 3.  RE: Version 14.10 bug

    Posted Thu August 01, 2019 10:59 AM
    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
    ------------------------------



  • 4.  RE: Version 14.10 bug

    Posted Wed August 14, 2019 10:26 AM
    No Patch Scheduled before FC2 ?

    ------------------------------
    [eric] [Verceletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]
    ------------------------------



  • 5.  RE: Version 14.10 bug

    Posted Wed August 14, 2019 12:26 PM
    I am no aware of any interim patch scheduled before .FC2.

    ------------------------------
    Art Kagel
    ------------------------------



  • 6.  RE: Version 14.10 bug

    Posted Tue September 17, 2019 10:36 AM
    ​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
    ------------------------------



  • 7.  RE: Version 14.10 bug

    Posted Tue September 17, 2019 10:45 AM
    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]
    ------------------------------



  • 8.  RE: Version 14.10 bug

    Posted Tue September 17, 2019 11:06 AM
    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
    ------------------------------



  • 9.  RE: Version 14.10 bug

    Posted Tue September 17, 2019 11:33 AM
    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


    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.