Skip to content

[Bug] [sqlserver] if write column is not have identity column, not execute SET IDENTITY_INSERT %s ON #1568

@fengfangwei

Description

@fengfangwei

Search before asking

  • I had searched in the issues and found no similar issues.

What happened

image

What you expected to happen

normal operation

How to reproduce

This is because the table contains fields with the identity attribute, which can be divided into two situations
The fields written in Flinksql contain the identity field
The fields written in the Flinksql task do not contain the identity field
Execution is required when writing the identity field value
If the written field does not contain an identity field, do not execute it. Otherwise, this problem may occur. Therefore, we will first determine whether the written field contains an identity field

Anything else

No response

Version

master

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions