Issues

• planner: a nested WITH reusing a recursive CTE's name inside that CTE's recursive term is refused 42P19 (PostgreSQL 3)

  bugcorrectnessengine
  derekmwright/wadjet#1675 · Filter by author derekmwright opened on Oct 9, 2026

• distributed: HAVING EXISTS over a derived table's column answers 0 rows on dag and dag-morsel4 (PostgreSQL answers)

  bugcorrectnessdistributed
  derekmwright/wadjet#1674 · Filter by author derekmwright opened on Oct 9, 2026

• planner: a LATERAL inside a correlated subquery's body answers a wrong value (#1275 family)

  bugcorrectnessenginepriority:high
  derekmwright/wadjet#1673 · Filter by author derekmwright opened on Oct 9, 2026

• planner: a volatile WITH declared inside a derived table inside a correlated subquery is evaluated once per outer row (PostgreSQL once)

  bugcorrectnessengine
  derekmwright/wadjet#1672 · Filter by author derekmwright opened on Oct 9, 2026

• distributed: a HAVING aggregate-argument subquery over a CTE fails on the stage DAG with "subqueries require a SubqueryRunner" (PostgreSQL 3)

  bugcorrectnessdistributed
  derekmwright/wadjet#1671 · Filter by author derekmwright opened on Oct 9, 2026

• planner: a correlated WITH inside a subquery that reads the outer row is refused 42P01 on every arm (PostgreSQL 50)

  bugcorrectnessengine
  derekmwright/wadjet#1670 · Filter by author derekmwright opened on Oct 9, 2026

• distributed: a UNION of unconstrained numerics prints 7.00 or 7 on dag-morsel4 depending on the run (nl_un_xnu)

  bugcorrectnessdistributedflaky
  derekmwright/wadjet#1669 · Filter by author derekmwright opened on Oct 9, 2026

• planner: a window term over a FULL JOIN USING merged column is refused on both the single-process and the DAG arms

  bugcorrectnessengine
  derekmwright/wadjet#1668 · Filter by author derekmwright opened on Oct 9, 2026

• planner: a bare USING-merged column is 42702 (ambiguous) even in an ungrouped block

  bugcorrectnessengine
  derekmwright/wadjet#1667 · Filter by author derekmwright opened on Oct 9, 2026

• planner: an output alias inside a window term in ORDER BY / QUALIFY binds as an output column (aliasFallback); both sides refuse today

  bugengine
  derekmwright/wadjet#1666 · Filter by author derekmwright opened on Oct 9, 2026

• planner: a non-literal ROWS frame offset is refused 42601 where PostgreSQL raises 42P10 or 42803

  bugcorrectnessengine
  derekmwright/wadjet#1665 · Filter by author derekmwright opened on Oct 9, 2026

• expr: a nested NTH_VALUE with a computed value beside its N declares double precision on the single-process arms

  bugcorrectnessengine
  derekmwright/wadjet#1664 · Filter by author derekmwright opened on Oct 9, 2026

• planner: a window call as an ORDER BY term over a GROUP BY is refused 0A000, and with no GROUP BY fails with no SQLSTATE, where PostgreSQL answers

  bugcorrectnessenginepriority:high
  derekmwright/wadjet#1663 · Filter by author derekmwright opened on Oct 9, 2026

• TestAScanNeverHoldsMoreThanItsBudgetOfFileBytes fails intermittently under -race on a loaded runner

  engineflaketesting
  derekmwright/wadjet#1660 · Filter by author derekmwright opened on Oct 6, 2026

• A subquery in UPDATE's SET list is refused

  enginefeature
  derekmwright/wadjet#1659 · Filter by author derekmwright opened on Oct 6, 2026

• A lost-category local route fires for a plan that rounds an unrelated column

  distributedperf
  derekmwright/wadjet#1658 · Filter by author derekmwright opened on Oct 6, 2026

• CTAS from NULLIF(2.5, f) creates DECIMAL(2,1) where PostgreSQL creates double precision; round() over it answers 3

  correctnessengineplanner
  derekmwright/wadjet#1657 · Filter by author derekmwright opened on Oct 6, 2026

• A scalar-subquery comparison against NaN drops every row on the DAG arms

  correctnessdistributed
  derekmwright/wadjet#1656 · Filter by author derekmwright opened on Oct 6, 2026

• round(x, n) over a numeric-category float-carried value with n >= 309 answers NaN

  correctnessengine
  derekmwright/wadjet#1655 · Filter by author derekmwright opened on Oct 6, 2026

• EXTRACT(SECOND) and EXTRACT(EPOCH) drop the fractional second

  correctnessengine
  derekmwright/wadjet#1654 · Filter by author derekmwright opened on Oct 6, 2026

• An expression over a typed NUMERIC NULL (GREATEST, UNION ALL with a typed NULL) is typed double precision

  correctnessengineplanner
  derekmwright/wadjet#1653 · Filter by author derekmwright opened on Oct 6, 2026

• TestM1AEveryLateralJoinDropsItsOwnSlot's 512 KiB spilled arm fails intermittently on a memory-budget refusal

  engineflaketesting
  derekmwright/wadjet#1652 · Filter by author derekmwright opened on Oct 6, 2026

• A relation alias holding a dot makes a group key declare TEXT and sort as text

  correctnessengineplanner
  derekmwright/wadjet#1650 · Filter by author derekmwright opened on Oct 6, 2026

• A group key over a derived table's integer column declares double precision

  correctnessengineplanner
  derekmwright/wadjet#1649 · Filter by author derekmwright opened on Oct 6, 2026
  1

• The stage planner publishes a deduplicated UNION's column under its source name and drops the outer CAST

  correctnessdistributedplanner
  derekmwright/wadjet#1648 · Filter by author derekmwright opened on Oct 6, 2026