社区版2.10.19
在使用select的时候就会正常能跑出来，但是使用with a as （）的时候就会报错，报错为：SQL执行失败，请检查表、字段、关联关系等信息是否正确并重新编辑。Error while preparing statement [WITH list AS (SELECT batch_number, factory_area, shipment_locationname, audit_status, f_creator_user_id, COUNT(1) AS qty FROM i_bd_fc_data WHERE current_year = ‘2026’ AND current_week = ‘12’ AND audit_status NOT IN (‘3’, ‘-1’, ‘6’) AND f_delete_mark IS NULL GROUP BY batch_number, factory_area, audit_status, shipment_locationname, f_creator_user_id), pro_name AS (SELECT DISTINCT batch_number, current_processor_name FROM i_bd_fc_data_batch WHERE f_delete_mark IS NULL AND fc_week = ‘2026WK12’ AND audit_status NOT IN (‘3’, ‘-1’, ‘6’)) SELECT * FROM (SELECT a.batch_number, shipment_locationname, current_processor_name, f_creator_user_id, CASE WHEN CAST(audit_status AS VARCHAR) = ‘2’ THEN ‘在办’ WHEN CAST(audit_status AS VARCHAR) = ‘7’ THEN ‘待处理’ ELSE CAST(audit_status AS VARCHAR) END AS status, SUM(qty) AS qtys, COUNT(1) AS qty FROM list AS a LEFT JOIN pro_name AS b ON a.batch_number = b.batch_number GROUP BY a.batch_number, shipment_locationname, current_processor_name, CASE WHEN CAST(audit_status AS VARCHAR) = ‘2’ THEN ‘在办’ WHEN CAST(audit_status AS VARCHAR) = ‘7’ THEN ‘待处理’ ELSE CAST(audit_status AS VARCHAR) END, f_creator_user_id) tmp LIMIT 100 OFFSET 0] [Object ‘i_bd_fc_data’ not found]也没有说我不符合calcite语法规则
2026-03-25 09:17:48.902 ERROR — [nio-8100-exec-3] i.d.exception.GlobalExceptionHandler : Method[deExceptionHandler][SQL执行失败，请检查表、字段、关联关系等信息是否正确并重新编辑。Error while preparing statement [WITH list AS (SELECT batch_number, factory_area, shipment_locationname, audit_status, f_creator_user_id, COUNT(1) AS qty
FROM i_bd_fc_data
WHERE current_year = ‘2026’ AND current_week = ‘12’ AND audit_status NOT IN (‘3’, ‘-1’, ‘6’) AND f_delete_mark IS NULL
GROUP BY batch_number, factory_area, audit_status, shipment_locationname, f_creator_user_id), pro_name AS (SELECT DISTINCT batch_number, current_processor_name
FROM i_bd_fc_data_batch
WHERE f_delete_mark IS NULL AND fc_week = ‘2026WK12’ AND audit_status NOT IN (‘3’, ‘-1’, ‘6’)) SELECT * FROM (SELECT a.batch_number, shipment_locationname, current_processor_name, f_creator_user_id, CASE WHEN CAST(audit_status AS VARCHAR) = ‘2’ THEN ‘在办’ WHEN CAST(audit_status AS VARCHAR) = ‘7’ THEN ‘待处理’ ELSE CAST(audit_status AS VARCHAR) END AS status, SUM(qty) AS qtys, COUNT(1) AS qty
FROM list AS a
LEFT JOIN pro_name AS b ON a.batch_number = b.batch_number
GROUP BY a.batch_number, shipment_locationname, current_processor_name, CASE WHEN CAST(audit_status AS VARCHAR) = ‘2’ THEN ‘在办’ WHEN CAST(audit_status AS VARCHAR) = ‘7’ THEN ‘待处理’ ELSE CAST(audit_status AS VARCHAR) END, f_creator_user_id
OFFSET 0 ROWS
FETCH NEXT 100 ROWS ONLY) tmp LIMIT 100 OFFSET 0] [Object ‘i_bd_fc_data’ not found]]
io.dataease.exception.DEException: SQL执行失败，请检查表、字段、关联关系等信息是否正确并重新编辑。Error while preparing statement [WITH list AS (SELECT batch_number, factory_area, shipment_locationname, audit_status, f_creator_user_id, COUNT(1) AS qty
FROM i_bd_fc_data
WHERE current_year = ‘2026’ AND current_week = ‘12’ AND audit_status NOT IN (‘3’, ‘-1’, ‘6’) AND f_delete_mark IS NULL
GROUP BY batch_number, factory_area, audit_status, shipment_locationname, f_creator_user_id), pro_name AS (SELECT DISTINCT batch_number, current_processor_name
FROM i_bd_fc_data_batch
WHERE f_delete_mark IS NULL AND fc_week = ‘2026WK12’ AND audit_status NOT IN (‘3’, ‘-1’, ‘6’)) SELECT * FROM (SELECT a.batch_number, shipment_locationname, current_processor_name, f_creator_user_id, CASE WHEN CAST(audit_status AS VARCHAR) = ‘2’ THEN ‘在办’ WHEN CAST(audit_status AS VARCHAR) = ‘7’ THEN ‘待处理’ ELSE CAST(audit_status AS VARCHAR) END AS status, SUM(qty) AS qtys, COUNT(1) AS qty
FROM list AS a
LEFT JOIN pro_name AS b ON a.batch_number = b.batch_number
GROUP BY a.batch_number, shipment_locationname, current_processor_name, CASE WHEN CAST(audit_status AS VARCHAR) = ‘2’ THEN ‘在办’ WHEN CAST(audit_status AS VARCHAR) = ‘7’ THEN ‘待处理’ ELSE CAST(audit_status AS VARCHAR) END, f_creator_user_id
OFFSET 0 ROWS
FETCH NEXT 100 ROWS ONLY) tmp LIMIT 100 OFFSET 0] [Object ‘i_bd_fc_data’ not found]
at io.dataease.exception.DEException.throwException(DEException.java:38)
at io.dataease.dataset.manage.DatasetDataManage.previewSqlWithLog(DatasetDataManage.java:417)
at io.dataease.dataset.server.DatasetDataServer.previewSql(DatasetDataServer.java:38)
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:68)
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.LicSg.doFilter(a:131)
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.valves.RemoteIpValve.invoke(RemoteIpValve.java:731)
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)日志
单源支持的跨源不行
是自定义语法要使用两个源的嘛？
