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

时间：2024-05-07 20:29:47

问题现象

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

  
       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.