是否为mysql(5.067) bug
版本为5.067
一运行类似下面的procedure,mysql就自动死掉
CREATE PROCEDURE `test`(IN v_ID VARCHAR(1))
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
declare v_id_1 varchar(10) default null;
if v_ID='1' then
set v_id_1 = 'HBR1M';
elseif v_ID='0' then
set v_id_1 = 'HBR24H';
elseif v_ID='3' then
set v_id_1 = 'HBR3M';
elseif v_ID='6' then
set v_id_1 = 'HBR6M';
elseif v_ID='a' then
set v_id_1 = 'LBR1M';
elseif v_ID='b' then
set v_id_1 = 'LBR3M';
elseif v_ID='D' then
set v_id_1 = 'PRMBEA';
elseif v_ID='C' then
set v_id_1 = 'PRMBOC';
elseif v_ID='8' then
set v_id_1 = 'PRMHKB';
elseif v_ID='f' then
set v_id_1 = 'UST10Y';
elseif v_ID='c' then
set v_id_1 = 'UST2Y';
elseif v_ID='g' then
set v_id_1 = 'UST30Y';
elseif v_ID='e' then
set v_id_1 = 'UST5Y';
end if;
select v_ID,v_id_1;
END;
也就是procedure中if elseif 过多
帮忙看看
谢谢哦