Re: Fuzz testing COPY FROM parsing

2021-02-06 Thread Andrew Dunstan
On 2/5/21 2:50 PM, Heikki Linnakangas wrote: > On 05/02/2021 21:16, Andrew Dunstan wrote: >> >> On 2/5/21 10:54 AM, Stephen Frost wrote: >>> * Heikki Linnakangas (hlinn...@iki.fi) wrote: I ran it for about 2 h on my laptop with the patch I was working on [2]. It didn't find any cra

Re: Fuzz testing COPY FROM parsing

2021-02-05 Thread David Fetter
On Fri, Feb 05, 2021 at 12:45:30PM +0200, Heikki Linnakangas wrote: > Hi, > > I've been mucking around with COPY FROM lately, and to test it, I wrote some > tools to generate input files and load them with COPY FROM: > > https://github.com/hlinnaka/pgcopyfuzz Neat! The way it's already produced

Re: Fuzz testing COPY FROM parsing

2021-02-05 Thread Tom Lane
Heikki Linnakangas writes: > That said, I don't think it's important to run the fuzzer in the > buildfarm. It should be enough to do that every once in a while, when > you modify the COPY FROM code (or something else that you want to fuzz > test). But we could easily include the test inputs gen

Re: Fuzz testing COPY FROM parsing

2021-02-05 Thread Stephen Frost
Greetings, * Heikki Linnakangas (hlinn...@iki.fi) wrote: > On 05/02/2021 21:16, Andrew Dunstan wrote: > >On 2/5/21 10:54 AM, Stephen Frost wrote: > >>* Heikki Linnakangas (hlinn...@iki.fi) wrote: > >>>I ran it for about 2 h on my laptop with the patch I was working on [2]. It > >>>didn't find any

Re: Fuzz testing COPY FROM parsing

2021-02-05 Thread Heikki Linnakangas
On 05/02/2021 21:16, Andrew Dunstan wrote: On 2/5/21 10:54 AM, Stephen Frost wrote: * Heikki Linnakangas (hlinn...@iki.fi) wrote: I ran it for about 2 h on my laptop with the patch I was working on [2]. It didn't find any crashes, but it generated about 1300 input files that it considered "int

Re: Fuzz testing COPY FROM parsing

2021-02-05 Thread Andrew Dunstan
On 2/5/21 10:54 AM, Stephen Frost wrote: > Greetings, > > * Heikki Linnakangas (hlinn...@iki.fi) wrote: >> I've been mucking around with COPY FROM lately, and to test it, I wrote some >> tools to generate input files and load them with COPY FROM: >> >> https://github.com/hlinnaka/pgcopyfuzz > Nea

Re: Fuzz testing COPY FROM parsing

2021-02-05 Thread Stephen Frost
Greetings, * Heikki Linnakangas (hlinn...@iki.fi) wrote: > I've been mucking around with COPY FROM lately, and to test it, I wrote some > tools to generate input files and load them with COPY FROM: > > https://github.com/hlinnaka/pgcopyfuzz Neat! > I used a fuzz testing tool called honggfuzz [1