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.96) (envelope-from ) id 1wS2uC-002uaf-2l for pgsql-bugs@arkaria.postgresql.org; Wed, 27 May 2026 01:17:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wS2u9-006gYK-0i for pgsql-bugs@arkaria.postgresql.org; Wed, 27 May 2026 01:17:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wS2u8-006gYC-39 for pgsql-bugs@lists.postgresql.org; Wed, 27 May 2026 01:17:53 +0000 Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wS2u8-00000001c4j-0M1N for pgsql-bugs@lists.postgresql.org; Wed, 27 May 2026 01:17:53 +0000 Received: by mail-ed1-x531.google.com with SMTP id 4fb4d7f45d1cf-6763cc8775cso20516574a12.0 for ; Tue, 26 May 2026 18:17:51 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779844671; cv=none; d=google.com; s=arc-20240605; b=NO48+6Uj2avUh2RHXEJmxf0wRWmCuCyVPjJG/gnW7/TC/h6bS9iZwXVMjhVKpaTh0U 5EVO0H8x6V0O83Q5ne6s+syB1ii8GpxT/uBRaUnC7yBVtoUMw/oNj+0ur6EmfGd1A80B AC5IZ5+DQzJP4e9mWaKIKA6b/BQWHUq/4L+Oxa7ndSeo6FEMMd+FXAqrJCJg/lsUDUgm Tfo/4Wt5OF0K6AoAX4X4POzdyGzaUob5R+TxR9VabDg7yexkaDwoFV2si6M/SbF+r9c0 Phxn0vKaPvqIi+DQv9YDsGdJlLoitf67EMX3ZjaN7ZPzrQKzcEq4MEvrCd6zMpmqQrYh n1mg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=qDFCMcwgI7OnKP3gpwihkkp+HRJRTRTMbaMB/8Z1OR0=; fh=IdRGJRgcedcmp1ZpTDvQOW+LBiINZe/hJlvCN1XoaG4=; b=WdyTTVgDlJtkSwiVJDNgrY/Esojiau64n6csAHgA4W5oHEnMOYow3MZ/XqjRyVU8aL 96nN8pAgGURTzssFU4Ks/6iLiVXfy7BRHxJixTwK+rn3q+rpSvr8tHrZCtlVv5IgnMZn xYyzF4J5KGgu6nqN5JuzCpDtOo92dRaWppdecaA+T5OwCQ+gbsaRcKwjaRa/AYmK8dEz jRNID3wmo+rHGTLtZhUFTxju4vcZOXacmIps4gVmdPYNMG5IFpyj6TMq1iueT0TZ76OP +0FaCWgm+DUiZOkzbgcQt+ttFQD95j6zVpsUdBTn8DrwDwHa2vagmiq3Squv4OkQuz+S 8Bsg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779844671; x=1780449471; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=qDFCMcwgI7OnKP3gpwihkkp+HRJRTRTMbaMB/8Z1OR0=; b=UCm0V+C45fZu2LuPakfw7ofKYfInxmwPzuc175aaUiv11p8p4Ar14LQIPPz5O+NwoX 5RU4+EhC0QHnRjRrrH1U55/fQbSBZtgrWLqGAt1Td92GqDdmjM0+tpm3ADg3l8+1Pcfa nlfORbMhN7OZvOPtZIjROrJPGuv8RcG4AW38/L4wk6/0k5dr9hm+YtRdfqYh1muZT+k1 ws5Rl/O8qjEqgSuInG7u0ZueDTe6OIFfJFWJbFx5OcA0Hs1oSkY32RmnaqWJs9g0kPSd IclvLjU1TKGjMPNZYhZHiUBoEdO0GzdOHkWAgveblSPKCyW647PPJqpY8pp1kz0cKYen fw/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779844671; x=1780449471; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=qDFCMcwgI7OnKP3gpwihkkp+HRJRTRTMbaMB/8Z1OR0=; b=ZBz1n7ofIXfp/OXYt/QhETCni248tcGROqhvU4FivfCDcpJS5A/53hdwp0UYbNQSQr jNbDMQl4nSabUCowWl34RfXwG+IZPHvaEKhDx4Tozk0qw2G720UxBjSvcV2uvItcJ+RM +zAl9TP3q0GT1eO5kVHWJZJsPqgIbAygfz8o3YfUQB+achChE3z/l68uvH7q8oB+XNad 8RDTUkC86ph9r5zJ0R34AY3PcsMFzRsLv6pjNCQW6nxBTJUU+AsJeQc1277t6nxhtfRa DdJIW7mEwBAOfZufa8lnzsXw7+cQnOmSArNrUU8mE/vlE8+cpzBvvz6JKPGp9rXNDZOY DfWg== X-Forwarded-Encrypted: i=1; AFNElJ8od0sIlzTKPLhQN/6e6leB+k+PGmS1g6BWXYTFn+o1gaEQz3W3mC+NerYpbOQPtnucTd4z7yr0Dhol@lists.postgresql.org X-Gm-Message-State: AOJu0YykWRHPqvcYSbafiqhDSIKv8E9fdKhh01JXHZLtx0IMJFhC+eLP MUbR6VonJ+4/dHd8wjqZXDzfCiV/xh03cWyrBe0iVLWFqGmF6sMi8Ho7v2BKlDEr4aFGSXKKs9x 4mjSCupvU+Q4E30aImbCFuyltWzY8a2g= X-Gm-Gg: Acq92OFyhNrnIN3QGZB7vgDUUaUw0HUNs6QlYNJaC2XIMnOw6iabj6ZV4oGbjkD2dbJ n2wEPSFqdZUEIYZuNlbtTjwSmsPI+pXsTTAJWbxkRqgGDGq1gwYY2gfPK9DMl7Uhas40x13lHCJ RQ8DB3Tnw+QfcGxXQc2iZHbAOLb7pNXXslIpEghm4n36MFp3tjW9Fr0BRoASgxi5FBZs80oriAH pbom3GKTeHWoYCDOzBJPlQUOfiNCyoM+gRdONcHOepJmDT+mpFgwuDUAUTae7CPyLiYwqBhqSl/ E/5vQK1YqvvVa2IQ/Ch34qxxw7C6wQA8BW6QmZNj6tbH7QmDW3QHjQ== X-Received: by 2002:a17:907:9107:b0:bdf:b95e:7b6e with SMTP id a640c23a62f3a-bdfb95e81eemr468044966b.9.1779844670798; Tue, 26 May 2026 18:17:50 -0700 (PDT) MIME-Version: 1.0 References: <19493-5878eac7a2525c23@postgresql.org> <2d59d7d6-6afe-4565-8ff7-ae764651589a@gmail.com> <1779843554.737126560@fmail2.qdit> <418106.1779844099@sss.pgh.pa.us> In-Reply-To: <418106.1779844099@sss.pgh.pa.us> From: Tender Wang Date: Wed, 27 May 2026 09:17:39 +0800 X-Gm-Features: AVHnY4JPBh23Q1hBtA_FmxQ6Q4uuuEvhg6jr6JE3Vs1kQ5uPFQlpRk1y02L0qXw Message-ID: Subject: Re: BUG #19493: Assertion failure in pg_plan_advice with EXISTS subquery and DO_NOT_SCAN advice To: Tom Lane Cc: =?UTF-8?B?0JrQsNC70LjQvdC40L0g0J3QuNC60LjRgtCw?= , Michael Paquier , pgsql-bugs@lists.postgresql.org, Pierre Forstmann Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Tom Lane =E4=BA=8E2026=E5=B9=B45=E6=9C=8827=E6=97=A5=E5= =91=A8=E4=B8=89 09:08=E5=86=99=E9=81=93=EF=BC=9A > > =3D?UTF-8?B?0JrQsNC70LjQvdC40L0g0J3QuNC60LjRgtCw?=3D writes: > > Could this be related to GCC? I'm using GCC 16.1.1 and I can reproduce = the crash with that version. > > Maybe. Does it still fail if you set the optimization level to -O0 ? I can reproduce this crash on my machine with CFLAGS=3D"-O0 -g3". And my GCC version is 11.4.0 --=20 Thanks, Tender Wang