注册

case when then条件中条件表达式比如1>2报错-2007

Jane 2023/06/13 868 6 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:Windows
【CPU】:
【问题描述】*:with tmp as

with tmp as ( select instance.id as id, rectime.complet_time as rec_complete_time, rectime.target_time as rec_target_time, rectime.start_time as rec_start_time, instance.close_time as close_time from simo_process_instance instance left join simo_itsm_blue_taskhandle task on instance.id = task.process_id left join simo_itsm_sla_slagamerectime rectime on instance.id = rectime.pro_instance_id where instance.freezed = 0 ) select * from tmp where 1=1 andcase when (1> 2) then (1 > 2) else (1<2) end)

执行失败(语句1)
-2007: 第 15 行, 第 47 列[>]附近出现错误:
语法分析出错

回答 0
暂无回答
扫一扫
联系客服