在select 子语句中使用标量子查询执行查询正常，创建为视图执行报错

示例sql:
SELECT
ranking,
p.assignee_name,
work_month,
(
SELECT
median AS median
FROM
day_p AS day_p
WHERE
work_month = p.work_month) AS median_p
FROM
p_data AS p
GROUP BY
p.assignee_name,
p.work_month,
p.leave_days,
p.work_days