You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "niklausmikaelson1002 (via GitHub)" <gi...@apache.org> on 2023/05/05 10:54:16 UTC
[GitHub] [shardingsphere] niklausmikaelson1002 opened a new issue, #25471: NullPointerException using shardingsphere-jdbc 5.1.1
niklausmikaelson1002 opened a new issue, #25471:
URL: https://github.com/apache/shardingsphere/issues/25471
## 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?
5.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
shardingsphere-jdbc
### Expected behavior
merge result and return
### Actual behavior
throw NullPointerException
![image](https://user-images.githubusercontent.com/8716969/236429843-2a041983-9be3-45db-ab52-5aa7e2bea19f.png)
### Reason analyze (If you can)
![image](https://user-images.githubusercontent.com/8716969/236429772-c0aa8d77-4b15-4a2b-b1d2-78d46c663bc6.png)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
when querying multiple tables contain group operation, neeed to merge result, then will invoke NullPointerException
### 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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #25471: NullPointerException using shardingsphere-jdbc 5.1.1
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #25471: NullPointerException using shardingsphere-jdbc 5.1.1
URL: https://github.com/apache/shardingsphere/issues/25471
--
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] FlyingZC commented on issue #25471: NullPointerException using shardingsphere-jdbc 5.1.1
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #25471:
URL: https://github.com/apache/shardingsphere/issues/25471#issuecomment-1539270882
@niklausmikaelson1002 The same with #23025,please try the latest version.
--
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] RaigorJiang commented on issue #25471: NullPointerException using shardingsphere-jdbc 5.1.1
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #25471:
URL: https://github.com/apache/shardingsphere/issues/25471#issuecomment-1536982520
Hi @niklausmikaelson1002
Can this problem be reproduced in the latest version 5.3.2? Please provide a reproducible SQL statement and configuration, thank you!
--
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] RaigorJiang commented on issue #25471: NullPointerException using shardingsphere-jdbc 5.1.1
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #25471:
URL: https://github.com/apache/shardingsphere/issues/25471#issuecomment-1581919595
Thank you! @FlyingZC
--
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] RaigorJiang commented on issue #25471: NullPointerException using shardingsphere-jdbc 5.1.1
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #25471:
URL: https://github.com/apache/shardingsphere/issues/25471#issuecomment-1537036800
Yes, you think it's easy, but it will take more time for someone else to prepare the environment.
The best way is that you provide reproducible statement and configuration, which saves time for contributors who investigate problems and resolves issues faster.
--
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] niklausmikaelson1002 commented on issue #25471: NullPointerException using shardingsphere-jdbc 5.1.1
Posted by "niklausmikaelson1002 (via GitHub)" <gi...@apache.org>.
niklausmikaelson1002 commented on issue #25471:
URL: https://github.com/apache/shardingsphere/issues/25471#issuecomment-1537063996
it's not about the environment or configuration yet, it's just a case, you
just need to verify sharding table with a group-by operation, when your
terms route to more than one table, then need to merge the result, as the
bugs report described I provide a snapshot.it's clear where the bug
happens. did you try it
Raigor ***@***.***> 于2023年5月6日周六 11:52写道:
> Yes, you think it's easy, but it will take more time for someone else to
> prepare the environment.
>
> The best way is that you provide reproducible statement and configuration,
> which saves time for contributors who investigate problems and resolves
> issues faster.
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/shardingsphere/issues/25471#issuecomment-1537036800>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/ACCQFKJIQRM5RN6H63MFRNLXEXDH7ANCNFSM6AAAAAAXW6RLZ4>
> .
> You are receiving this because you were mentioned.Message ID:
> ***@***.***>
>
--
Best Regards
Niklaus Mikaelson | 18664878092
--
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] niklausmikaelson1002 commented on issue #25471: NullPointerException using shardingsphere-jdbc 5.1.1
Posted by "niklausmikaelson1002 (via GitHub)" <gi...@apache.org>.
niklausmikaelson1002 commented on issue #25471:
URL: https://github.com/apache/shardingsphere/issues/25471#issuecomment-1537025429
I don't know if this exists in 5.3.2, cause 5.3.2 is still not public to
the maven repository, so it's hard for me to try 5.3.2, but this question
is easy, you just need to see when you perform a query with group-by
operation, and your sharding key route to more then one table, and bingo,
NullPointorException invokes. it's quite easy to replay that issue, just
try it.
Raigor ***@***.***> 于2023年5月6日周六 10:03写道:
> Hi @niklausmikaelson1002 <https://github.com/niklausmikaelson1002>
> Can this problem be reproduced in the latest version 5.3.2? Please provide
> a reproducible SQL statement and configuration, thank you!
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/shardingsphere/issues/25471#issuecomment-1536982520>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/ACCQFKPG3GTXSZYNL2RTQMDXEWWNJANCNFSM6AAAAAAXW6RLZ4>
> .
> You are receiving this because you were mentioned.Message ID:
> ***@***.***>
>
--
Best Regards
Niklaus Mikaelson | 18664878092
--
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