我面临着一个奇怪的问题（我试图寻找以前的答案，但我找不到任何东西）。我创建了这个函数：

CREATE DEFINER=`root`@`localhost` FUNCTION `CALCULATEDATE`(caller VARCHAR(4)) RETURNS date
BEGIN
DECLARE cur_day INT(2);
DECLARE cur_time INT(2);
DECLARE calculated_date DATE;

IF caller = 'HOME' THEN
    SELECT DAY(CONVERT_TZ(NOW(),@@system_time_zone,'US/Pacific')) INTO cur_day; 
    SELECT HOUR(CONVERT_TZ(NOW(),@@system_time_zone,'US/Pacific')) INTO cur_time; 
    /*Case homepage */
    IF cur_day = DAY(NOW()) THEN
        IF cur_time < 7 THEN
            /*return yesterdays date */
            SET calculated_date = DATE_SUB(CURDATE(), INTERVAL 1 DAY);
        ELSE
            /*return todays date */
            SET calculated_date = CURDATE();
        END IF;
    ELSE
        SET calculated_date = DATE(CONVERT_TZ(NOW(),@@system_time_zone,'US/Pacific'));
    END IF;
ELSE
    /*Case newsletter */

    /*return todays date */
    SET calculated_date = CURDATE();
END IF;

RETURN calculated_date;
END

它返回一个日期（基于pst时间比较）。
我从以下视图调用此函数：

CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `root`@`localhost` 
    SQL SECURITY DEFINER
VIEW `dd_vwfeatured` AS
    (SELECT 
        `doms`.`id` AS `id`,
        `doms`.`name` AS `name`

    FROM
        `myelements` `doms`
    WHERE
        `doms`.`id` IN (SELECT 
                `d`.`domainid`
            FROM
                (`daily_featured_picks` `d`
                LEFT JOIN `daily_featured` `f` ON ((`d`.`featuredid` = `f`.`id`)))
            WHERE
                (`f`.`date` = CALCULATEDATE('NEWS')))
    ORDER BY `doms`.`name`)

如果从mysql查询调用该函数，那么该函数可以很好地工作，但是在一个视图中，我总是得到所有的记录。
你们能帮忙吗？
谢谢你，大卫