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/01/15 07:55:42 UTC
[GitHub] [shardingsphere] wangwenzhao1 opened a new issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
wangwenzhao1 opened a new issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048
## Question
2021-01-15 15:48:32.414 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : Rule Type: sharding
2021-01-15 15:48:32.414 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : Logic SQL: SELECT u.* FROM user u WHERE
u.name=?
2021-01-15 15:48:32.414 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=user, alias=Optional.of(u))]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=user, quoteCharacter=NONE, schemaNameLength=0)], parametersIndex=1, logicSQL=SELECT u.* FROM user u WHERE
u.name=?)), containStar=true, firstSelectItemStartIndex=7, selectListStopIndex=9, groupByLastIndex=0, items=[StarSelectItem(owner=Optional.of(u))], groupByItems=[], orderByItems=[], limit=null, subqueryStatement=null, subqueryStatements=[], subqueryConditions=[])
2021-01-15 15:48:32.414 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : Actual SQL: ds0 ::: SELECT u.* FROM user_0 u WHERE
u.name=? ::: ["www"]
2021-01-15 15:48:32.414 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : Actual SQL: ds0 ::: SELECT u.* FROM user_1 u WHERE
u.name=? ::: ["www"]
2021-01-15 15:48:32.414 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : Actual SQL: ds0 ::: SELECT u.* FROM user_2 u WHERE
u.name=? ::: ["www"]
2021-01-15 15:48:32.414 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : Actual SQL: ds1 ::: SELECT u.* FROM user_0 u WHERE
u.name=? ::: ["www"]
2021-01-15 15:48:32.414 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : Actual SQL: ds1 ::: SELECT u.* FROM user_1 u WHERE
u.name=? ::: ["www"]
2021-01-15 15:48:32.415 INFO 300928 --- [nio-8084-exec-2] ShardingSphere-SQL : Actual SQL: ds1 ::: SELECT u.* FROM user_2 u WHERE
u.name=? ::: ["www"]
----------------------------------------------------------------
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] terrymanu commented on issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048#issuecomment-774611129
No response
----------------------------------------------------------------
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] wangwenzhao1 commented on issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
Posted by GitBox <gi...@apache.org>.
wangwenzhao1 commented on issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048#issuecomment-763456317
"" in the passed parameter causes
----------------------------------------------------------------
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] tristaZero commented on issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048#issuecomment-764210583
> "" in the passed parameter causes
Hi @wangwenzhao1 Sorry, I can catch you. Does that mean you locate the cause? Is it really a bug? That way, would you like to raise a PR to fix 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048#issuecomment-763334103
Hi,
These actual SQLs were correct but no data returned, didn't it? What's about other queries?
----------------------------------------------------------------
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] tristaZero edited a comment on issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048#issuecomment-764210583
> "" in the passed parameter causes
Hi @wangwenzhao1 Sorry, I can catch you. Does that mean you locate the cause? Is it really a bug? That way, would you like to raise a PR to fix it? Thanks.
Still, if you have no willing to fix it, we are grateful to have you show the cause here.
----------------------------------------------------------------
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] tristaZero edited a comment on issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048#issuecomment-764210583
> "" in the passed parameter causes
Hi @wangwenzhao1 Sorry, I can catch you. Does that mean you locate the cause? Is it really a bug? That way, would you like to raise a PR to fix it? Thanks.
Still, if you have no willing to fix it, we are grateful to have you show the cause here.
----------------------------------------------------------------
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] tristaZero commented on issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048#issuecomment-764210583
> "" in the passed parameter causes
Hi @wangwenzhao1 Sorry, I can catch you. Does that mean you locate the cause? Is it really a bug? That way, would you like to raise a PR to fix 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #9048: shardingsphere-jdbc Actual SQL execution results are incorrect (data should have been returned, but no data was returned)
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9048:
URL: https://github.com/apache/shardingsphere/issues/9048
----------------------------------------------------------------
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