执行KSQL出错

sandgia

执行KSQL出错, KSQL: SELECT DEMANDPREQUALIFICATION_MASTER.*,case when DEMANDPREQUALIFICATION_MASTER.PROCESSSTATUS = 1 then '审批中' when DEMANDPREQUALIFICATION_MASTER.PROCESSSTATUS = 2 then '已完成' when DEMANDPREQUALIFICATION_MASTER.PROCESSSTATUS = 3 then '审批中（含回退）' when DEMANDPREQUALIFICATION_MASTER.PROCESSSTATUS = 4 then '已终止' when DEMANDPREQUALIFICATION_MASTER.PROCESSSTATUS = 0 then '未提交' else '其他' end  as processStatusName,DC_MASTER_COPY.PROCESSSTATUS as PROCESSSTATUS2,case when DC_MASTER_COPY.PROCESSSTATUS = 1 then '审批中' when DC_MASTER_COPY.PROCESSSTATUS = 2 then '已完成' when DC_MASTER_COPY.PROCESSSTATUS = 3 then '审批中（含回退）' when DC_MASTER_COPY.PROCESSSTATUS = 4 then '已终止' when DC_MASTER_COPY.PROCESSSTATUS = 0 then '未提交' else '其他' end  as confStatusName  FROM DEMANDPREQUALIFICATION_MASTER DEMANDPREQUALIFICATION_MASTER  optional  join DC_MASTER_COPY DC_MASTER_COPY on DEMANDPREQUALIFICATION_MASTER.FORMNO = DC_MASTER_COPY.DEMANDPREQUALIFICATIONNO WHERE ((1=1 and DEMANDPREQUALIFICATION_MASTER.FDELFLAG=1 ) AND (1=1  and DC_MASTER_COPY.PROCESSSTATUS in ('0','1','3','4') ) AND (1=1 and DEMANDPREQUALIFICATION_MASTER != 'DB70B24440C14A9FBD60FE2236C9BEAA'  and DEMANDPREQUALIFICATION_MASTER != 'DB70B24440C14A9FBD60FE2236C9BEAA'  and DEMANDPREQUALIFICATION_MASTER != 'DB70B24440C14A9FBD60FE2236C9BEAA'  and DEMANDPREQUALIFICATION_MASTER != 'DB70B24440C14A9FBD60FE2236C9BEAA'  and DEMANDPREQUALIFICATION_MASTER != '25ED98C1496E47D1AD6F3F6A60DE8049'  and DEMANDPREQUALIFICATION_MASTER != '25ED98C1496E47D1AD6F3F6A60DE8049'  and DEMANDPREQUALIFICATION_MASTER != '25ED98C1496E47D1AD6F3F6A60DE8049'  and DEMANDPREQUALIFICATION_MASTER != '97084E314482492E97E9768A11E5B72D'  and DEMANDPREQUALIFICATION_MASTER != '97084E314482492E97E9768A11E5B72D'  and DEMANDPREQUALIFICATION_MASTER != '25ED98C1496E47D1AD6F3F6A60DE8049'  and DEMANDPREQUALIFICATION_MASTER != 'C5F1BF5105634610A6734C8CC89BCC28'  and DEMANDPREQUALIFICATION_MASTER != 'C5F1BF5105634610A6734C8CC89BCC28'  and DEMANDPREQUALIFICATION_MASTER != 'C5F1BF5105634610A6734C8CC89BCC28' )) LIMIT 0, 20
--> sql:
--> binds: []
    at com.justep.exception.BusinessException.create(Unknown Source)
    at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    at com.justep.system.data.BizData.query(Unknown Source)
    at BizProcedure.query(BizProcedure.java:12)
    ... 26 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, ICATION_MASTER ^^!= 'DB70B24440C中未找到需要的元素, 位置1,102期望是)
    at com.justep.exception.KSQLException.create(Unknown Source)
    at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)

jishuang

ksql中的不等是<>不是!=