KSQL编辑器查询结果和java里KSQL.select,查出来不一样

dh_n

相同的语句，在ksql编辑器中查询是有值的；java中用KSQL.select()查询会出现某列没有值，row输出来 是没有值的；如图
数据库查询也是有值的；<RowImpl state=NONE
[<column name=fMaterialSource, state=0, oldValue=null, newValue=采购>,
<column name=fMaterielCode, state=0, oldValue=null, newValue=010214010007>,
<column name=fReceivedNum, state=0, oldValue=null, newValue=0.0>,
<column name=fResourcesNO, state=0, oldValue=null, newValue=null>,
<column name=fPlanNum, state=0, oldValue=null, newValue=0.7>,
<column name=version, state=0, oldValue=null, newValue=0>,
<column name=fRemark, state=0, oldValue=null, newValue=null>,
<column name=AllotNumber, state=0, oldValue=null, newValue=null>,  这个字段 应该 是有值的
<column name=fRationNum, state=0, oldValue=null, newValue=0.7>,
<column name=ERP_MM_StockPlan_fEditionCode, state=0, oldValue=null, newValue=null>,
<column name=fResourcesType, state=0, oldValue=null, newValue=null>,
<column name=fAllow, state=0, oldValue=null, newValue=是>,
<column name=fAssignedNumber, state=0, oldValue=null, newValue=0.3129138>,
<column name=fEditionCode, state=0, oldValue=null, newValue=null>,
<column name=ERP_MM_StockPlan, state=0, oldValue=null, newValue=6d4498e6a73a434fbba968ff17bb5f9f>,
<column name=fProduceOrderID, state=0, oldValue=null, newValue=634f1229205548a8bea55b1c66729934>,
<column name=fNotDeliveryNum, state=0, oldValue=null, newValue=0.0>, <column name=fIsSubstituteMaterial, state=0, oldValue=null, newValue=否>]
>


图片是KSQL编辑器查出来的有值，row是KSQL.select()查出来的；语句是一样的。
为什么会出现这种情况?

jishuang

确认条件一下？下面的的值上面的都没有啊

dh_n

嗯嗯 就是这个问题，语句 是一样的；请远程一下，找不到问题。

jishuang

肯定有不一样的，确认数据库是同一个？

把运行时的sql语句打出来看看
http://bbs.wex5.com/forum.php?mo ... 33524&pid=165004035

dh_n

<RowImpl state=NONE
[<column name=fMaterialSource, state=0, oldValue=null, newValue=采购>, <column name=fMaterielCode, state=0, oldValue=null, newValue=010214010007>, <column name=fReceivedNum, state=0, oldValue=null, newValue=0.0>, <column name=fResourcesNO, state=0, oldValue=null, newValue=null>, <column name=fPlanNum, state=0, oldValue=null, newValue=0.7>, <column name=version, state=0, oldValue=null, newValue=0>, <column name=fRemark, state=0, oldValue=null, newValue=null>, <column name=AllotNumber, state=0, oldValue=null, newValue=null>, <column name=fRationNum, state=0, oldValue=null, newValue=0.7>, <column name=ERP_MM_StockPlan_fEditionCode, state=0, oldValue=null, newValue=null>, <column name=fResourcesType, state=0, oldValue=null, newValue=null>, <column name=fAllow, state=0, oldValue=null, newValue=是>, <column name=fAssignedNumber, state=0, oldValue=null, newValue=0.3129138>, <column name=fEditionCode, state=0, oldValue=null, newValue=null>, <column name=ERP_MM_StockPlan, state=0, oldValue=null, newValue=6d4498e6a73a434fbba968ff17bb5f9f>, <column name=fProduceOrderID, state=0, oldValue=null, newValue=634f1229205548a8bea55b1c66729934>, <column name=fNotDeliveryNum, state=0, oldValue=null, newValue=0.0>, <column name=fIsSubstituteMaterial, state=0, oldValue=null, newValue=否>]
>



