You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "sidikaisi (via GitHub)" <gi...@apache.org> on 2024/11/20 02:14:33 UTC
[I] Failed to execute the SQL update statement [shardingsphere]
sidikaisi opened a new issue, #33728:
URL: https://github.com/apache/shardingsphere/issues/33728
We're using ShardingSphere-Proxy, and when I just want to update the statement, the update fails. It is found that the updated field value contains English semicolons, so the update failed. For example, update user set user_name='ssss; A statement such as' where id=1 'will fail. May I ask why?
My configuration of global.yaml is as follows:
mode:
type: Standalone
repository:
type: JDBC
authority:
users:
- user: root@%
password: 8fScvkcbfV4chcrdU1
privilege:
type: ALL_PERMITTED
props:
system-log-level: INFO
sql-show: false
max-connections-size-per-query: 1
check-table-metadata-enabled: false
proxy-frontend-flush-threshold: 128
proxy-backend-query-fetch-size: -1
proxy-frontend-executor-size: 0
proxy-frontend-max-connections: 5000
proxy-default-port: 3307
proxy-netty-backlog: 1024
proxy-hint-enabled: true
proxy-backend-driver-type: JDBC
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2501178397
What is rule configuration, table metadata and desire updated data?
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2508819776
> > What is rule configuration, table metadata and desire updated data?
>
> My problem is the same as this one. Is it OK to change to the lower version? Has this problem been solved? #31609
The issue is still open
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "sidikaisi (via GitHub)" <gi...@apache.org>.
sidikaisi commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2499843939
> What is your version?
5.5.0
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2487422701
What is your 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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2499889919
What is the exception?
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2508819587
The issue is still open
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2525336401
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #33728: Failed to execute the SQL update statement
URL: https://github.com/apache/shardingsphere/issues/33728
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "sidikaisi (via GitHub)" <gi...@apache.org>.
sidikaisi commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2499964571
> What is the exception?
No exception is seen, that is, the number of rows returned is 0 and the data has not been updated
--
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
Re: [I] Failed to execute the SQL update statement [shardingsphere]
Posted by "sidikaisi (via GitHub)" <gi...@apache.org>.
sidikaisi commented on issue #33728:
URL: https://github.com/apache/shardingsphere/issues/33728#issuecomment-2502972313
> What is rule configuration, table metadata and desire updated data?
My problem is the same as this one. Is it OK to change to the lower version? Has this problem been solved?
https://github.com/apache/shardingsphere/issues/31609
--
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