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 2022/10/10 06:32:43 UTC
[GitHub] [shardingsphere] FileNotFoundExcetion opened a new issue, #20555: NullPointException
FileNotFoundExcetion opened a new issue, #20555:
URL: https://github.com/apache/shardingsphere/issues/20555
DB type:MySQL
when i use limit paging，it would throw NPE exception.
Caused by: java.lang.NullPointerException
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.getValueCaseSensitiveFromTables(GroupByMemoryMergedResult.java:135)
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.getValueCaseSensitive(GroupByMemoryMergedResult.java:125)
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.init(GroupByMemoryMergedResult.java:73)
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.init(GroupByMemoryMergedResult.java:53)
at org.apache.shardingsphere.infra.merge.result.impl.memory.MemoryMergedResult.<init>(MemoryMergedResult.java:51)
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.<init>(GroupByMemoryMergedResult.java:56)
at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.getGroupByMergedResult(ShardingDQLResultMerger.java:118)
at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.build(ShardingDQLResultMerger.java:86)
at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.merge(ShardingDQLResultMerger.java:64)
at org.apache.shardingsphere.infra.merge.MergeEngine.executeMerge(MergeEngine.java:78)
at org.apache.shardingsphere.infra.merge.MergeEngine.merge(MergeEngine.java:67)
scene:
when the actual sql router one 1 table ,it's result is true.but when when it router 2 table ,it throw null pointException.
here is sql print
][ShardingSphere-SQL.log][SQLLogger.java:74 ] Logic SQL: SELECT IfNUll(sum(ams.order_amount), 0) totalOrderAmount,
ifNUll(sum(ams.order_count), 0) totalOrderCount,
ams.merchant_id merchantId,
ams.order_amount amount
FROM posx_direct_agent_mer_statistics ams
where
ams.agent_no_tree like CONCAT ('null','%')
and ams.trade_date between ? and ?
AND ams.agent_no = ?
group by ams.merchant_id
order by ams.order_amount desc
LIMIT ?,?
[posx-agent-gateway][2022-08-26 14:59:54,413][ INFO][main][][ShardingSphere-SQL.log][SQLLogger.java:74 ] SQLStatement: MySQLSelectStatement(table=Optional.empty, limit=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment@7294e45b], lock=Optional.empty, window=Optional.empty)
[posx-agent-gateway][2022-08-26 14:59:54,413][ INFO][main][][ShardingSphere-SQL.log][SQLLogger.java:74 ] Actual SQL: ss ::: SELECT IfNUll(sum(ams.order_amount), 0) totalOrderAmount,
ifNUll(sum(ams.order_count), 0) totalOrderCount,
ams.merchant_id merchantId,
ams.order_amount amount
FROM t_agent_mer_stat_202207 ams
where
ams.agent_no_tree like CONCAT ('null','%')
and ams.trade_date between ? and ?
AND ams.agent_no = ?
group by ams.merchant_id
order by ams.order_amount desc
LIMIT ?,? ::: [20220701, 20220831, 102916, 0, 2147483647]
[posx-agent-gateway][2022-08-26 14:59:54,414][ INFO][main][][ShardingSphere-SQL.log][SQLLogger.java:74 ] Actual SQL: ss ::: SELECT IfNUll(sum(ams.order_amount), 0) totalOrderAmount,
ifNUll(sum(ams.order_count), 0) totalOrderCount,
ams.merchant_id merchantId,
ams.order_amount amount
FROM t_agent_mer_stat_202208 ams
where
ams.agent_no_tree like CONCAT ('null','%')
and ams.trade_date between ? and ?
AND ams.agent_no = ?
group by ams.merchant_id
order by ams.order_amount desc
LIMIT ?,? ::: [20220701, 20220831, 102916, 0, 2147483647]
i don't know whether you can understand?
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #20555: NullPointException
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #20555:
URL: https://github.com/apache/shardingsphere/issues/20555#issuecomment-1230465489
Please change the title for search friendly
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #20555: NullPointException
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #20555:
URL: https://github.com/apache/shardingsphere/issues/20555#issuecomment-1364898776
Please try the 5.3.0. If the issue still exists, please help us reproduce it.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN closed issue #20555: NullPointException
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #20555: NullPointException
URL: https://github.com/apache/shardingsphere/issues/20555
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #20555: NullPointException
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20555:
URL: https://github.com/apache/shardingsphere/issues/20555#issuecomment-1272348707
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #20555: NullPointException
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20555: NullPointException
URL: https://github.com/apache/shardingsphere/issues/20555
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org