我在做mysql自定义函数。我创建了新的函数代码,如下所示:
CREATE DEFINER=`root`@`%` FUNCTION `getNewLogicPassFailStatus`(Id varchar(20),subject1 varchar(520)) RETURNS INT
DETERMINISTIC
BEGIN
select MAX(writenscore) into @writtenscore from exam.marks WHERE Id =ID and subject = subject1;
return @writtenscore;
END
没有发现语法错误,但它给出的结果没有应用where子句。例外输出:11显示:48
但选择查询工作正常,没有如下功能
select MAX(writenscore) as max from exam.marks WHERE Id = 1 and subject = 'maths';
我甚至检查函数是否得到正确的参数。
暂无答案!
目前还没有任何答案,快来回答吧!