[seata-java] bugfix: mysql insert on update duplicate sensitive case not matched - Githubissues

apache / incubator-seata-go

Go Implementation For Seata

https://seata.apache.org/

Apache License 2.0

1.56k stars 283 forks source link

[seata-java] bugfix: mysql insert on update duplicate sensitive case not matched #700

Open luky116 opened 3 days ago

luky116 commented 3 days ago

seata-java: https://github.com/apache/incubator-seata/pull/4912

[ ] I have registered the PR changes.

Ⅰ. Describe what this PR did

当数据库column为大写，而sql为小写时，读取parameter时匹配不上，造成了前镜像的sql为select * from table导致了全表扫描，后镜像也进行了一次全表扫描的bug

Ⅱ. Does this pull request fix one issue?

fixes #4909

Ⅲ. Why don't you add test cases (unit test/integration test)?

Ⅳ. Describe how to verify it

Ⅴ. Special notes for reviews