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

Rm cannot find primary key when primary key is Uppercase in sql ,using MySQL. #1217

Closed
1 task
VainEffort opened this issue Jun 18, 2019 · 0 comments · Fixed by #1218 or #1221
Closed
1 task

Rm cannot find primary key when primary key is Uppercase in sql ,using MySQL. #1217

VainEffort opened this issue Jun 18, 2019 · 0 comments · Fixed by #1218 or #1221
Labels
DB: MySQL Relate to seata MySQL type: bug Category issues or prs related to bug.

Comments

@VainEffort
Copy link

  • I have searched the issues of this repository and believe that this is not a duplicate.

Ⅰ. Issue Description

when I write a Insert SQL which the primary key is uppercase, RM cannot generate afterimge.
I find InsertExecutor.containsPK() judge if pk exists by comparing MySQL table metadata with the result of SQL recognizer. Which compare the lowercase PK and uppercase Pk.
When this table dosenot have auto-increase PK, RM throw exception.

Ⅱ. Describe what happened

If there is an exception, please attach the exception trace:

Just paste your stack trace here!

Ⅲ. Describe what you expected to happen

Ⅳ. How to reproduce it (as minimally and precisely as possible)

  1. xxx
  2. xxx
  3. xxx

Ⅴ. Anything else we need to know?

Ⅵ. Environment:

  • JDK version :
  • OS :
  • Others: Seata 0.6.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
DB: MySQL Relate to seata MySQL type: bug Category issues or prs related to bug.
Projects
None yet
2 participants