不匹配的输入“不”期望然后在阶段

Question

我在下面的查询中有一个错误。有人能建议。

select Defects_1.id,
case when Defects_1.status Not Like '4-Closed%' then (CURRENTDATE() - Defects_1.creation_time) As Defect_Age end
case when Defects_1.status Like '4-Closed%' then Defects_1.user_11as Defect_Age end
from Defects_1
Order By Defects_1.id

错误：

不匹配的输入“Not”然后在第2行第27列的阶段解析器中查询

Answer 1

我假设你有一些像Defects_1.closing_time这样的专栏，这就是你想要的-

select      Defects_1.id

           ,    case 
                    when Defects_1.status Not Like '4-Closed%' 
                    then CURRENTDATE()
                    else Defects_1.closing_time
                end 
            -   Defects_1.creation_time   As Defect_Age 

           ,case 

from        Defects_1

Order By    Defects_1.id

Answer 2

我想您打算用一个case语句：

select Defects_1.id,
       (case when Defects_1.status Not Like '4-Closed%'
             then (CURRENTDATE() - Defects_1.creation_time)
             when Defects_1.status Like '4-Closed%'
             then Defects_1.user_11
         end) as Defect_Age
from Defects_1
Order By Defects_1.id