X5.2.7.2665版本查询报错问题

合力行

使用起步人员给出的X5.2.7.2665版本测试原有系统，打开页面报错，报错信息如下：


  SELECT * FROM (SELECT  TOP 100 PERCENT  ROW_NUMBER() OVER( ORDER BY (SELECT 0) ) AS JUSTEP_RN__,   Kit.FID AS fId, Kit.VERSION AS version, Kit.FPCASEID AS fPCaseId, Kit.FBARCODE AS fBarcode, Kit.FCNNAME AS fCnname, Kit.FENNAME AS fEnname, Kit.FPCASENO AS fPCaseNo, Kit.FCONTRACTNO AS fContractNo, Kit.FANNEXNO AS fAnnexNo, Kit.FANNEXSERNO AS fAnnexSerNo, Kit.FSHIPBATCH AS fShipBatch, Kit.FPARTNO AS fPartNo, Kit.FQUALITYNO AS fQualityNo, Kit.FQTY AS fQty, Kit.FUNIT AS fUnit, Kit.FARCHIVEDATE AS fArchiveDate, Kit.FUSEDLIFE AS fUsedLife, Kit.FKITSTATE AS fKitState, Kit.FARCHIVELIFE AS fArchiveLife, Kit.FPRODUCTDATE AS fProductDate, Kit.FDESCRIPTION AS fDescription, Kit.FCREATEDATE AS fCreateDate, Kit.FEDITDATE AS fEditDate, Kit.FISDELETE AS fIsDelete, Kit.FISSHOW AS fIsShow, Kit.FSTATE AS fState, Kit.FREMARK AS fRemark, Kit.FSTATEROUTE AS fStateRoute, Kit.FCREATESITE AS fCreateSite, Kit.FCREATORCODE AS fCreatorCode, Kit.FEDITORCODE AS fEditorCode, Kit.FANNEXVERITEMMAPID AS fAnnexVerItemMapId, KitState_inspection.FINSPECTORCODE AS fInspectorCode, KitState_inspection.FINSPECTQTY AS fInspectQty, KitState_inspection.FINSPECTDATE AS fInspectDate, ContainerInfo.fID, RealShipItem.FREALSHIPBATCHID AS fRealShipBatchId, Kit.fID AS Kit FROM tabKit Kit LEFT JOIN tabKitState_inspection KitState_inspection ON  (KitState_inspection.FKITID = Kit.fID) AND (KitState_inspection.FISDELETE = ?)  LEFT JOIN tabPCaseInfo PCaseInfo ON  (Kit.FPCASEID = PCaseInfo.fID) AND (PCaseInfo.FISDELETE = ?)  LEFT JOIN tabContainerInfo ContainerInfo ON  (PCaseInfo.FCONTAINERID = ContainerInfo.fID) AND (ContainerInfo.FISDELETE = ?)  LEFT JOIN tabRealShipItem RealShipItem ON  ( (RealShipItem.FCASEID = PCaseInfo.fID) AND (RealShipItem.FISDELETE = ?) ) OR ( (RealShipItem.FCASEID = ContainerInfo.fID) AND (RealShipItem.FISDELETE = ?) )   WHERE  ( ( Kit.FKITSTATE IN (?, ?, ?, ?, ?) ) AND (Kit.FPCASEID <> ?) AND (Kit.FISDELETE = ?) ) AND (Kit.fID = ?) ) AS JUSTEP_TABLE__ WHERE JUSTEP_RN__ >= 1 AND JUSTEP_RN__<2, binds: [0, 0, 0, 0, 0, 3, 4, 5, 6, 7, experts_bring, 0, 5276B0E2581A4F4097AFED4B5C00B77A]出错


