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/09 04:48:13 UTC
[GitHub] [shardingsphere] bojiw opened a new issue, #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
bojiw opened a new issue, #20559:
URL: https://github.com/apache/shardingsphere/issues/20559
execute sql DELETE FROM groups WHERE `id` = 1368 error
messageļ¼Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'; Sql: DELETE FROM groups WHERE `id` = 1368
sql is executable in mysql
using sharding-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] tianhao960 commented on issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
Posted by GitBox <gi...@apache.org>.
tianhao960 commented on issue #20559:
URL: https://github.com/apache/shardingsphere/issues/20559#issuecomment-1230090539
hello, @bojiw , which version of mysql did you use? I've try the sql it can not run at mysql 8.0 . and the word "groups" is a reserved keyword of mysql from version 8.0; and ShardingSphere is treated "groups" as a reserved keyword like mysql 8.0, so can not use groups as a table name.
and the temp work around is add ` around groups
`DELETE FROM `groups` WHERE id = 1368;`
--
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] strongduanmu commented on issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #20559:
URL: https://github.com/apache/shardingsphere/issues/20559#issuecomment-1229608937
@tianhao960 Welcome, I just assign this issue to 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] strongduanmu commented on issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #20559:
URL: https://github.com/apache/shardingsphere/issues/20559#issuecomment-1272454806
This issue has not been finished, so I will reopen 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] github-actions[bot] closed issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
URL: https://github.com/apache/shardingsphere/issues/20559
--
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] bojiw closed issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
Posted by GitBox <gi...@apache.org>.
bojiw closed issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
URL: https://github.com/apache/shardingsphere/issues/20559
--
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] tianhao960 commented on issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
Posted by GitBox <gi...@apache.org>.
tianhao960 commented on issue #20559:
URL: https://github.com/apache/shardingsphere/issues/20559#issuecomment-1229468274
I would like to try 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] github-actions[bot] commented on issue #20559: Error Msg: This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20559:
URL: https://github.com/apache/shardingsphere/issues/20559#issuecomment-1272348701
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