Bug #23712 a not working stored procedure in 5.0.26

• Submitted: 27 Oct 2006 12:25
• Modified: 28 Nov 2006 23:09
• Reporter: Dave Smits
• Status: No Feedback
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.26
• CPU Architecture: Any
• Tags: insert, stored procedure

[27 Oct 2006 12:25] Dave Smits

Description:
I got the stored procedure:

CREATE PROCEDURE wjAddWebTerm (var_webid int, var_term varchar(50)) 
BEGIN
  DECLARE var_result int;
  DECLARE var_new_webterm int;
  SELECT id into var_result from wmJellyWebTerm where webid = var_webid and value = var_term;

  IF not var_result is null THEN
    SELECT var_result;
  ELSE
    insert into wmJellyWebTerm (webid,value) values (var_webid,var_term);
    SET var_new_webterm = LAST_INSERT_ID();

    INSERT INTO wmJellyWebTermRelationGen (webterm,related_webterm,depth,path)
      VALUES (var_new_webterm,var_new_webterm,0,CONCAT('-',CAST(var_new_webterm AS char),'R-'));
    SELECT var_new_webterm as var_result;
  END IF;
END

in version 5.0.22 it works but in 5.0.26 it give a error with the if else construction

How to repeat:
Create this procedure

Suggested fix:
no idea

[28 Oct 2006 23:09] Hartmut Holzgraefe

can't reproduce, please provide a full working example (including CREATE TABLE statements for tables used in the procedure) and the exact error message

[29 Nov 2006 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".