wszpwsren opened a new issue, #18385:
URL: https://github.com/apache/shardingsphere/issues/18385
## Bug Report
### Which version of ShardingSphere did you use?
5.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
sharding-JDBC
### Expected behavior
using "describe" as a column name
### Actual behavior
query like
`
Preparing: select hp.problem_id, hp.brand_id, hp.shop_id, hp.source,
hp.application_type, ks.km_shop_name as shop_name, ks.shop_image,
hp.create_user_phone, hp.content, hp.url, hp.like_num, hp.comment_num,
hp.describe, hp.is_show, hp.client_is_deleted, hp.audit_status, hp.create_time,
hp.create_user_id from help_problem hp left join km_shop ks on hp.brand_id =
ks.brand_id and hp.shop_id = ks.km_shop_id where hp.is_deleted = '0' and
hp.problem_id = ?
`
throw an exception
`
org.mybatis.spring.MyBatisSystemException: nested exception is
org.apache.ibatis.executor.ExecutorException: Error preparing statement.
Cause: com.google.common.util.concurrent.UncheckedExecutionException:
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an
error in your SQL syntax
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
~[mybatis-spring-2.0.7.jar!/:2.0.7]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
~[mybatis-spring-2.0.7.jar!/:2.0.7]
at com.sun.proxy.$Proxy277.selectOne(Unknown Source) ~[?:?]
at
org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
~[mybatis-spring-2.0.7.jar!/:2.0.7]
at
org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
~[mybatis-3.5.9.jar!/:3.5.9]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
~[mybatis-3.5.9.jar!/:3.5.9]
at com.sun.proxy.$Proxy389.getProblemDetailById(Unknown Source)
~[?:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_292]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_292]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_292]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
~[spring-tx-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at com.sun.proxy.$Proxy390.getProblemDetailById(Unknown Source)
~[?:?]
at
com.yangxu.ideaservice.service.help.impl.ProblemInfoServiceImpl.selProblemDetail(ProblemInfoServiceImpl.java:159)
~[classes!/:?]
at
com.yangxu.ideaservice.controller.help.ProblemInfoController.selProblemDetail(ProblemInfoController.java:53)
~[classes!/:?]
at
com.yangxu.ideaservice.controller.help.ProblemInfoController$$FastClassBySpringCGLIB$$1daa1f3b.invoke(<generated>)
~[classes!/:?]
at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
~[spring-core-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
com.nepxion.discovery.plugin.strategy.service.monitor.ServiceStrategyMonitorInterceptor.invoke(ServiceStrategyMonitorInterceptor.java:77)
~[discovery-plugin-strategy-starter-service-6.3.3.jar!/:?]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692)
~[spring-aop-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
com.yangxu.ideaservice.controller.help.ProblemInfoController$$EnhancerBySpringCGLIB$$ff9df77d.selProblemDetail(<generated>)
~[classes!/:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_292]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_292]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_292]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
~[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
~[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
~[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
~[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
~[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
~[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:665)
[javax.servlet-api-4.0.1.jar!/:4.0.1]
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
[spring-webmvc-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
[javax.servlet-api-4.0.1.jar!/:4.0.1]
at
io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:97)
[spring-boot-actuator-2.3.12.RELEASE.jar!/:2.3.12.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
[spring-web-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
at
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:111)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
[undertow-core-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
[undertow-core-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
[undertow-core-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
[undertow-core-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
[undertow-servlet-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.server.Connectors.executeRootHandler(Connectors.java:390)
[undertow-core-2.1.7.Final.jar!/:2.1.7.Final]
at
io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:836)
[undertow-core-2.1.7.Final.jar!/:2.1.7.Final]
at
org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
[jboss-threads-3.1.0.Final.jar!/:3.1.0.Final]
at
org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
[jboss-threads-3.1.0.Final.jar!/:3.1.0.Final]
at
org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
[jboss-threads-3.1.0.Final.jar!/:3.1.0.Final]
at
org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
[jboss-threads-3.1.0.Final.jar!/:3.1.0.Final]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
Caused by: org.apache.ibatis.executor.ExecutorException: Error preparing
statement. Cause:
com.google.common.util.concurrent.UncheckedExecutionException:
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an
error in your SQL syntax
at
org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:97)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
~[mybatis-3.5.9.jar!/:3.5.9]
at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_292]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
~[mybatis-spring-2.0.7.jar!/:2.0.7]
... 95 more
Caused by: com.google.common.util.concurrent.UncheckedExecutionException:
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an
error in your SQL syntax
at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2051)
~[guava-29.0-jre.jar!/:?]
at com.google.common.cache.LocalCache.get(LocalCache.java:3951)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4964)
~[guava-29.0-jre.jar!/:?]
at
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:47)
~[shardingsphere-infra-parser-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:58)
~[shardingsphere-infra-parser-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:180)
~[shardingsphere-jdbc-core-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:149)
~[shardingsphere-jdbc-core-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:80)
~[shardingsphere-jdbc-core-5.1.1.jar!/:5.1.1]
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_292]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
at
org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55)
~[mybatis-3.5.9.jar!/:3.5.9]
at com.sun.proxy.$Proxy614.prepareStatement(Unknown Source) ~[?:?]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
~[mybatis-3.5.9.jar!/:3.5.9]
at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_292]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
~[mybatis-spring-2.0.7.jar!/:2.0.7]
... 95 more
Caused by:
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an
error in your SQL syntax
at
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:65)
~[shardingsphere-sql-parser-engine-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.parse(SQLParserExecutor.java:46)
~[shardingsphere-sql-parser-engine-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.sql.parser.api.SQLParserEngine.parse(SQLParserEngine.java:47)
~[shardingsphere-sql-parser-engine-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:48)
~[shardingsphere-infra-parser-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:41)
~[shardingsphere-infra-parser-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:30)
~[shardingsphere-infra-parser-5.1.1.jar!/:5.1.1]
at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3529)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2278)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2155)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2045)
~[guava-29.0-jre.jar!/:?]
at com.google.common.cache.LocalCache.get(LocalCache.java:3951)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958)
~[guava-29.0-jre.jar!/:?]
at
com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4964)
~[guava-29.0-jre.jar!/:?]
at
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:47)
~[shardingsphere-infra-parser-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:58)
~[shardingsphere-infra-parser-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:180)
~[shardingsphere-jdbc-core-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:149)
~[shardingsphere-jdbc-core-5.1.1.jar!/:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:80)
~[shardingsphere-jdbc-core-5.1.1.jar!/:5.1.1]
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_292]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
at
org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55)
~[mybatis-3.5.9.jar!/:3.5.9]
at com.sun.proxy.$Proxy614.prepareStatement(Unknown Source) ~[?:?]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
~[mybatis-3.5.9.jar!/:3.5.9]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
~[mybatis-3.5.9.jar!/:3.5.9]
at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_292]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
~[mybatis-spring-2.0.7.jar!/:2.0.7]
... 95 more
`
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
