SELECT
count(
(CASE

WHEN
ca.jjrq =sysdate()
THEN
'X' ELSE NULL
END)
) exemptExpirationAmount
FROM
t_correct_archive ca
WHERE
ca.dr = 0
AND ca.DEPT_PK IN ( SELECT pk_id FROM sys_dept WHERE dr = 0 AND FIND_IN_SET (100, ancestors ) )

通过mycat执行上述sql报错，case中不能使用函数，会报 not support token:RPAREN，必须在表前面加 模式才可以