db2level:v8.1 fixpack 4
在存储过程中,IF判断路径错误,2居然等于1,来看看吧:
CREATE PROCEDURE ptestif()
LANGUAGE SQL
BEGIN
DECLARE v_level integer DEFAULT 2;
IF v_level = 1 THEN
SIGNAL SQLSTATE '80001' SET MESSAGE_TEXT = '2 = 1? This Is A Bug!';
ELSEIF v_level IN (3, 2) THEN
END IF;
END
@
CALL ptestif@