Change set 15876 bug in Mysql InsertInstanceState.sql

Nov 26, 2008 at 1:48 AM
Looks like there is a bug in the stored procedure where it is assigning a variable in an insert. I removed it and the script ran fine.

INSERT INTO INSTANCE_STATE
        (
          INSTANCE_ID ,STATE ,STATUS
          ,UNLOCKED ,BLOCKED ,INFO ,MODIFIED
          ,OWNER_ID ,OWNED_UNTIL ,NEXT_TIMER
        )
       /* INSTANCE_ID = p_INSTANCE_ID; This line should be removed */ 
        VALUES
        (
          p_INSTANCE_ID ,p_STATE ,p_STATUS
          ,p_UNLOCKED ,p_BLOCKED ,p_INFO ,l_NOW
          ,NULL ,NULL ,p_NEXT_TIMER
        );

Coordinator
Nov 26, 2008 at 9:54 AM
Hi rupurt,

Yup, definitely a bug, I'll get it fixed asap.

Cheers,

Dean