gpdb icon indicating copy to clipboard operation
gpdb copied to clipboard

Ensure that Motion nodes under HashJoin with outer refers are not rescanned

Open wuyuhao28 opened this issue 1 year ago • 3 comments

Previously (#6776) we fix plans with a Nested Loop join on the inner side of another Nested Loop join, executor may produce an error:

ERROR: illegal rescan of motion node: invalid plan HINT: Likely caused by bad NL-join, try setting enable_nestloop to off

But this error will happen with Hash Join plan, this commit adds a shield material node on the required Hash Join outer side.

wuyuhao28 avatar Jan 15 '24 12:01 wuyuhao28