Skip to content

There InsertOnDuplicateUpdate is an issue with bypassing modifying the primary key #4952

@funky-eyes

Description

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

Ⅰ. Issue Description

数据库开启不区分列大小写的情况下
数据库表的列名为 ID,sql中为id
duplicateKeyUpdateColumns会匹配不到数据库里的主键,导致认为业务sql并没有修改主键,导致后续的回滚存在失败的情况
lQLPJxa2n-EiSsLNArLNBbKwcnRy0jE3hFQDLEdAh4CJAA_1458_690
image

Ⅱ. 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 :
  • Seata version:
  • OS :
  • Others:

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions