CTEL中表达式为DELETE/UPDATE/INSERT时，结果不符合预期

[jd-zhang]

*Issue migrated from trac ticket # 887 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-08 18:22:40: smith created the issue

---

create table t1(a int, b int);

insert into t1 values(1,0),(2,0),(3,0),(4,0),(5,0);

WITH t AS (UPDATE t1 SET b=b+1 limit 4 returning *)
SELECT *
FROM t limit 1;

select * from t1;

[jd-zhang]

2022-07-08 18:24:44: smith commented

---

pg不支持updat limit，调整为：

WITH t AS (UPDATE t1 SET b=b+1 returning *)
SELECT *
FROM t limit 1;

[jd-zhang]

2022-07-11 11:35:07: smith changed status from new to accepted