下面是java里输出的row,图片是按链接输出的运行日志， 在数据库查出来的值
2018-05-21 14:46:13 [SQL Time]sql 执行时间：28ms, exec KSQL: select ERP_MM_StockPlan.*,ERP_MM_ResourceAllocation.fResourcesNO as fResourcesNO,ERP_MM_ResourceAllocation.fResourcesType as fResourcesType,ERP_MM_ResourceAllocation.fAllotNumber as AllotNumber,ERP_MM_ResourceAllocation.fEditionCode as fEditionCode  from ERP_MM_StockPlan ERP_MM_StockPlan  optional  join ERP_MM_ResourceAllocation ERP_MM_ResourceAllocation on ERP_MM_StockPlan.fProduceOrderID = ERP_MM_ResourceAllocation.fNeedNO AND ERP_MM_ResourceAllocation.fIsClose = '否' AND ERP_MM_StockPlan.fMaterielCode = ERP_MM_ResourceAllocation.fMaterielCode where ERP_MM_StockPlan.fProduceOrderID='634f1229205548a8bea55b1c66729934'  and ERP_MM_StockPlan.fMaterielCode='010214010007'
  --> sql:SELECT  ERP_MM_StockPlan.fID AS ERP_MM_StockPlan, ERP_MM_StockPlan.VERSION AS version, ERP_MM_StockPlan.FPRODUCEORDERID AS fProduceOrderID, ERP_MM_StockPlan.FMATERIALSOURCE AS fMaterialSource, ERP_MM_StockPlan.FMATERIELCODE AS fMaterielCode, ERP_MM_StockPlan.FRATIONNUM AS fRationNum, ERP_MM_StockPlan.FNOTDELIVERYNUM AS fNotDeliveryNum, ERP_MM_StockPlan.FRECEIVEDNUM AS fReceivedNum, ERP_MM_StockPlan.FISSUBSTITUTEMATERIAL AS fIsSubstituteMaterial, ERP_MM_StockPlan.FREMARK AS fRemark, ERP_MM_StockPlan.FASSIGNEDNUMBER AS fAssignedNumber, ERP_MM_StockPlan.FEDITIONCODE AS ERP_MM_StockPlan_fEditionCode, ERP_MM_StockPlan.FPLANNUM AS fPlanNum, ERP_MM_StockPlan.FALLOW AS fAllow, ERP_MM_ResourceAllocation.FRESOURCESNO AS fResourcesNO, ERP_MM_ResourceAllocation.FRESOURCESTYPE AS fResourcesType, ERP_MM_ResourceAllocation.FALLOTNUMBER AS AllotNumber, ERP_MM_ResourceAllocation.FEDITIONCODE AS fEditionCode FROM ERP_MM_STOCKPLAN ERP_MM_StockPlan LEFT JOIN ERP_MM_ResourceAllocation ERP_MM_ResourceAllocation ON  (ERP_MM_StockPlan.FPRODUCEORDERID = ERP_MM_ResourceAllocation.FNEEDNO) AND (ERP_MM_ResourceAllocation.FISCLOSE = ?) AND (ERP_MM_StockPlan.FMATERIELCODE = ERP_MM_ResourceAllocation.FMATERIELCODE)   WHERE  (ERP_MM_StockPlan.FPRODUCEORDERID = ?) AND (ERP_MM_StockPlan.FMATERIELCODE = ?)
--> binds:[否, 634f1229205548a8bea55b1c66729934, 010214010007]
<RowImpl state=NONE
[<column name=fMaterialSource, state=0, oldValue=null, newValue=采购>, <column name=fMaterielCode, state=0, oldValue=null, newValue=010214010007>, <column name=fReceivedNum, state=0, oldValue=null, newValue=0.0>, <column name=fResourcesNO, state=0, oldValue=null, newValue=null>, <column name=fPlanNum, state=0, oldValue=null, newValue=0.7>, <column name=version, state=0, oldValue=null, newValue=0>, <column name=fRemark, state=0, oldValue=null, newValue=null>, <column name=AllotNumber, state=0, oldValue=null, newValue=null>, <column name=fRationNum, state=0, oldValue=null, newValue=0.7>, <column name=ERP_MM_StockPlan_fEditionCode, state=0, oldValue=null, newValue=null>, <column name=fResourcesType, state=0, oldValue=null, newValue=null>, <column name=fAllow, state=0, oldValue=null, newValue=是>, <column name=fAssignedNumber, state=0, oldValue=null, newValue=0.3129138>, <column name=fEditionCode, state=0, oldValue=null, newValue=null>, <column name=ERP_MM_StockPlan, state=0, oldValue=null, newValue=6d4498e6a73a434fbba968ff17bb5f9f>, <column name=fProduceOrderID, state=0, oldValue=null, newValue=634f1229205548a8bea55b1c66729934>, <column name=fNotDeliveryNum, state=0, oldValue=null, newValue=0.0>, <column name=fIsSubstituteMaterial, state=0, oldValue=null, newValue=否>]
>

jishuang

数据源中看配置的数据库是你看的数据库吗

dh_n

是的，能远程一下？

jishuang

你好楼主，该问题准备远程。（待远程）

dh_n

请给出解决方案。

jishuang

请用数据库监控工具监控执行的sql，肯定是可以监控到的，仔细看监控的sql