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/06/23 04:13:46 UTC
[GitHub] [shardingsphere] hongfuli opened a new issue, #18528: [ShardingSphere-Proxy] Missing return field
hongfuli opened a new issue, #18528:
URL: https://github.com/apache/shardingsphere/issues/18528
## Bug Report
`select VERSION(), @@sql_mode;`
### Which version of ShardingSphere did you use?
ShardingSphere-Proxy 5.1.2
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy 5.1.2
### Expected behavior
| 5.7.34 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
### Actual behavior
Only return the first field value:
5.7.34-ShardingSphere-Proxy 5.1.2
--
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] TeslaCN commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1171899344
@hongfuli Are you interested in fixing this?
--
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] hongfuli commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
hongfuli commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1171898937
Can this bug be fixed in 5.1.3?
--
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] hongfuli commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
hongfuli commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1171900436
I am familiar with the code before 5.0. Now because my company project is very busy, I haven't read the latest code for a long time, sorry
--
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] hongfuli commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
hongfuli commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1171317821
@TeslaCN
--
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] xuup commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
xuup commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1182852480
I'am interested in this issue , could you please assign this issue to me ?
--
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] hongfuli commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
hongfuli commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1169911311
Anyone help to fix this bug? :)
@tristaZero
--
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] terrymanu commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1164387907
Maybe something wrong with the implementation, does anyone want to investigate 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 commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1182854140
Hi @xuup
Welcome. Do you have any idea about this?
--
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] xuup commented on issue #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
xuup commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1196751707
> Hi @xuup Welcome. Do you have any idea about this?
Hi, I hava two thoughts on this issue.
1. redirect request to real database for execution, and get response from database.
2. @@sql_mode represent mode of database as mysql,
```
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
```
represent some modes supported by the database. I think the mode should be provided by ShardingSphere-Proxy better than database . So, Is it necessary to add the mode configuration supported by ShardingSphere ?
I wonder what you think about that。
--
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 #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #18528: [ShardingSphere-Proxy] Missing return field
URL: https://github.com/apache/shardingsphere/issues/18528
--
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 #18528: [ShardingSphere-Proxy] Missing return field
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #18528:
URL: https://github.com/apache/shardingsphere/issues/18528#issuecomment-1171326554
This issue is caused by the result of selecting a function is hardcoded.
https://github.com/apache/shardingsphere/blob/a3a0d3db8d419dd45cc1e0c33c64d7f81edc0655/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowVersionExecutor.java#L38-L53
--
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