数据仓库服务 GAUSSDB(DWS)-更新报错ERROR:Non-deterministic UPDATE:问题现象

时间:2024-11-02 18:44:30

问题现象

执行update语句报错ERROR:Non-deterministic UPDATE。

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
CREATE TABLE public.t1(a int, b int) WITH(orientation = column);
CREATE TABLE

CREATE TABLE public.t2(a int, b int) WITH(orientation = column);
CREATE TABLE

INSERT INTO public.t1 VALUES (1, 1);
INSERT INTO public.t2 VALUES (1, 1),(1, 2);

UPDATE t1 SET t1.b = t2.b FROM t2 WHERE t1.a = t2.a;
ERROR: Non-deterministic 
UPDATEDETAIL:  multiple updates to a row by a single query for column store table.
support.huaweicloud.com/trouble-dws/dws_09_0129.html