From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: zuming.jiang@inf.ethz.ch, pgsql-bugs@lists.postgresql.org, PG Bug reporting form <noreply@postgresql.org>
Subject: Re: BUG #17986: Inconsistent results of SELECT affected by btree index
Date: Wed, 21 Jun 2023 01:40:56 +0200
Message-ID: <e73bf331-7b1d-9808-d909-80688e318a88@enterprisedb.com> (raw)
In-Reply-To: <17986-6ebf8b5d2c3a4f6e@postgresql.org>
References: <17986-6ebf8b5d2c3a4f6e@postgresql.org>
On 6/20/23 22:54, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17986
> Logged by: Zuming Jiang
> Email address: zuming.jiang@inf.ethz.ch
> PostgreSQL version: 16beta1
> Operating system: Ubuntu 20.04
> Description:
>
> My fuzzer finds a correctness bug in Postgres, which makes Postgres return
> inconsistent results. This bug can be reproduced even after applying the
> fixing patches for
> https://www.postgresql.org/message-id/flat/17976-4b638b525e9a983b%40postgresql.org
>
> https://www.postgresql.org/message-id/flat/17982-3fa239feecd6c1b3%40postgresql.org
> https://www.postgresql.org/message-id/flat/17985-748b66607acd432e%40postgresql.org
>
> ...
>
> --- Postgres version ---
> Github commit: efeb12ef0bfef0b5aa966a56bb4dbb1f936bda0c
> Version: PostgreSQL 16beta1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
> 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
>
I can't reproduce this with current master - perhaps one of the commits
since efeb12ef0b fixes this too? Those should be for the patches you
mentioned, but it's likely a bit improved.
Can you try with current master?
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tomas.vondra@enterprisedb.com, noreply@postgresql.org
Subject: Re: BUG #17986: Inconsistent results of SELECT affected by btree index
In-Reply-To: <e73bf331-7b1d-9808-d909-80688e318a88@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox