zhubidong created KYLIN-3502:
--------------------------------
Summary: When the parameter in the WHERE clause uses a function,
it runs the wrong
Key: KYLIN-3502
URL: https://issues.apache.org/jira/browse/KYLIN-3502
Project: Kylin
Issue Type: Bug
Components: Driver - JDBC, Query Engine
Affects Versions: v2.4.0
Reporter: zhubidong
I have a case, i want to statistics in one province or all province sales. If
the parameter value equal 0, then return the sales of all province, else return
the sales of the given province. The SQL as follow:
{code:java}
SELECT SUM(amount) AS amount
FROM t_sales
WHERE province_id = (case ? = 0 then province_id else ? end)
{code}
But the SQL run failure:
2018-08-17T14:41:04,740 INFO [Scheduler 400018082 FetcherRunner 550587289-53]
org.apache.kylin.job.impl.threadpool.DefaultScheduler - Job Fetcher: 0 should
running, 0 actual running, 0 stopped, 0 ready, 53 already succeed, 17 error, 0
discarded, 0 others
2018-08-17T14:41:09,677 INFO [http-bio-7070-exec-64]
org.apache.kylin.rest.service.QueryService - Check query permission in 0 ms.
2018-08-17T14:41:09,677 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.rest.service.QueryService - Using project: csljc
2018-08-17T14:41:09,677 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.rest.service.QueryService - The original query: SELECT
SUM(amount) AS amount
FROM t_sales
WHERE province_id = (CASE WHEN ? = 0 THEN province_id ELSE ? END)
2018-08-17T14:41:09,688 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.query.routing.QueryRouter - Find candidates by table t_sales
and project=csljc : CUBE[name=SALES_CUBE]
2018-08-17T14:41:09,688 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.query.routing.QueryRouter - Applying rule: class
org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
realizations before: [CUBE[name=SALES_CUBE]], realizations after:
[CUBE[name=SALES_CUBE]]
2018-08-17T14:41:09,688 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.query.routing.QueryRouter - Applying rule: class
org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
realizations before: [CUBE[name=SALES_CUBE]], realizations after:
[CUBE[name=SALES_CUBE]]
2018-08-17T14:41:09,688 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.query.routing.rules.RealizationSortRule -
CUBE[name=SALES_CUBE] priority 1 cost 630.
2018-08-17T14:41:09,688 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.query.routing.QueryRouter - Applying rule: class
org.apache.kylin.query.routing.rules.RealizationSortRule, realizations before:
[CUBE[name=SALES_CUBE]], realizations after: [CUBE[name=SALES_CUBE]]
2018-08-17T14:41:09,688 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.query.routing.QueryRouter - The realizations remaining:
[CUBE[name=SALES_CUBE]],and the final chosen one for current olap context 0 is
CUBE[name=SALES_CUBE]
2018-08-17T14:41:09,698 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.rest.service.QueryService - Setting current statement's max
rows to 0
2018-08-17T14:41:09,701 ERROR [Query
011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.rest.service.QueryService - Exception while executing query
java.sql.SQLException: exception while executing query: null
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
~[avatica-1.10.0.jar:2.4.0]
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
~[avatica-1.10.0.jar:2.4.0]
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:540)
~[avatica-1.10.0.jar:2.4.0]
at
org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:133)
~[avatica-1.10.0.jar:2.4.0]
at org.apache.kylin.rest.service.QueryService.execute(QueryService.java:809)
~[kylin-server-base-2.4.0.jar:2.4.0]
at
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:543)
~[kylin-server-base-2.4.0.jar:2.4.0]
at org.apache.kylin.rest.service.QueryService.query(QueryService.java:178)
~[kylin-server-base-2.4.0.jar:2.4.0]
at
org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:412)
[kylin-server-base-2.4.0.jar:2.4.0]
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:381)
[kylin-server-base-2.4.0.jar:2.4.0]
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:325)
[kylin-server-base-2.4.0.jar:2.4.0]
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:86)
[kylin-server-base-2.4.0.jar:2.4.0]
at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source) ~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_112]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_112]
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
[servlet-api.jar:?]
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
[servlet-api.jar:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[catalina.jar:7.0.85]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
[tomcat7-websocket.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[catalina.jar:7.0.85]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[catalina.jar:7.0.85]
at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
[cors-filter-2.5.jar:2.5]
at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
[cors-filter-2.5.jar:2.5]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
[catalina.jar:7.0.85]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
[catalina.jar:7.0.85]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
[catalina.jar:7.0.85]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
[catalina.jar:7.0.85]
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
[tomcat-coyote.jar:7.0.85]
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
[tomcat-coyote.jar:7.0.85]
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
[tomcat-coyote.jar:7.0.85]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[?:1.8.0_112]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[?:1.8.0_112]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[tomcat-coyote.jar:7.0.85]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_112]
Caused by: java.lang.NullPointerException
2018-08-17T14:41:09,702 INFO [Query 011fdeaa-2ef5-47c0-82e6-57f69d668446-11258]
org.apache.kylin.rest.service.QueryService -
==========================[QUERY]===============================
Query Id: 011fdeaa-2ef5-47c0-82e6-57f69d668446
SQL: SELECT SUM(amount) AS amount
FROM t_sales
WHERE province_id = (CASE WHEN ? = 0 THEN province_id ELSE ? END)
User: ADMIN
Success: false
Duration: 0.025
Project: csljc
Realization Names: [CUBE[name=SALES_CUBE]]
Cuboid Ids: []
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: exception while executing query: null
==========================[QUERY]===============================
2018-08-17T14:41:09,703 ERROR [http-bio-7070-exec-64]
org.apache.kylin.rest.controller.BasicController -
org.apache.kylin.rest.exception.InternalErrorException: exception while
executing query: null
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:393)
~[kylin-server-base-2.4.0.jar:2.4.0]
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:325)
~[kylin-server-base-2.4.0.jar:2.4.0]
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:86)
~[kylin-server-base-2.4.0.jar:2.4.0]
at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source) ~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_112]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_112]
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
~[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
~[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
~[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
~[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
~[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
~[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
[servlet-api.jar:?]
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
[spring-webmvc-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
[servlet-api.jar:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[catalina.jar:7.0.85]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
[tomcat7-websocket.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[catalina.jar:7.0.85]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
[spring-web-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[catalina.jar:7.0.85]
at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
[cors-filter-2.5.jar:2.5]
at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
[cors-filter-2.5.jar:2.5]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
[catalina.jar:7.0.85]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
[catalina.jar:7.0.85]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
[catalina.jar:7.0.85]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
[catalina.jar:7.0.85]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
[catalina.jar:7.0.85]
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
[tomcat-coyote.jar:7.0.85]
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
[tomcat-coyote.jar:7.0.85]
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
[tomcat-coyote.jar:7.0.85]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[?:1.8.0_112]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[?:1.8.0_112]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[tomcat-coyote.jar:7.0.85]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_112]
if don't use parameter, it run success:
{code:java}
SELECT SUM(amount) AS amount
FROM t_sales
WHERE province_id = (case 0 = 0 then province_id else 42 end){code}
if use a WITH clause, it also run success:
{code:java}
WITH tmp_sales AS
(SELECT province_id,
SUM(amount) AS amount
FROM t_sales
GROUP BY province_id)
SELECT sum(amount) AS amount
FROM tmp_sales
WHERE province_id = (CASE ? WHEN '0' THEN provincial_centre_id ELSE ?
END){code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
