lafaso opened a new issue #8326:
URL: https://github.com/apache/shardingsphere/issues/8326
version:4.0.0-RC3
SQL:
select count(*) from asset
where 1=1 and yn = 1
<if test="guarantee != null and guarantee == 4">
AND (service_duration="" OR ISNULL(use_date) OR
ISNULL(service_duration))
</if>
exception info :
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.ClassCastException:
org.antlr.v4.runtime.tree.ErrorNodeImpl cannot be cast to
org.antlr.v4.runtime.ParserRuleContext
### The error may exist in URL
[jar:file:/Users/lizp/JDP/apache-tomcat-8.5.37/webapps/ROOT/WEB-INF/lib/dmall-asset-dao-1.0-SNAPSHOT.jar!/sqlmap/AssetMapper.xml]
### The error may involve assetMapper.countAsset-Inline
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM asset WHERE 1=1
and yn = ?
AND (service_duration="" OR ISNULL(use_date) OR
ISNULL(service_duration))
### Cause: java.lang.ClassCastException:
org.antlr.v4.runtime.tree.ErrorNodeImpl cannot be cast to
org.antlr.v4.runtime.ParserRuleContext
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)
~[mybatis-3.2.1.jar:3.2.1]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_161]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_161]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_161]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354)
~[mybatis-spring-1.2.0.jar:1.2.0]
... 60 common frames omitted
Caused by: java.lang.ClassCastException:
org.antlr.v4.runtime.tree.ErrorNodeImpl cannot be cast to
org.antlr.v4.runtime.ParserRuleContext
at
org.apache.shardingsphere.core.parse.core.extractor.impl.dml.PredicateExtractor.extractRecursiveWithParen(PredicateExtractor.java:83)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.core.extractor.impl.dml.PredicateExtractor.extractRecursiveWithLogicalOperation(PredicateExtractor.java:71)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.core.extractor.impl.dml.PredicateExtractor.extractRecursiveWithLogicalOperation(PredicateExtractor.java:74)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.core.extractor.impl.dml.PredicateExtractor.extractRecursiveWithLogicalOperation(PredicateExtractor.java:73)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.core.extractor.impl.dml.PredicateExtractor.extractRecursiveWithLogicalOperation(PredicateExtractor.java:73)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.core.extractor.impl.dml.PredicateExtractor.extract(PredicateExtractor.java:65)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.core.extractor.impl.dml.WhereExtractor.extract(WhereExtractor.java:48)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.core.extractor.SQLSegmentsExtractorEngine.extract(SQLSegmentsExtractorEngine.java:47)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.core.SQLParseKernel.parse(SQLParseKernel.java:62)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.SQLParseEngine.parse0(SQLParseEngine.java:71)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.parse.SQLParseEngine.parse(SQLParseEngine.java:53)
~[sharding-core-parse-common-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.route.router.sharding.ShardingRouter.parse(ShardingRouter.java:80)
~[sharding-core-route-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.route.PreparedStatementRoutingEngine.route(PreparedStatementRoutingEngine.java:61)
~[sharding-core-route-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.PreparedQueryShardingEngine.route(PreparedQueryShardingEngine.java:59)
~[sharding-core-entry-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.BaseShardingEngine.executeRoute(BaseShardingEngine.java:91)
~[sharding-core-entry-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.core.BaseShardingEngine.shard(BaseShardingEngine.java:74)
~[sharding-core-entry-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.shard(ShardingPreparedStatement.java:222)
~[sharding-jdbc-core-4.0.0-RC3.jar:4.0.0-RC3]
at
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:163)
~[sharding-jdbc-core-4.0.0-RC3.jar:4.0.0-RC3]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_161]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_161]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_161]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
at
org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:55)
~[mybatis-3.2.1.jar:3.2.1]
at com.sun.proxy.$Proxy42.execute(Unknown Source) ~[na:na]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
~[mybatis-3.2.1.jar:3.2.1]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
~[mybatis-3.2.1.jar:3.2.1]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
~[mybatis-3.2.1.jar:3.2.1]
... 67 common frames omitted
This is the first time I've used this framework，please give a hand！tks！
----------------------------------------------------------------
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]
