版本：2.10.7到2.10.9 都是这样的情况
报错信息：SQL执行失败，请检查表、字段、关联关系等信息是否正确并重新编辑。exception while executing query: While executing SQL [SELECT “t0”.“measurement_date”, “t0”.“measurement_status_code”, “t2”.“description” AS “description1”, “t3”.“meter_name”, “t3”.“meter_number”, “t3”.“location”, CAST(“t0”.“facility_id” AS BIGINT) AS “facility_id1”
FROM (SELECT “measurement_type_id”, “measurement_date”, “measurement_status_code”, “facility_id”, “product_meter_id”
FROM “public”.“measurement”
WHERE FLOOR(extract(epoch from((TO_CHAR(“measurement_date”, ‘YYYY-MM-DD HH24:MI:SS’) - timestamp ‘1970-01-01 00:00:00’))) * 1000 - 0 ) >= 1746028800000 AND FLOOR(extract(epoch from((TO_CHAR(“measurement_date”, ‘YYYY-MM-DD HH24:MI:SS’) - timestamp ‘1970-01-01 00:00:00’))) * 1000 - 0 ) <= 1746115199000) AS “t0”
LEFT JOIN (SELECT “facility_id”
FROM “public”.“facility”) AS “t1” ON “t0”.“facility_id” = “t1”.“facility_id”
LEFT JOIN (SELECT “measurement_type_id”, “description”
FROM “public”.“measurement_type”) AS “t2” ON “t0”.“measurement_type_id” = “t2”.“measurement_type_id”
LEFT JOIN (SELECT “product_meter_id”, “meter_name”, “meter_number”, “location”
FROM “public”.“product_meter”) AS “t3” ON “t0”.“product_meter_id” = “t3”.“product_meter_id”
ORDER BY 7] on JDBC sub-schema [ERROR: operator does not exist: text - timestamp without time zone
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Position: 444]
DEException(code=40001, msg=SQL执行失败，请检查表、字段、关联关系等信息是否正确并重新编辑。exception while executing query: While executing SQL [SELECT “t0”.“measurement_date”, “t0”.“measurement_status_code”, “t2”.“description” AS “description1”, “t3”.“meter_name”, “t3”.“meter_number”, “t3”.“location”, CAST(“t0”.“facility_id” AS BIGINT) AS “facility_id1”
FROM (SELECT “measurement_type_id”, “measurement_date”, “measurement_status_code”, “facility_id”, “product_meter_id”
FROM “public”.“measurement”
WHERE FLOOR(extract(epoch from((TO_CHAR(“measurement_date”, ‘YYYY-MM-DD HH24:MI:SS’) - timestamp ‘1970-01-01 00:00:00’))) * 1000 - 0 ) >= 1746028800000 AND FLOOR(extract(epoch from((TO_CHAR(“measurement_date”, ‘YYYY-MM-DD HH24:MI:SS’) - timestamp ‘1970-01-01 00:00:00’))) * 1000 - 0 ) <= 1746115199000) AS “t0”
LEFT JOIN (SELECT “facility_id”
FROM “public”.“facility”) AS “t1” ON “t0”.“facility_id” = “t1”.“facility_id”
LEFT JOIN (SELECT “measurement_type_id”, “description”
FROM “public”.“measurement_type”) AS “t2” ON “t0”.“measurement_type_id” = “t2”.“measurement_type_id”
LEFT JOIN (SELECT “product_meter_id”, “meter_name”, “meter_number”, “location”
FROM “public”.“product_meter”) AS “t3” ON “t0”.“product_meter_id” = “t3”.“product_meter_id”
ORDER BY 7] on JDBC sub-schema [ERROR: operator does not exist: text - timestamp without time zone
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Position: 444])
at io.dataease.exception.DEException.throwException(DEException.java:38)
at io.dataease.datasource.provider.CalciteProvider.fetchResultField(CalciteProvider.java:195)
at io.dataease.chart.charts.impl.table.TableInfoHandler.calcChartResult(TableInfoHandler.java:129)
at io.dataease.chart.manage.ChartDataManage.calcData(ChartDataManage.java:421)
at io.dataease.chart.server.ChartDataServer.getData(ChartDataServer.java:89)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:102)
at io.dataease.share.interceptor.DeLinkAop.logAround(DeLinkAop.java:77)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:173)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
at io.dataease.chart.server.ChartDataServer$$SpringCGLIB$$0.getData()
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:255)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:188)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:926)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:831)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:590)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:195)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at io.dataease.filter.HtmlResourceFilter.doFilter(HtmlResourceFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at io.dataease.auth.filter.CommunityTokenFilter.doFilter(CommunityTokenFilter.java:67)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at io.dataease.license.config.LicSx.doFilter(w:146)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at io.dataease.auth.filter.TokenFilter.doFilter(TokenFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:389)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:1583)