KSQL嵌套查询BUG

garsonzhang

KSQL代码：

1. select FI_articleInfo,FI_articleInfo.fArticleName as fArticleName,customSub3.fInboundSum,customSub3.fOutboundSum
   
2.     from FI_articleInfo FI_articleInfo
   
3.     join ( select (SQL.IFNULL(customSub1.fArticleID, customSub2.fArticleID)) as fArticleID,(customSub1.fQuantity) as fInboundSum,(customSub2.fQuantity) as fOutboundSum from (select FI_articleMoveDetail.fArticleID as fArticleID, (SUM(FI_articleMoveDetail.fQuantity)) as fQuantity from FI_articleMove FI_articleMove
   
4.     join FI_articleMoveDetail FI_articleMoveDetail on FI_articleMove = FI_articleMoveDetail.fMainID
   
5.     where FI_articleMove.fType = '入库单'
   
6.     group by FI_articleMoveDetail.fArticleID) customSub1 optional
   
7.     join (select FI_articleMoveDetail.fArticleID as fArticleID, (SUM(FI_articleMoveDetail.fQuantity)) as fQuantity from FI_articleMove FI_articleMove
   
8.     join FI_articleMoveDetail FI_articleMoveDetail on FI_articleMove = FI_articleMoveDetail.fMainID where FI_articleMove.fType = '出库单'
   
9.     group by FI_articleMoveDetail.fArticleID) customSub2 on customSub1.fArticleID = customSub2.fArticleID ) customSub3 on FI_articleInfo=customSub3.fArticleID

复制代码

多层嵌套查询，测试也通过，保存以后再打开，报错代码错误，对比发现子语句的小括号被删掉了：

jishuang

ksql编辑器支持的有限，看看运行时是否正确

ksql中对于一些复杂的子查询是由问题的，如果允许是报错推荐用sql实现，或者到数据库中定义视图

garsonzhang

jishuang 发表于 2017-6-13 13:41
ksql编辑器支持的有限，看看运行时是否正确

ksql中对于一些复杂的子查询是由问题的，如果允许是报错推荐用 ...

收到

liufanx5

像你这么复杂的sql，还是写个视图把，然后用ksql去查

garsonzhang

liufanx5 发表于 2017-6-13 14:23
像你这么复杂的sql，还是写个视图把，然后用ksql去查

已经用视图解决了