Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failed to execute the SQL update statement #33728

Open
sidikaisi opened this issue Nov 20, 2024 · 1 comment
Open

Failed to execute the SQL update statement #33728

sidikaisi opened this issue Nov 20, 2024 · 1 comment

Comments

@sidikaisi
Copy link

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
@terrymanu
Copy link
Member

What is your version?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants