#260 For multi-step queries WHERE CURRENT OF does not work

[Abbas Butt]

For any query where the FQS planner decides that this is a multi-step query and needs both coordinator and data nodes UPDATE/DELETE using WHERE CURRENT OF does not work.
The test case involved here is portals.sql
The test case has one failure due to this limitation.

DECLARE c1 CURSOR FOR SELECT a.f1,a.f2,b.f1,b.f2 FROM uctest a, uctest b WHERE a.f1 = b.f1 + 5 ORDER BY 1 FOR SHARE OF a;
FETCH 1 FROM c1;
UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1;

[Koichi Suzuki]

Should be fixed as a part of WCO.

[Abbas Butt]

WHERE CURRENT OF is blocked for now, moving this case to 1.1 Dev Q

[Koichi Suzuki]

Q2, will be done as a part of WHERE CURRENT OF feature.