Two days in, and I still can't find the cause of this 1064 error. - Source

Revision: 55566
User: Paul Dineen
Date: 2017-06-08 10:56

I have some DB experience, new to MariaDB. Writing a procedure, but always getting error 1064 iff I use a begin/end block. What am I missing?  This code, no problem:

<<code>>
delimiter //
create procedure do_easy ()
select category, leaf_match from reportDef
      where ignore_me = false and leaf_match is not null //
delimiter ;
<</code>>

But, this always gives the 1064 error, always saying "............. for the right syntax to use near '' at line 5"
<<code>>
delimiter //
create procedure do_notEasy ()
begin
select category, leaf_match from reportDef
      where ignore_me = false and leaf_match is not null;
end //
delimeter ;
<</code>>

All I did above was add the begin/end block.

Here's the actual code I'm having the problem with...

<<code>>
delimiter //

create procedure do_leafs ()
modifies sql data
begin 
  declare done boolean;
  declare cur_leafs cursor for
    select category, leaf_match from reportDef
      where ignore_me = false and leaf_match is not null;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
  open cur_leafs;
  done = false;

leafs: loop
  fetch cur_leafs into category, leaf_match;
  -- if done then
    -- leave leafs;
  end if;
  insert into report values (false, category,
    select sum(amount) from WFChkData where regexp_instr(description, leaf_regexp));
-- future: tag the matched wfchkdata rows
end loop;

close cur_leafs;

end //

delimeter ;
<</code>>

Thanks!

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Two days in, and I still can't find the cause of this 1064 error. - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB