F1: BEGIN ATOMIC
DECLARE PRICE DECIMAL(14, 6) ;
IF WHSE_ID ='37010001' THEN
SET PRICE = (SELECT MIN(SUM_PLANBOD) FROM TEST_DAYS WHERE DATE1 = SEARCHDATE
AND TEST_DAYS.WHSE_ID = WHSE_ID);
END IF;
IF WHSE_ID ='37010002' THEN
SET PRICE = (SELECT SUM_PLANBOD FROM TEST_DAYS WHERE DATE1 = SEARCHDATE
AND TEST_DAYS.WHSE_ID = WHSE_ID);
END IF;
RETURN PRICE;
END
把参数输入'37010002' , '20050623' 每个id 一个日期对应一条记录
就出这个错误,可是根据参数查出来的只有一条记录这是怎么回事?
SQL0811N 标量全查询、SELECT INTO 语句或 VALUES INTO 语句的结果有多行。
SQLSTATE=21000