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.DEMANDPREQUALIFICATION_MASTER = 'DB70B24440C14A9FBD60FE2236C9BEAA'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = 'DB70B24440C14A9FBD60FE2236C9BEAA'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = 'DB70B24440C14A9FBD60FE2236C9BEAA'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = 'DB70B24440C14A9FBD60FE2236C9BEAA'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = '25ED98C1496E47D1AD6F3F6A60DE8049'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = '25ED98C1496E47D1AD6F3F6A60DE8049'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = '25ED98C1496E47D1AD6F3F6A60DE8049'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = '97084E314482492E97E9768A11E5B72D'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = '97084E314482492E97E9768A11E5B72D'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = '25ED98C1496E47D1AD6F3F6A60DE8049'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = 'C5F1BF5105634610A6734C8CC89BCC28'  and DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER = 'C5F1BF5105634610A6734C8CC89BCC28'  and DEMANDPREQUALIFICATION_MASTER.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.BusinessException: 编码: JUSTEP154038; 提示: DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER找不到对应的关系映射
    at com.justep.exception.BusinessException.create(Unknown Source)

奇怪了 DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER 就是主键，怎么找不到对应关系？

jishuang

主键就直接写DEMANDPREQUALIFICATION_MASTER，不用DEMANDPREQUALIFICATION_MASTER.DEMANDPREQUALIFICATION_MASTER
这个条件是怎么拼出来的？