You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/06/23 03:01:54 UTC

[GitHub] [shardingsphere] zhengyunpengby opened a new issue #10929: 4.0.0-RC2 版本使用distinct DATE_FORMAT(settle_time, '%Y-%m-%d')报错

zhengyunpengby opened a new issue #10929:
URL: https://github.com/apache/shardingsphere/issues/10929


   ![image](https://user-images.githubusercontent.com/17721768/123028607-35ad9400-d412-11eb-8d0b-72f2fff8c083.png)
   DistinctQueryResult中的getColumnIndex返回结果为null导致后续QueryRow中hashCode()运行空指针异常


-- 
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:
users@infra.apache.org



[GitHub] [shardingsphere] strongduanmu commented on issue #10929: 4.0.0-RC2 版本使用distinct DATE_FORMAT(settle_time, '%Y-%m-%d')报错

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #10929:
URL: https://github.com/apache/shardingsphere/issues/10929#issuecomment-866646082


   @zhengyunpengby English only, other language will not be accept.


-- 
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:
users@infra.apache.org



[GitHub] [shardingsphere] zhengyunpengby commented on issue #10929: 4.0.0-RC2 版本使用distinct DATE_FORMAT(settle_time, '%Y-%m-%d')报错

Posted by GitBox <gi...@apache.org>.
zhengyunpengby commented on issue #10929:
URL: https://github.com/apache/shardingsphere/issues/10929#issuecomment-866484935


   异常信息:
   `Caused by: java.lang.NullPointerException: null
   	at org.apache.shardingsphere.core.execute.sql.execute.row.QueryRow$1.apply(QueryRow.java:82)
   	at org.apache.shardingsphere.core.execute.sql.execute.row.QueryRow$1.apply(QueryRow.java:78)
   	at com.google.common.collect.Lists$TransformingRandomAccessList$1.transform(Lists.java:616)
   	at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47)
   	at java.util.AbstractList.hashCode(AbstractList.java:540)
   	at org.apache.shardingsphere.core.execute.sql.execute.row.QueryRow.hashCode(QueryRow.java:84)
   	at java.util.HashMap.hash(HashMap.java:339)
   	at java.util.HashMap.put(HashMap.java:612)
   	at java.util.HashSet.add(HashSet.java:220)
   	at org.apache.shardingsphere.core.execute.sql.execute.result.DistinctQueryResult.fill(DistinctQueryResult.java:87)
   	at org.apache.shardingsphere.core.execute.sql.execute.result.DistinctQueryResult.getResultData(DistinctQueryResult.java:76)
   	at org.apache.shardingsphere.core.execute.sql.execute.result.DistinctQueryResult.<init>(DistinctQueryResult.java:63)
   	at org.apache.shardingsphere.core.merge.dql.DQLMergeEngine.getRealQueryResults(DQLMergeEngine.java:85)
   	at org.apache.shardingsphere.core.merge.dql.DQLMergeEngine.<init>(DQLMergeEngine.java:71)
   	at org.apache.shardingsphere.core.merge.MergeEngineFactory.newInstance(MergeEngineFactory.java:58)
   	at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.getResultSet(ShardingPreparedStatement.java:139)
   	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getFirstResultSet(DefaultResultSetHandler.java:235)
   	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:185)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
   	at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
   	at com.sun.proxy.$Proxy276.query(Unknown Source)
   	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
   	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
   	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
   	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
   	at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143)
   	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
   	at com.sun.proxy.$Proxy275.query(Unknown Source)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
   	... 23 common frames omitted`


-- 
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:
users@infra.apache.org



[GitHub] [shardingsphere] strongduanmu closed issue #10929: 4.0.0-RC2 版本使用distinct DATE_FORMAT(settle_time, '%Y-%m-%d')报错

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #10929:
URL: https://github.com/apache/shardingsphere/issues/10929


   


-- 
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:
users@infra.apache.org