执行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 not in ('DB70B24440C14A9FBD60FE2236C9BEAA','DB70B24440C14A9FBD60FE2236C9BEAA','DB70B24440C14A9FBD60FE2236C9BEAA','DB70B24440C14A9FBD60FE2236C9BEAA','25ED98C1496E47D1AD6F3F6A60DE8049','25ED98C1496E47D1AD6F3F6A60DE8049','25ED98C1496E47D1AD6F3F6A60DE8049','97084E314482492E97E9768A11E5B72D','97084E314482492E97E9768A11E5B72D','25ED98C1496E47D1AD6F3F6A60DE8049','C5F1BF5105634610A6734C8CC89BCC28','C5F1BF5105634610A6734C8CC89BCC28','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 ^^not in ('DB70B2中未找到需要的元素, 位置1,102期望是)
    at com.justep.exception.KSQLException.create(Unknown Source)
    at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
    at com.justep.system.ksql.token.TokenManager.match(Unknown Source)

jishuang

http://docs.wex5.com/bex5-server-question-list-10020/

sandgia

jishuang 发表于 2019-8-19 09:10
http://docs.wex5.com/bex5-server-question-list-10020/

结帖