| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> |
| Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
| Subject: | Re: Adding skip scan (including MDAM style range skip scan) to nbtree |
| Date: | 2025-05-02 18:22:07 |
| Message-ID: | CAH2-WzmT1cKPXQCEJA4F8FrE0GAdfbXtgN2nmKPo0Cr4invGxg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Apr 29, 2025 at 6:51 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> I don't expect that this script will actually discover any real bugs
> -- I ran it for long enough to get the sense that that was unlikely.
> But it seemed like a worthwhile exercise.
A slight variant of my fuzzing Python script did in fact go on to
detect a couple of bugs.
I'm attaching a compressed SQL file with repros for 2 different bugs.
The first bug was independently detected by some kind of fuzzing
performed by Mark Dilger, reported elsewhere [1].
I'm not sure if this message will be held up in moderation (the file
is 1MB in size once compressed), so I will explain these test cases in
the next mail to the list. And, I'll post fixes for both bugs.
[1] https://www.postgresql.org/message-id/CAHgHdKsn2W=gPBmj7p6MjQFvxB+zZDBkwTSg0o3f5Hh8rkRrsA@mail.gmail.com
--
Peter Geoghegan
| Attachment | Content-Type | Size |
|---|---|---|
| repro_forcenonrequired_bugs.tar.bz2 | application/x-bzip2 | 993.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-05-02 18:25:49 | Re: [PoC] Federated Authn/z with OAUTHBEARER |
| Previous Message | Daniil Davydov | 2025-05-02 18:12:49 | Re: POC: Parallel processing of indexes in autovacuum |