KSQL不支持 ｉｓｎｕｕｌ函数

ssl

KSQL: select sum( ISNULL( b.fWCL,0) * ISNULL( b.fJXDJ,0) * ISNULL( b.fNDXS,0) ) as sjx from PM_XMYDBGZB a join PM_XMYDBGGSZB b on a = b.fXMYDBGID where a.fXMMC = 测图项目' and a.fSHZT <>''


Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL:  select sum( ISNULL( b.fWCL,0) * ISNULL( b.fJXDJ,0) * ISNULL( b.fNDXS,0) ) as sjx from PM_XMYDBGZB a join PM_XMYDBGGSZB b on a = b.fXMYDBGID where a.fXMMC = 航空测图项目' and a.fSHZT <>''
        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.KSQL.select(Unknown Source)
        at ProjectHighReportProcess.businessActivity1AfterAdvance(ProjectHighReportProcess.java:266)
        ... 37 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154020; 提示: 不支持KSQL函数ISNULL
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.fun.FunctionManager.getFunction(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.MathExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.MathExpressionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.FunctionNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectColumnNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectListNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
        ... 42 more


用的sqlserver数据库，在查询语句中不能处理为空的数据吗

jishuang

ksql中支持的函数如下



ksql中可以通过SQL.XX()调用数据库本地函数

ssl

jishuang 发表于 2015-4-29 14:14
ksql中支持的函数如下

以解决 ， 结贴

allpower

sql.isnull(fildname,'')
sql server 已经生效！

fengshuo

不支持KSQL函数ISNULL
在MYSQL里面也遇到同样的问题，就不能说说一个详细的解决方法吗？
搞的我们又反反复复的为同一个问题问来问去的