fanyetu opened a new issue #9778:
URL: https://github.com/apache/shardingsphere/issues/9778


   ## Bug Report
   
   **For English only**, other languages will not accept.
   
   Before report a bug, make sure you have:
   
   - Searched open and closed [GitHub 
issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere 
Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more 
details. 
   If no response anymore and we cannot reproduce it on current information, we 
will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   4.1.1
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   framework: ShardingSphere-JDBC
   database: Oracle
   
   ### Expected behavior
   I execute an SQL statement. It looks like this: 
   `insert into test(id, time) values (#{id}, SYSDATE)`
   
   ### Actual behavior
   Actually, i got an error
   `2021-03-23 11:20:09.428 ERROR [msc-perdep-busi,,,] 13400 --- 
[nio-8081-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() 
for servlet [dispatcherServlet] in context with path [] threw exception 
[Request processing failed; nested exception is 
org.mybatis.spring.MyBatisSystemException: nested exception is 
org.apache.ibatis.executor.ExecutorException: Error preparing statement.  
Cause: java.lang.ClassCastException: 
org.apache.shardingsphere.sql.parser.sql.segment.dml.column.ColumnSegment 
cannot be cast to 
org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment] 
with root cause
   
   java.lang.ClassCastException: 
org.apache.shardingsphere.sql.parser.sql.segment.dml.column.ColumnSegment 
cannot be cast to 
org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment
        at 
org.apache.shardingsphere.sql.parser.oracle.visitor.impl.OracleDMLVisitor.visitAssignmentValues(OracleDMLVisitor.java:170)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.sql.parser.oracle.visitor.impl.OracleDMLVisitor.visitAssignmentValues(OracleDMLVisitor.java:103)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser$AssignmentValuesContext.accept(OracleStatementParser.java:1658)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
 ~[antlr4-runtime-4.7.2.jar:4.7.2]
        at 
org.apache.shardingsphere.sql.parser.oracle.visitor.impl.OracleDMLVisitor.createInsertValuesSegments(OracleDMLVisitor.java:136)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.sql.parser.oracle.visitor.impl.OracleDMLVisitor.visitInsertValuesClause(OracleDMLVisitor.java:129)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.sql.parser.oracle.visitor.impl.OracleDMLVisitor.visitInsertValuesClause(OracleDMLVisitor.java:103)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser$InsertValuesClauseContext.accept(OracleStatementParser.java:1372)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
 ~[antlr4-runtime-4.7.2.jar:4.7.2]
        at 
org.apache.shardingsphere.sql.parser.oracle.visitor.impl.OracleDMLVisitor.visitInsert(OracleDMLVisitor.java:110)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.sql.parser.oracle.visitor.impl.OracleDMLVisitor.visitInsert(OracleDMLVisitor.java:103)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser$InsertContext.accept(OracleStatementParser.java:645)
 ~[shardingsphere-sql-parser-oracle-4.1.1.jar:4.1.1]
        at 
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
 ~[antlr4-runtime-4.7.2.jar:4.7.2]
        at 
org.apache.shardingsphere.sql.parser.SQLParserEngine.parse0(SQLParserEngine.java:80)
 ~[shardingsphere-sql-parser-engine-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.sql.parser.SQLParserEngine.parse(SQLParserEngine.java:61)
 ~[shardingsphere-sql-parser-engine-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.underlying.route.DataNodeRouter.createRouteContext(DataNodeRouter.java:97)
 ~[shardingsphere-route-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.underlying.route.DataNodeRouter.executeRoute(DataNodeRouter.java:89)
 ~[shardingsphere-route-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.underlying.route.DataNodeRouter.route(DataNodeRouter.java:76)
 ~[shardingsphere-route-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.underlying.pluggble.prepare.PreparedQueryPrepareEngine.route(PreparedQueryPrepareEngine.java:54)
 ~[shardingsphere-pluggable-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.executeRoute(BasePrepareEngine.java:96)
 ~[shardingsphere-pluggable-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.prepare(BasePrepareEngine.java:83)
 ~[shardingsphere-pluggable-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.MasterSlavePreparedStatement.<init>(MasterSlavePreparedStatement.java:65)
 ~[sharding-jdbc-core-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.MasterSlavePreparedStatement.<init>(MasterSlavePreparedStatement.java:49)
 ~[sharding-jdbc-core-4.1.1.jar:4.1.1]
        at 
org.apache.shardingsphere.shardingjdbc.jdbc.core.connection.MasterSlaveConnection.prepareStatement(MasterSlaveConnection.java:74)
 ~[sharding-jdbc-core-4.1.1.jar:4.1.1]
        at 
com.p6spy.engine.wrapper.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:118)
 ~[p6spy-3.9.0.jar:na]
        at 
org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
 ~[mybatis-3.5.6.jar:3.5.6]
        at 
org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
 ~[mybatis-3.5.6.jar:3.5.6]
        at 
org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
 ~[mybatis-3.5.6.jar:3.5.6]
        at 
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:94)
 ~[mybatis-plus-core-3.4.2.jar:3.4.2]
        at 
com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:55)
 ~[mybatis-plus-core-3.4.2.jar:3.4.2]
        at 
org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) 
~[mybatis-3.5.6.jar:3.5.6]
        at 
com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.update(MybatisCachingExecutor.java:85)
 ~[mybatis-plus-core-3.4.2.jar:3.4.2]
        at 
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
 ~[mybatis-3.5.6.jar:3.5.6]
        at 
org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
 ~[mybatis-3.5.6.jar:3.5.6]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[na:1.8.0_141]
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[na:1.8.0_141]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[na:1.8.0_141]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_141]
        at 
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
 ~[mybatis-spring-2.0.5.jar:2.0.5]
        at com.sun.proxy.$Proxy154.insert(Unknown Source) ~[na:na]
        at 
org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271) 
~[mybatis-spring-2.0.5.jar:2.0.5]
        at 
com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:60)
 ~[mybatis-plus-core-3.4.2.jar:3.4.2]
        at 
com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
 ~[mybatis-plus-core-3.4.2.jar:3.4.2]
        at 
com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
 ~[mybatis-plus-core-3.4.2.jar:3.4.2]
        at com.sun.proxy.$Proxy156.insertPerBusinessDetails(Unknown Source) 
~[na:na]
        at 
cn.cqgjj.common.common.service.impl.MyBaseService.doSavePerBusinessDetails(MyBaseService.java:1635)
 ~[classes/:na]
        at 
cn.cqgjj.perdep.service.freelancer.peracc.FreeLancerAccServiceImpl.doSave(FreeLancerAccServiceImpl.java:246)
 ~[classes/:na]
        at 
cn.cqgjj.perdep.service.freelancer.peracc.FreeLancerAccServiceImpl$$FastClassBySpringCGLIB$$1.invoke(<generated>)
 ~[classes/:na]
        at 
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) 
~[spring-core-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
 ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
 ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
 ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
 ~[spring-tx-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
 ~[spring-aop-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
cn.cqgjj.perdep.service.freelancer.peracc.FreeLancerAccServiceImpl$$EnhancerBySpringCGLIB$$1.doSave(<generated>)
 ~[classes/:na]
        at 
cn.cqgjj.perdep.controller.freelancer.peracc.FreeLancerAccController.save(FreeLancerAccController.java:161)
 ~[classes/:na]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[na:1.8.0_141]
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[na:1.8.0_141]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[na:1.8.0_141]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_141]
        at 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) 
~[tomcat-embed-core-9.0.41.jar:4.0.FR]
        at 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
 ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) 
~[tomcat-embed-core-9.0.41.jar:4.0.FR]
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) 
~[tomcat-embed-websocket-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at brave.servlet.TracingFilter.doFilter(TracingFilter.java:68) 
~[brave-instrumentation-servlet-5.12.7.jar:na]
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at brave.servlet.TracingFilter.doFilter(TracingFilter.java:87) 
~[brave-instrumentation-servlet-5.12.7.jar:na]
        at 
org.springframework.cloud.sleuth.instrument.web.LazyTracingFilter.doFilter(TraceWebServletAutoConfiguration.java:139)
 ~[spring-cloud-sleuth-core-2.2.6.RELEASE.jar:2.2.6.RELEASE]
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:109)
 ~[spring-boot-actuator-2.2.12.RELEASE.jar:2.2.12.RELEASE]
        at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
 ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
 ~[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:97)
 [tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:41002)
 [tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
 [tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) 
[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) 
[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
 [tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) 
[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) 
[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 [tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888)
 [tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
 [tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 
[tomcat-embed-core-9.0.41.jar:9.0.41]
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[na:1.8.0_141]
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[na:1.8.0_141]
        at 
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 [tomcat-embed-core-9.0.41.jar:9.0.41]
        at java.lang.Thread.run(Thread.java:748) [na:1.8.0_141]
   `
   
   ### Reason analyze (If you can)
   I'm tracking the code, and then I found out 
`OracleVisitor.visitSimpleExpr(line: 390)`. The `OracleVisitor` judged 
`SYSDATE` to be `ColumnNameContext`. I think it's a bug.
   
   ### 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.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to