问题解决了。这是我读了MariaDB知识库后的最终代码。
CREATE OR REPLACE FUNCTION duedate (st_date DATE) RETURNS DATE RETURN (select max(a.col_date) FROM (select col_date from ref_calendar where holiday=0 and col_date>st_date limit 90) as a);
谢谢您!:)