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 Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.26 OS:
Assigned to: 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".