Informix

Expand all | Collapse all

Version 14.10 bug

  • 1.  Version 14.10 bug

    Posted 24 days ago
    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 23 days ago
    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 23 days ago
    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 10 days ago
    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 10 days ago
    I am no aware of any interim patch scheduled before .FC2.

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