apache / apache/incubator-seata-samples

samples sql rollback error

Open
#48 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
2.4k
Forks
2k
PR merge metrics
No merged PRs in 30d

Description

t_asset_assign rollback generate rollback sql:
UPDATE t_asset_assign SET desc = ?, status = ?, update_time = ?, update_user = ? WHERE id = ?;
reason is that the parameter ‘desc ’ is mysql keyword, suggest to add `` char on rollback sql parameter

Contributor guide

Open the contributing guide

Research direction

Locate the rollback SQL generation involved in t_asset_assign and reproduce the reported UPDATE statement with desc as a MySQL keyword. Verify that the generated rollback SQL quotes that column name and that the resulting statement executes successfully; the issue does not name a file or test to run.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.