为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:win10,
【CPU】:
【问题描述】*:[IFNULL]附近出现错误[-2007]:
语法分析出错;
sql语句:SELECT
(
SELECT CONVERT
( IFNULL( sum( plan_working_hours ), 0 ), DECIMAL ( 10, 2 ) )
FROM
pm_project_plan
WHERE
is_delete = 0
AND project_id = ?
AND is_leaf_node = 1
) totalPlanHour,
(
SELECT CONVERT
( IFNULL( sum( plan_working_hours ), 0 ), DECIMAL ( 10, 2 ) )
FROM
pm_project_plan
WHERE
is_delete = 0
AND project_id = ?
AND is_leaf_node = 1
AND to_date ( plan_end_date ) < to_date ( NOW( ) )
) planfinishWorkLoad,
(
SELECT CONVERT
( IFNULL( sum( plan_working_hours * complete_percent / 100 ), 0 ), DECIMAL ( 10, 2 ) )
FROM
pm_project_plan
WHERE
is_delete = 0
AND project_id = ?
AND is_leaf_node = 1
) actualfinishWorkLoad
convert函数使用访问应该是CONVERT(类型说明,value),例如:CONVERT ( DECIMAL ( 10, 2 ),IFNULL( sum( plan_working_hours ), 0 ) )