-----------------------------------------------------------------------------------------
执行KSQL出错, KSQL: SELECT Kit.*,KitState_inspection.fInspectorCode as fInspectorCode,KitState_inspection.fInspectQty as fInspectQty,KitState_inspection.fInspectDate as fInspectDate,ContainerInfo,RealShipItem.fRealShipBatchId as fRealShipBatchId  FROM Kit Kit  optional  join KitState_inspection KitState_inspection on  KitState_inspection.fKitId = Kit AND KitState_inspection.fIsDelete = 0  optional  join PCaseInfo PCaseInfo on  Kit.fPCaseId = PCaseInfo AND PCaseInfo.fIsDelete = 0  optional  join ContainerInfo ContainerInfo on  PCaseInfo.fContainerId = ContainerInfo AND ContainerInfo.fIsDelete = 0  optional  join RealShipItem RealShipItem on ( ( RealShipItem.fCaseId = PCaseInfo AND RealShipItem.fIsDelete = 0 ) OR ( RealShipItem.fCaseId = ContainerInfo AND RealShipItem.fIsDelete = 0 ) ) WHERE (Kit.fKitState in ('3', '4', '5', '6', '7')  AND Kit.fPCaseId <> 'experts_bring' AND Kit.fIsDelete = 0) AND ((Kit='90F107EE6ED64E619AF79D2962E96336')) LIMIT 0, 1
--> sql: SELECT * FROM (SELECT  TOP 100 PERCENT  ROW_NUMBER() OVER( ORDER BY (SELECT 0) ) AS JUSTEP_RN__,   Kit.FID AS fId, Kit.VERSION AS version, Kit.FPCASEID AS fPCaseId, Kit.FBARCODE AS fBarcode, Kit.FCNNAME AS fCnname, Kit.FENNAME AS fEnname, Kit.FPCASENO AS fPCaseNo, Kit.FCONTRACTNO AS fContractNo, Kit.FANNEXNO AS fAnnexNo, Kit.FANNEXSERNO AS fAnnexSerNo, Kit.FSHIPBATCH AS fShipBatch, Kit.FPARTNO AS fPartNo, Kit.FQUALITYNO AS fQualityNo, Kit.FQTY AS fQty, Kit.FUNIT AS fUnit, Kit.FARCHIVEDATE AS fArchiveDate, Kit.FUSEDLIFE AS fUsedLife, Kit.FKITSTATE AS fKitState, Kit.FARCHIVELIFE AS fArchiveLife, Kit.FPRODUCTDATE AS fProductDate, Kit.FDESCRIPTION AS fDescription, Kit.FCREATEDATE AS fCreateDate, Kit.FEDITDATE AS fEditDate, Kit.FISDELETE AS fIsDelete, Kit.FISSHOW AS fIsShow, Kit.FSTATE AS fState, Kit.FREMARK AS fRemark, Kit.FSTATEROUTE AS fStateRoute, Kit.FCREATESITE AS fCreateSite, Kit.FCREATORCODE AS fCreatorCode, Kit.FEDITORCODE AS fEditorCode, Kit.FANNEXVERITEMMAPID AS fAnnexVerItemMapId, KitState_inspection.FINSPECTORCODE AS fInspectorCode, KitState_inspection.FINSPECTQTY AS fInspectQty, KitState_inspection.FINSPECTDATE AS fInspectDate, ContainerInfo.fID, RealShipItem.FREALSHIPBATCHID AS fRealShipBatchId, Kit.fID AS Kit FROM tabKit Kit LEFT JOIN tabKitState_inspection KitState_inspection ON  (KitState_inspection.FKITID = Kit.fID) AND (KitState_inspection.FISDELETE = ?)  LEFT JOIN tabPCaseInfo PCaseInfo ON  (Kit.FPCASEID = PCaseInfo.fID) AND (PCaseInfo.FISDELETE = ?)  LEFT JOIN tabContainerInfo ContainerInfo ON  (PCaseInfo.FCONTAINERID = ContainerInfo.fID) AND (ContainerInfo.FISDELETE = ?)  LEFT JOIN tabRealShipItem RealShipItem ON  ( (RealShipItem.FCASEID = PCaseInfo.fID) AND (RealShipItem.FISDELETE = ?) ) OR ( (RealShipItem.FCASEID = ContainerInfo.fID) AND (RealShipItem.FISDELETE = ?) )   WHERE  ( ( Kit.FKITSTATE IN (?, ?, ?, ?, ?) ) AND (Kit.FPCASEID <> ?) AND (Kit.FISDELETE = ?) ) AND (Kit.fID = ?) ) AS JUSTEP_TABLE__ WHERE JUSTEP_RN__ >= 1 AND JUSTEP_RN__<2
--> binds: [0, 0, 0, 0, 0, 3, 4, 5, 6, 7, experts_bring, 0, 90F107EE6ED64E619AF79D2962E96336]

hecr

方式一：应用上将ksql改一下， 改后的结果如下：
KSQL: SELECT Kit.*,KitState_inspection.fInspectorCode as fInspectorCode,KitState_inspection.fInspectQty as fInspectQty,KitState_inspection.fInspectDate as fInspectDate,ContainerInfo as ContainerInfo1,RealShipItem.fRealShipBatchId as fRealShipBatchId  FROM Kit Kit  optional  join KitState_inspection KitState_inspection on  KitState_inspection.fKitId = Kit AND KitState_inspection.fIsDelete = 0  optional  join PCaseInfo PCaseInfo on  Kit.fPCaseId = PCaseInfo AND PCaseInfo.fIsDelete = 0  optional  join ContainerInfo ContainerInfo on  PCaseInfo.fContainerId = ContainerInfo AND ContainerInfo.fIsDelete = 0  optional  join RealShipItem RealShipItem on ( ( RealShipItem.fCaseId = PCaseInfo AND RealShipItem.fIsDelete = 0 ) OR ( RealShipItem.fCaseId = ContainerInfo AND RealShipItem.fIsDelete = 0 ) ) WHERE (Kit.fKitState in ('3', '4', '5', '6', '7')  AND Kit.fPCaseId <> 'experts_bring' AND Kit.fIsDelete = 0) AND ((Kit='90F107EE6ED64E619AF79D2962E96336')) LIMIT 0, 1
在ContainerInfo后加一个as；

方式二：后续版本平台找到方案会支持

合力行

hecr 发表于 2015-4-28 18:41
方式一：应用上将ksql改一下， 改后的结果如下：
KSQL: SELECT Kit.*,KitState_inspection.fInspectorCode  ...

还是会报错的

jishuang

合力行 发表于 2015-5-6 17:22
还是会报错的

看2楼黑色字体