Skip to content

[Known Issue] Table with triggers error out on UPDATE #452

@yorek

Description

@yorek

If a table has a trigger, the following error is generated:

Route matched with {action = "Post", controller = "GraphQL"}. Executing controller action with signature System.Threading.Tasks.Task`1[System.Text.Json.JsonElement] PostAsync() on controller Azure.DataGateway.Service.Controllers.GraphQLController (Azure.DataGateway.Service).
UPDATE [s001].[todos] SET [s001].[todos].[title] = @param1 OUTPUT Inserted.[id] WHERE [s001].[todos].[id] = @param0;
Microsoft.Data.SqlClient.SqlException (0x80131904): The target table 's001.todos' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingimprovementLet's make this betterknown-issueKnown issues linked from https://learn.microsoft.commssqlan issue thats specific to mssql

Type

No type

Projects

Status

Done

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions