citus icon indicating copy to clipboard operation
citus copied to clipboard

Fix PostgreSQL 18 compatibility issues related to "?column?" names in…

Open gurkanindibay opened this issue 4 months ago • 4 comments

… subqueries

  • Updated various planner and deparser files to handle NULL or "?column?" as resname by generating meaningful column names.
  • Ensured that generated names follow a consistent format to avoid parsing errors in complex queries.
  • Added debug queries and tests to isolate and reproduce the issues related to intermediate results and subqueries.
  • Created setup scripts for test tables and data to facilitate regression testing for PostgreSQL 18 compatibility.

DESCRIPTION: PR description that will go into the change log, up to 78 characters

gurkanindibay avatar Aug 02 '25 14:08 gurkanindibay

@microsoft-github-policy-service agree [company="{gurkan}"]

gurkanindibay avatar Aug 02 '25 14:08 gurkanindibay

@gurkanindibay the command you issued was incorrect. Please try again.

Examples are:

@microsoft-github-policy-service agree

and

@microsoft-github-policy-service agree company="your company"

@microsoft-github-policy-service agree company="Gürkan"

gurkanindibay avatar Aug 02 '25 14:08 gurkanindibay

Thanks for your support.

Would you be able to identify the PostgreSQL commit that introduced this behavior?

m3hm3t avatar Aug 04 '25 06:08 m3hm3t