Re: wrong query results on bf leafhopper

2025-06-02 Thread Robins Tharakan
Hi, On Thu, 29 May 2025 at 02:32, Andres Freund wrote: > On 2025-05-28 22:51:14 +0930, Robins Tharakan wrote: > Recently leafhopper failed again on the same test. For now I've paused it. > > To rule out the compiler (and its maturity on the architecture), I'll > > upgrade > > gcc (to nightly, o

Re: wrong query results on bf leafhopper

2025-05-28 Thread Andres Freund
Hi, On 2025-05-28 22:51:14 +0930, Robins Tharakan wrote: > On Tue, 20 May 2025 at 15:20, David Rowley wrote: > > > On Tue, 20 May 2025 at 16:07, Tom Lane wrote: > > > Failures like this one [1]: > > > > > > @@ -340,9 +340,13 @@ > > > create function myinthash(myint) returns integer strict immu

Re: wrong query results on bf leafhopper

2025-05-28 Thread Tom Lane
Robins Tharakan writes: > I didn't dive in deeper but I see that indri failed recently [1] on what > seems > like the exact same test / line-number (at t/027_stream_regress.pl line 95) > that leafhopper has been tripping on recently. The error is not verbatim, > but it was a little too coincidenta

Re: wrong query results on bf leafhopper

2025-05-28 Thread Robins Tharakan
On Tue, 20 May 2025 at 15:20, David Rowley wrote: > On Tue, 20 May 2025 at 16:07, Tom Lane wrote: > > Failures like this one [1]: > > > > @@ -340,9 +340,13 @@ > > create function myinthash(myint) returns integer strict immutable > language > >internal as 'hashint4'; > > NOTICE: argument t

Re: wrong query results on bf leafhopper

2025-05-20 Thread Tomas Vondra
On 5/20/25 07:50, David Rowley wrote: > On Tue, 20 May 2025 at 16:07, Tom Lane wrote: >> Failures like this one [1]: >> >> @@ -340,9 +340,13 @@ >> create function myinthash(myint) returns integer strict immutable language >>internal as 'hashint4'; >> NOTICE: argument type myint is only a

Re: wrong query results on bf leafhopper

2025-05-19 Thread David Rowley
On Tue, 20 May 2025 at 16:07, Tom Lane wrote: > Failures like this one [1]: > > @@ -340,9 +340,13 @@ > create function myinthash(myint) returns integer strict immutable language >internal as 'hashint4'; > NOTICE: argument type myint is only a shell > +ERROR: ROWS is not applicable when fun

Re: wrong query results on bf leafhopper

2025-05-19 Thread Tom Lane
David Rowley writes: > Note that the actual row count is 1000 still, so that pretty much > discounts corruption with the stored unique1 values. Unfortunately, > that doesn't reduce the number of possible other reasons by very much. Failures like this one [1]: @@ -340,9 +340,13 @@ create functio

Re: wrong query results on bf leafhopper

2025-05-19 Thread David Rowley
On Sat, 17 May 2025 at 01:19, Andres Freund wrote: > @@ -42,7 +42,7 @@ > -> Nested Loop (actual rows=1000.00 loops=N) > -> Seq Scan on tenk1 t2 (actual rows=1000.00 loops=N) > Filter: (unique1 < 1000) > - Rows Removed by Filter: 9000 > +

Re: wrong query results on bf leafhopper

2025-05-19 Thread Andres Freund
Hi, On 2025-05-19 12:49:26 +0930, Robins Tharakan wrote: > Hi Andres, > > On Fri, 16 May 2025 at 22:49, Andres Freund wrote: > > > > There have been other odd things on leafhopper, see e.g.: > > > https://www.postgresql.org/message-id/35d87371-f3ab-42c8-9aac-bb39ab5bd987%40gmail.com > > https://

Re: wrong query results on bf leafhopper

2025-05-18 Thread Robins Tharakan
Hi Andres, On Fri, 16 May 2025 at 22:49, Andres Freund wrote: > > There have been other odd things on leafhopper, see e.g.: > https://www.postgresql.org/message-id/35d87371-f3ab-42c8-9aac-bb39ab5bd987%40gmail.com > https://postgr.es/m/Z4npAKvchWzKfb_r%40paquier.xyz > Any chances this could be li

Re: wrong query results on bf leafhopper

2025-05-16 Thread Alena Rybakina
is there different tables "Seq Scan on tenk1 t2" and "Seq Scan on tenk1 t1", so it might not be a bug, isn't it? On 16.05.2025 09:19, Andres Freund wrote: Hi, I noticed this recent BF failure: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=leafhopper&dt=2025-05-15%2008%3A10%3A04 ===