请问5.3.1的KSQL是否支持CASE ... WHEN ... THEN 的用法？

lsfbpc

麻烦问一下5.3.1的KSQL是否支持CASE ... WHEN .. THEN的用法？

select ZT_KHXX.*,ZT_ZYGWXX.fXM as fZYGWXM,ZT_FYXX.fFH as fFHMC,ZT_DYXX.fDYH as fDYHMC,ZT_LDXX.fLDMC as fLDMCMC,(CASE ZT_ZYGWXX.fGS WHEN 0 THEN '公司1' WHEN 1 THEN '公司2' ELSE ''  END) as fGSMC     from ZT_KHXX ZT_KHXX       optional  join ZT_ZYGWXX ZT_ZYGWXX on ZT_KHXX.fZYGW = ZT_ZYGWXX      optional  join ZT_FYXX ZT_FYXX on ZT_KHXX.fFH = ZT_FYXX      optional  join ZT_DYXX ZT_DYXX on ZT_FYXX.fDYID = ZT_DYXX      optional  join ZT_LDXX ZT_LDXX on ZT_DYXX.fLDID = ZT_LDXX     where ZT_KHXX.fFH is not null

这个KSQL报错：com.justep.design.model.ksql.KSQLException: 错误的表达式， 位置：112, 此时不应该有关键字：CASE

但是在mysql下是正常的：
select ZT_KHXX.*,ZT_ZYGWXX.fXM as fZYGWXM,ZT_FYXX.fFH as fFHMC,ZT_DYXX.fDYH as fDYHMC,ZT_LDXX.fLDMC as fLDMCMC,(CASE ZT_ZYGWXX.fGS WHEN 0 THEN '公司1' WHEN 1 THEN '公司2' ELSE ''  END) as fGSMC     from ZT_KHXX ZT_KHXX  left  join ZT_ZYGWXX ZT_ZYGWXX on ZT_KHXX.fZYGW = ZT_ZYGWXX.fID      left  join ZT_FYXX ZT_FYXX on ZT_KHXX.fFH = ZT_FYXX.fID     left  join ZT_DYXX ZT_DYXX on ZT_FYXX.fDYID = ZT_DYXX.fID        join ZT_LDXX ZT_LDXX on ZT_DYXX.fLDID = ZT_LDXX.fID     where ZT_KHXX.fFH is not null

搜到以前的一个帖子说是可以支持的http://bbs.wex5.com/forum.php?mod=viewthread&tid=50539

Masion

应该可以的
开发手册上有case when的示例
SELECT p, case when p.sCode = 'ogn' then '机构' when p.sCode = 'dpt' then '部门' else '其他' end AS type FROM SA_OPPerson p

Masion

你去掉括号试试看

clarence

多了括号，一定要去掉