XieYingFa opened a new issue, #6447:
URL: https://github.com/apache/incubator-seata/issues/6447

   如果sql为:update mallcard.qst_mallcard_info t set t.amount = t.amount + 10 
where t.card_no = '';加了别名t,在回滚时会报标识符无效,发现Seata的for update 语句在amount字段上加了双引号,如下图
   0094126a7af4bc02e30a67167a56f502
   如果sql为:update mallcard.qst_mallcard_info t set amount = amount + 10 where 
t.card_no = '';,则可以正常回滚
   
   ### Ⅵ. Environment:
   
   - JDK version(e.g. `java -version`): 1.8
   - Seata client/server version:  2.0.0
   - Database version: Oracle Database 11g Enterprise Edition Release 
11.2.0.4.0 - 64bit Production
   - OS(e.g. `uname -a`): Linux
   - Others:


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to