apache / apache/incubator-seata-samples
samples sql rollback error
Open
- 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
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