cannot execute squelched plan node of type: 232

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire

Issue/Introduction

The following error message is reported when using JOIN:

2025-07-02 13:53:14.486087 BST,"gpadmin","dbname",p2440716,th371106432,"[local]",,2025-07-02 13:53:13 BST,0,con102,cmd4,seg-1,,,,sx1,"ERROR","XX000","cannot execute squelched plan node of type: 232 (execProcnode.c:951)  (seg0 slice13 10.159.240.157:6022 pid=375861) (execProcnode.c:951)",,,,,,"select * from view_with_joins where my_date = '6/30/2025';",0,,"execProcnode.c",951,"Stack trace:

Resolution

Workaround

Use Postgres Planner, "set optimizer=off;", to allow the query to run

Fix

There is currently no code fix for this issue, The only possibility id to use optimizer=off.