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 1vgaW7-00FoCp-0q for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jan 2026 03:28:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vgaV6-000OML-0d for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Jan 2026 03:27:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vgaV5-000OM8-2f for pgsql-hackers@lists.postgresql.org; Fri, 16 Jan 2026 03:27:52 +0000 Received: from mail-ot1-x331.google.com ([2607:f8b0:4864:20::331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vgaV2-000gKO-03 for pgsql-hackers@lists.postgresql.org; Fri, 16 Jan 2026 03:27:49 +0000 Received: by mail-ot1-x331.google.com with SMTP id 46e09a7af769-7cfda7bf36bso440305a34.2 for ; Thu, 15 Jan 2026 19:27:48 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1768534068; cv=none; d=google.com; s=arc-20240605; b=JBAcKN/41W0g7dp+lQjU7/sNbIwdn8DnhAcmNvFctXVI6Xk4XLGSbikGyQAEop5IaF Mau223rU5mr6kD0FUkygULE7S7VriKFtJOB3FeMT3LcHr3J2E2Q1YlMZ0BXTJS0h1WvY xtf5Es4UY4U2thPYWhRo7kTMLd8UM5bXFz0HOVWaNL5c1KxsT4IzPRyJhZyJDovyNl7W qy5IZBfusmHs6tuP1zA+o63p9c5gt4fsPQaqJgSN08b/IVq/T7dKpJ1TMNshGUydgWO7 u7V1/SAVxlbsuJAHHamB6ddTkUjfe06p5i5ZdxNMcV4mGzFfDKCrpd2MEeQ4zEQF6Mw3 frJQ== 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=MeFj4Hqox60jO1wqe7iIILfZosgw/dEqa5zjX84jzt8=; fh=N/cBeW6vFHpr9g7GQFnfVp6kK0EIYkTnqTCtSQ0n/sU=; b=Z556mxj1oIKWVcyw5zTzqNGNDzDq++6BWW1UHoBJ6V1PftcCYR5lREmpI+dGZshfZc sSQfIt3Rz9Am5rO1rxOLyXKeK4ErKkd2o6kSCvrckH3vQiEWvoYskyTYn3gyVpTRSTli oM9EvyYyeov3a1XmZAb+ggxvC3DnHfKxmz8dgBAMkq7g1bv5JpFtKGfIu8tzVzU8QgJP GEywDEbagle2OrUuZqwp8iKHDfKhQSzOmkyzwsjsFvMx50kaCrenwe5BK0JJ4lN9U/PG lBs9dMcUfu3ROlbNkBMpB1Y1O+ff1nNf5AfO0XZnQRQl0tSB18BnvIB9xG9h7ZseRDpC nMlw==; 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=20230601; t=1768534068; x=1769138868; 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=MeFj4Hqox60jO1wqe7iIILfZosgw/dEqa5zjX84jzt8=; b=Dc1FLepb/RAZcceTJf2Ftb3Dt6gHhdNdU6hdlkcMffE5dtNmuAoR/nMCrXq8kYmQl0 VrZ2Z6aw3eFCI0gfGB3LUFjcVyCAE9lW+p7g/runknqNoUG51ec6EHh866ptG5Bq6W2m w9nWRQ2btT/OJ28XWRf7rmQGXrDlxx9VBj5i6Ssur1pDycFd5UFiWDud4C1wgLDxJFo2 ijp9VsgTv2Cb2mIx35YcImlGeLotS9DG944q0egbXShHvo7ukhiMfVouyW5BrqfAM3wm 32XaYMkqH7LsysXlPczfH/gNmGIr/gdCoacKlJDiOekE971tF16PksBCRDCECTLgMev8 mwiQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768534068; x=1769138868; 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=MeFj4Hqox60jO1wqe7iIILfZosgw/dEqa5zjX84jzt8=; b=u3/hF3BOZnjkimeddrUGmAmnBFjbIgRO8bwXaoFNzE5ibx5kTWj1HdsrUCYQ2MreAq PjkAVQQ6Yt/hMJpXNWyfmsydFjkU0bfNSKMWM+OuIRXS+/4K5FDYzUSBioSh/jGhopNm MJKSgYJEDS6fnezHEgLY9W07wTYrIfGoKBpjQQEMRa0h+w8Eti4gCyxmCpUxsDZah0t5 tT1ifKwhdtFoE0FoEW+k/vmh8Uys2rM6jm1+5qm/ugoWSQelcpFZMHQS6TWQxhEhqXiD Afjeuhw8DT73CyM23Tqv8VphJpJ3WaNBrvz54wEktY3xn4KF1Hw7ZIuITwyxYfmEiaZy snSQ== X-Forwarded-Encrypted: i=1; AJvYcCVXpf6wnBWyvl19/hdpKZ2NrPSeUR4a9JhOVQHtzO1d6wP8YgjbbF/7Hznux0vQw02mXqn5NY226YSRaQp9@lists.postgresql.org X-Gm-Message-State: AOJu0YxXADf9FQh2tK2MLL6njrZ+saIgjGWRCjHZAxN9mEmfmFdWPjjc w4ISqA28THwzFYXEFmj+Fx2MUmxamhD06UVRW4F9nXNQ0k5ecDpc1Ii8pSNgx6lKdTEsPhEIFXR VoVIVg2bbyrlOJRQinBU31F0fnWDOGL0= X-Gm-Gg: AY/fxX49RIGUl6FQ0EL5WlvJJQtQ4kryfh4Jeh27nKsmCTJNwYm7i44xb9svNVPDvZy d4JL9OOUpeRu3VQ33rf1l0rWrYJL/lE3St0xTNPZ0hMr8pMCMWB3OTTXuIxmC06mvBAF9/QwGyG DTwOZ+ZeZC4WCcFD3SvKbF1b0YlHvbKw/Ru4LNGjtQ3xVO0TcMYvksW8+GxJdPRc9PfWkX/nQ5N PBc4VfEbS9DkjnRi3Y6LI4OZsaVwMdptuydRQehjz3BhS5x8fPjKM4rfbNZMxqXgo0Jj3BzDA== X-Received: by 2002:a05:6820:490c:b0:657:3e43:130d with SMTP id 006d021491bc7-661188d5c50mr634536eaf.5.1768534067834; Thu, 15 Jan 2026 19:27:47 -0800 (PST) MIME-Version: 1.0 References: <7900964C-F99E-481E-BEE5-4338774CEB9F@gmail.com> <1607957.1767725532@sss.pgh.pa.us> <1654153.1767753474@sss.pgh.pa.us> <1752324.1767805242@sss.pgh.pa.us> <1892152.1767844982@sss.pgh.pa.us> In-Reply-To: From: Richard Guo Date: Fri, 16 Jan 2026 12:27:36 +0900 X-Gm-Features: AZwV_QgKJUe19vlBJe4obgdLBAygBVo_BKF2Z1n2Hkd7X-1-LqsA_TOPKnrYdLU Message-ID: Subject: Re: Fwd: pg18 bug? SELECT query doesn't work To: Tom Lane Cc: Eric Ridge , Pg Hackers 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 On Fri, Jan 9, 2026 at 6:52=E2=80=AFPM Richard Guo = wrote: > I've worked on the comment a bit more in the attached patch, which > also includes my previously proposed code changes and some test cases. > > I think this patch is suitable for fixing the current bug in the back > branches. We can use a separate patch for the more ambitious goal of > moving the push-down of subquery's restriction clauses into > subquery_planner(). I plan to push and backpatch this patch early next week, barring any objections. - Richard