{
"[]":{
"Moment":{
"@column":"userId;max(id):maxId",
"@group":"userId",
"@having":"maxId>=100"
},
"count":10
},
"ok":false,
"code":406,
"msg":"Moment:{ @having:value } 里的 value 中的第 0 个字符 'maxId>=100' 不合法!里面没有包含 SQL 函数!必须为 fun(col1,col2..)?val 格式!",
"debug:info|help":"浏览器打开以下链接查看解答\n\n【APIAuto】: \n http://apijson.cn/api?type=JSON&url=http%3A%2F%2Fapijson.cn%3A8080%2Fget&json=%7B%22%5B%5D%22%3A%7B%22Moment%22%3A%7B%22%40column%22%3A%22userId%3Bmax%28id%29%3AmaxId%22%2C%22%40group%22%3A%22userId%22%2C%22%40having%22%3A%22maxId%3E%3D100%22%7D%2C%22count%22%3A10%7D%7D \n\n【GitHub】: \n https://www.google.com/search?q=site%3Agithub.com%2FTencent%2FAPIJSON+++Moment%3A%7B+%40having%3Avalue+%7D+%E9%87%8C%E7%9A%84+value+%E4%B8%AD%E7%9A%84%E7%AC%AC+0+%E4%B8%AA%E5%AD%97%E7%AC%A6+%27maxId%3E%3D100%27+%E4%B8%8D%E5%90%88%E6%B3%95%EF%BC%81%E9%87%8C%E9%9D%A2%E6%B2%A1%E6%9C%89%E5%8C%85%E5%90%AB+SQL+%E5%87%BD%E6%95%B0%EF%BC%81%E5%BF%85%E9%A1%BB%E4%B8%BA+fun%28col1%2Ccol2..%29%3Fval+%E6%A0%BC%E5%BC%8F%EF%BC%81 \n\n【Google】:\n https://www.google.com/search?q=Moment%3A%7B+%40having%3Avalue+%7D+%E9%87%8C%E7%9A%84+value+%E4%B8%AD%E7%9A%84%E7%AC%AC+0+%E4%B8%AA%E5%AD%97%E7%AC%A6+%27maxId%3E%3D100%27+%E4%B8%8D%E5%90%88%E6%B3%95%EF%BC%81%E9%87%8C%E9%9D%A2%E6%B2%A1%E6%9C%89%E5%8C%85%E5%90%AB+SQL+%E5%87%BD%E6%95%B0%EF%BC%81%E5%BF%85%E9%A1%BB%E4%B8%BA+fun%28col1%2Ccol2..%29%3Fval+%E6%A0%BC%E5%BC%8F%EF%BC%81 \n\n【百度】:\n https://www.baidu.com/s?ie=UTF-8&wd=Moment%3A%7B+%40having%3Avalue+%7D+%E9%87%8C%E7%9A%84+value+%E4%B8%AD%E7%9A%84%E7%AC%AC+0+%E4%B8%AA%E5%AD%97%E7%AC%A6+%27maxId%3E%3D100%27+%E4%B8%8D%E5%90%88%E6%B3%95%EF%BC%81%E9%87%8C%E9%9D%A2%E6%B2%A1%E6%9C%89%E5%8C%85%E5%90%AB+SQL+%E5%87%BD%E6%95%B0%EF%BC%81%E5%BF%85%E9%A1%BB%E4%B8%BA+fun%28col1%2Ccol2..%29%3Fval+%E6%A0%BC%E5%BC%8F%EF%BC%81 \n\n都没找到答案?打开这个链接 \n https://github.com/Tencent/APIJSON/issues/new?assignees=&labels=&template=--bug.md \n然后提交问题,推荐用以下模板修改,注意要换行保持清晰可读。 \n【标题】:Moment:{ @having:value } 里的 value 中的第 0 个字符 'maxId>=100' 不合法!里面没有包含 SQL 函数!必须为 fun(col1,col2..)?val 格式! \n【内容】: **环境信息** \n 系统: Linux 5.10.134-17.2.al8.x86_64 \n 数据库: MYSQL \n JDK: 17.0.2 amd64 \n APIJSON: 8.0.2\n\n**问题描述**\nMoment:{ @having:value } 里的 value 中的第 0 个字符 'maxId>=100' 不合法!里面没有包含 SQL 函数!必须为 fun(col1,col2..)?val 格式! \n\n \n\nPOST http://apijson.cn:8080/get \n发送请求 Request JSON:\n ```js \n 请填写,例如 { \"Users\":{} } \n``` \n\n返回结果 Response JSON:\n ```js \n 请填写,例如 { \"Users\": {}, \"code\": 401, \"msg\": \"Users 不允许 UNKNOWN 用户的 GET 请求!\" } \n```",
"time":1762567600629,
"sql:generate|cache|execute|maxExecute":"0|0|0|2000",
"depth:count|max":"3|5",
"time:start|duration|end|parse|sql":"1762567600628|1|1762567600629|1|0",
"trace:throw":"java.lang.IllegalArgumentException",
"trace:stack":[
"apijson.orm.AbstractSQLConfig.newSQLConfig(AbstractSQLConfig.java:6051)",
"apijson.fastjson2.APIJSONSQLConfig.newSQLConfig(APIJSONSQLConfig.java:70)",
"apijson.demo.DemoObjectParser.newSQLConfig(DemoObjectParser.java:45)",
"apijson.demo.DemoObjectParser.newSQLConfig(DemoObjectParser.java:34)",
"apijson.orm.AbstractObjectParser.newSQLConfig(AbstractObjectParser.java:938)",
"apijson.orm.AbstractObjectParser.setSQLConfig(AbstractObjectParser.java:960)",
"apijson.orm.AbstractObjectParser.setSQLConfig(AbstractObjectParser.java:32)",
"apijson.orm.AbstractParser.onObjectParse(AbstractParser.java:1291)",
"apijson.orm.AbstractObjectParser.onChildParse(AbstractObjectParser.java:634)",
"apijson.orm.AbstractObjectParser.parse(AbstractObjectParser.java:294)",
"apijson.orm.AbstractObjectParser.parse(AbstractObjectParser.java:32)",
"apijson.orm.AbstractParser.onObjectParse(AbstractParser.java:1197)",
"apijson.orm.AbstractParser.onArrayParse(AbstractParser.java:1437)",
"apijson.orm.AbstractObjectParser.onChildParse(AbstractObjectParser.java:597)",
"apijson.orm.AbstractObjectParser.parse(AbstractObjectParser.java:294)",
"apijson.orm.AbstractObjectParser.parse(AbstractObjectParser.java:32)",
"apijson.orm.AbstractParser.onObjectParse(AbstractParser.java:1197)",
"apijson.orm.AbstractParser.parseResponse(AbstractParser.java:588)",
"apijson.framework.APIJSONParser.parseResponse(APIJSONParser.java:135)",
"apijson.demo.DemoParser.parseResponse(DemoParser.java:102)",
"apijson.demo.DemoParser.parseResponse(DemoParser.java:39)",
"apijson.orm.AbstractParser.parseResponse(AbstractParser.java:493)",
"apijson.boot.DemoController.openGet(DemoController.java:438)",
"jdk.internal.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)",
"java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)",
"java.base/java.lang.reflect.Method.invoke(Method.java:568)",
"org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:255)",
"org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:188)",
"org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)",
"org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:926)",
"org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:831)",
"org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)",
"org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)",
"org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)",
"org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)",
"org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)",
"jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)",
"org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)",
"jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)",
"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:206)",
"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)",
"org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)",
"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)",
"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)",
"org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)",
"org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)",
"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)",
"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)",
"org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)",
"org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)",
"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)",
"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)",
"org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)",
"org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)",
"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)",
"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)",
"org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)",
"org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)",
"org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)",
"org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)",
"org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)",
"org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)",
"org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)",
"org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391)",
"org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)",
"org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896)",
"org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1736)",
"org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)",
"org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)",
"org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)",
"org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)",
"java.base/java.lang.Thread.run(Thread.java:833)"
],
"@link":"http://apijson.cn:8080/api/index.html?send=false&redirect=false&type=JSON&decode=true&url=http%3A%2F%2Fapijson.cn%3A8080%2Fget&json=%7B%22%5B%5D%22%3A%7B%22count%22%3A10%2C%22Moment%22%3A%7B%22%40column%22%3A%22userId%3Bmax%28id%29%3AmaxId%22%2C%22%40group%22%3A%22userId%22%2C%22%40having%22%3A%22maxId%3E%3D100%22%7D%7D%7D"
}