KSQL语法错误

java1234

om.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, now(),interval ^^0 month ), '%Y-中未找到需要的元素, 位置801期望是) at com.justep.exception.KSQLException.create(Unknown Source) at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source) at com.justep.system.ksql.token.TokenManager.match(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.localSqlFunctionExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.localSqlFunctionExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.conditionExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.whereExpression(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source) at com.justep.system.ksql.parser.QueryParser.start(Unknown Source) at com.justep.system.ksql.parser.QueryParser.start(Unknown Source) at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source) ... 35 more






这是ksql语句：SELECT Jc_cus_customermanager.*,Jc_cus_follow.Fol_Person as fol_Fol_Person,Jc_cus_follow.Fol_Date as fol_Fol_Date,Jc_cus_follow.Fol_Way as fol_Fol_Way,Jc_cus_follow.ActDetails as fol_ActDetails,Jc_cus_follow_comment.sCreateTime as com_sCreateTime,Jc_cus_follow_comment.sPersonName as com_sPersonName,Jc_cus_follow_comment.Remark as com_Remark  FROM Jc_cus_customermanager Jc_cus_customermanager  optional  join Jc_cus_follow Jc_cus_follow on Jc_cus_customermanager.Fol_Id = Jc_cus_follow optional  join Jc_cus_follow_comment Jc_cus_follow_comment on Jc_cus_follow.follow_lastID = Jc_cus_follow_comment WHERE ((Cus_Source='市场') AND (Jc_cus_customermanager.Cus_SourceSegments='公司') AND (         sql.date_format( Jc_cus_customermanager.fCreateTime, '%Y-%m' ) = sql.date_format(sql.date_sub( sql.now(),interval 0 month ), '%Y-%m')  )) LIMIT 0, 20

java1234

bex5还有人维护吗？？？？

badnjcf

你看一下,转成sql 的语句..是不是 interval 0 里面那个0被提出来当字符串了..跟我的问题一样..

java1234

badnjcf 发表于 2022-4-30 09:23
你看一下,转成sql 的语句..是不是 interval 0 里面那个0被提出来当字符串了..跟我的问题一样.. ...

那需要怎么弄？我用mysql的cast 函数把 0 强转成数字类型也还是报错

java1234

java1234 发表于 2022-5-6 11:01
那需要怎么弄？我用mysql的cast 函数把 0 强转成数字类型也还是报错

这bex5到底还有人维护不？一年交几千块的费用，1个问题7天没人回，

jishuang

SQL.用大写

如果比较复制的推荐直接写sql语句