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 1vdCgE-00FI8X-0A for pgsql-general@arkaria.postgresql.org; Tue, 06 Jan 2026 19:25:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vdCgC-00AChy-1q for pgsql-general@arkaria.postgresql.org; Tue, 06 Jan 2026 19:25:21 +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 1vdCgC-00AChp-0j for pgsql-general@lists.postgresql.org; Tue, 06 Jan 2026 19:25:21 +0000 Received: from mail-qk1-x72e.google.com ([2607:f8b0:4864:20::72e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vdCgB-004aAJ-1V for pgsql-general@postgresql.org; Tue, 06 Jan 2026 19:25:19 +0000 Received: by mail-qk1-x72e.google.com with SMTP id af79cd13be357-8c0f13e4424so123081985a.1 for ; Tue, 06 Jan 2026 11:25:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1767727518; x=1768332318; darn=postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=yB3ETtS3UVF13jG8s/m6Sp+omINl3xJGiXtHpBbqvzU=; b=UEN+6ZeckKXFl53DCAxi1SUISGp0CJGsK6cK7kgi1labGry4sGFbwIYgJjUDBtzZ4n tV1IBoCzNBCnvWkESBYgMkMy/UfIk6f+pAnLcL79ciK7cJteEf5/pi5ugoiv0P5q8LLe 1AdVEZvQklN4JNR5bdptZhhqHc4ymVTTcbPlNGGeBFY4OFea1YZCJRcbCvRQm2O02UHJ z9PfnVarrscgq2ksOrAX4pF8MRRW9svLaDmXtExBI6t/Lurt1W87QMBPGf/1NpZmA77V KQJUGlWWT+oMYbWY9orJGPHP5RcTnGgERWXf/SKU3N1OOS0jsAQRFcNETglqXp/AACTx Fmag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1767727518; x=1768332318; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=yB3ETtS3UVF13jG8s/m6Sp+omINl3xJGiXtHpBbqvzU=; b=Vj1N2UhyPMqLANKmvIeIotaGLbpD2jy9iJqAWVQQztMJ8/yRFYM5PQDa2vVhVkVRW+ WQ/7ba4Bk/zLbx9bmClnqlObHrPMyd0D1kedHWX4mCJaiVb1Jy2WN1/lm15W1d9PRSPi 9eAgTv5WGZqfQU3pTfwI1v6JodiFoKiPjVgN537UDWmcfJyrab8jU8mJ2ibKyesSaVbz Nap3VxsWJ70u8OsfhBRLpD0z0u81hw8R2HSFWTtzUd0QFKXBZ5fZBULgqm1EdHWtzaDv 2GKyThPxk9bHwDqMtUun3krzO0+5hEl7C5W+QSL5uUSEXTfL+KSGhn6ovFfqzYVr+DZB ax9g== X-Gm-Message-State: AOJu0YwWYR9wTfTEa8UGOa2DoMN3TH/cHmECsA1JUCJYRx7ClTNxYnJo B1IdExqjrbfNMw+Euyb+KtWx2mAYuarbT513WiTVem61s8JQOJYB0pDs X-Gm-Gg: AY/fxX4N07E04/9pyv0TBwiqwTZXqJer53gQGIS/s2SMPnUPbjZWG86Evc2b0PQ83Oj hdY2OnOXL9HoW9MCXOHrLOBeLVooZhMVMpBDlq5SBoiyuVcajyS/KO4quVaHfsWwahhg+z9Y9vA JYZuiLHzovObG54AauO1OP5dinRhFBCffc7rUCKrWOAnaWX5Tr6wHS4NT86NhvVZkWqql5y182t A/iaZ2ox/YRf+8+UQ91p9YGuPZBfNELV6bK635/i9KduB8ZrRfe9IY/hELX97sqkw3G2Pio4XeS aR8RpcWjW9uJHA5s0pvWDxaBQ9l+Cvnr12hwKS3y+2ZyIl0JWxt7Ctys2b/GbWN7BwAa+2hp0Gv DZA3/7tOLr+zwrGJm2IFoHkFdcBgaFlLO5RqcvKCCUPHByknVpsI+isaJDarqZVIe+3+az+xkqb 0TmcZhh9Mfy0TmlKXLs2SN10ww4nhidEVkW0KcUp8Bti+Ue84deXFKqeeuocOHtCy7 X-Google-Smtp-Source: AGHT+IG/SnSiJbeJITQ78ia9m2x87NPE0kuwMTxxXqzKpnAkXcsxnczLa3JwAkd+yud+npuOup4YHg== X-Received: by 2002:a05:620a:25cf:b0:827:1bda:ca68 with SMTP id af79cd13be357-8c37eb9520cmr539001785a.46.1767727518063; Tue, 06 Jan 2026 11:25:18 -0800 (PST) Received: from smtpclient.apple (dhcp-67-145-242-116.gobrightspeed.net. [67.145.242.116]) by smtp.gmail.com with ESMTPSA id af79cd13be357-8c37f5312d3sm218138885a.43.2026.01.06.11.25.17 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 06 Jan 2026 11:25:17 -0800 (PST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.500.181.1.5\)) Subject: Re: pg18 bug? SELECT query doesn't work From: Eric Ridge In-Reply-To: <1607957.1767725532@sss.pgh.pa.us> Date: Tue, 6 Jan 2026 14:25:07 -0500 Cc: pgsql-general , Richard Guo Content-Transfer-Encoding: quoted-printable Message-Id: <7F5B7FC7-4445-4ADC-8897-638F705387D1@gmail.com> References: <7900964C-F99E-481E-BEE5-4338774CEB9F@gmail.com> <1607957.1767725532@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3826.500.181.1.5) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jan 6, 2026, at 1:52=E2=80=AFPM, Tom Lane = wrote: >=20 > Eric Ridge writes: >> Here's an even more reduced test case. No tables or data: >=20 > I agree that this is a bug. "git bisect" says it broke at Thanks for the confirmation and your investigation. Also, thanks for all you (all of you!) do for Postgres. Many in the = world, myself included, wouldn't be where we are in life without your = work. eric