Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xM6UF-00000001rJD-2PKE for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Oct 2026 16:26:52 +0000 Received: from localhost ([127.0.0.1]:46434 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xM6UF-0000000HWqX-0R3q for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Oct 2026 16:26:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:52946) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xM3Mv-0000000GeJf-3els for pgsql-bugs@lists.postgresql.org; Wed, 28 Oct 2026 13:07:05 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xM3Mu-00000001MiD-1WvS for pgsql-bugs@lists.postgresql.org; Wed, 28 Oct 2026 13:07:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: Content-Transfer-Encoding:MIME-Version:Content-Type:Sender:Content-ID: Content-Description:In-Reply-To:References; bh=mc+Hd/hMfqrELarBrZoyYQ0LB+m7eoFGhd7JQh86rPc=; b=B3YFfQ8xYWeCp2hLR0VCdtvNHg TPN9TWIhfeD0/6LJkzzIlY/tcHd3O5OCXff5z3TwhrHoD7d8ulC3YuFw1+Z7hq6rRHibMsJf7np5y vX8tyCYhGyRLJImfxn+Lm0GlC654P5x8twQccTmMLJyicbL1Ree9/oi78VWUYOOZ56Rx/uCSPoh+l Mfr7guQeTCgD7DweUDpv75rMjZbFBMvBq21w4vj0hea9oNWguS5lFuT377+m43i7Xks2TQE4xIkHD HAT7PfiNpSEg8HHI2jRsEMB6s2QgsprjiNZjZZ0JUkWhQ/x2Tz+KPQlvgYzFn7zmf+jiSGHaH1WNk E1IeeAzA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xM3Mu-00000003wCl-0lMh for pgsql-bugs@lists.postgresql.org; Wed, 28 Oct 2026 13:07:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xM3Ms-00000004LYf-0vZQ for pgsql-bugs@lists.postgresql.org; Wed, 28 Oct 2026 13:07:03 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: BUG #19803: Assertion "!parallel_aware || pathnode->path.parallel_safe" in create_append_path To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: gowthamdoma18@gmail.com Reply-To: gowthamdoma18@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 28 Oct 2026 13:06:17 +0000 Message-ID: <19803-1fcc1df108c54ab6@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk The following bug has been logged on the website: Bug reference: 19803 Logged by: Gowtham Reddy Email address: gowthamdoma18@gmail.com PostgreSQL version: 17.11 Operating system: Ubuntu 22.04 (WSL2), x86_64, built with --enable-c Description: =20 On an assert-enabled build this query crashes the backend: CREATE TABLE pi (a int); CREATE TABLE pi_child () INHERITS (pi); WITH c1 AS (SELECT 1 FROM pi WHERE true UNION ALL SELECT 1 FROM pi WHERE false), c2 AS MATERIALIZED (SELECT 1) SELECT 1 FROM c1 UNION ALL SELECT 2 FROM c2; TRAP: failed Assert("!parallel_aware || pathnode->path.parallel_safe"), File: "pathnode.c", Line: 1439 (master 4848fd675; line 1328 on 17.11) Reproduced on 17.11 and master (4848fd675, 2026-10-28), default settings. A release build (18.6) returns the expected rows. Needed: an inheritance parent with a child (a plain table does not crash); the inlined CTE being a UNION ALL with a constant-false branch (with only true branches it does not crash); the outer UNION ALL including a MATERIALIZED CTE scan. Writing the first branch as a FROM subquery instead of a CTE does not crash. It looks like a parallel-aware Append is built although one of its children is not parallel-safe. Found by a grammar-based SQL fuzzer (university course project); the script above is the hand-reduced test case.