Azure 突触 : Merge command with the identity column in target table is not working

Question

尽管我们没有更新/插入标识列，但对具有标识列的目标表执行合并命令会出错。请找到以下代码片段和错误消息

消息 8102，第 16 级，状态 1，第 7 行无法更新身份列“id”。

CREATE TABLE dbo.t1 (id INT IDENTITY(1,1), Sub INT, Metric INT) WITH (DISTRIBUTION = HASH(Sub), CLUSTERED COLUMNSTORE INDEX);

;WITH SRC AS (SELECT 1 AS Sub, 100 AS Metric) MERGE dbo.t1 AS tgt USING SRC ON tgt.Sub = SRC.Sub WHEN MATCHED THEN UPDATE SET Metric = SRC.Metric WHEN NOT MATCHED THEN INSERT (Sub, Metric) VALUES (SRC.Sub, SRC.Metric);

错误:

Answer 1

已向产品团队报告错误，将在未来版本中修复