From: | Ronald Baljeu <rjb(at)xs4all(dot)nl> |
---|---|
To: | vadim(at)sable(dot)krasnoyarsk(dot)su (Vadim B(dot) Mikheev) |
Cc: | hackers(at)postgreSQL(dot)org, rjb(at)xs4all(dot)nl, ar(at)bizlink(dot)ru, darrenk(at)insightdist(dot)com, nick(at)grok(dot)demon(dot)co(dot)uk |
Subject: | Re: [HACKERS] new Group BY code |
Date: | 1998-02-19 12:04:04 |
Message-ID: | 199802191204.NAA21031@xs2.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> I hope that GROUP BY fixed.
> Unfortunately, I can't get any errors under FreeBSD
> when using GROUP BY with aggregates. I only got core
> for something like this: select y, z from tgrp group by y, z.
> Two different funcs are used for these two cases and so
> please test new code on your platforms.
> Please test with different -S XXX to check that all works
> for both in-memory and on-disk sorts (you'll see pg_psort.xxxx
> files in last case).
>
> New code are for 6.3. This is not patch (sorry, I lost orig version
> of execnodes.h...) and has to be un-tarred in src dir.
>
> If someone hasn't 6.3 - ok, I'll post patch for 6.2.1 tomorrow.
Vadim,
I downloaded the snapshot of Feb 18 and tried it. I noticed it's much
harder indeed to reproduce the bug (as compared to 6.2.1p6), but
occasionaly the bug appeared.
After installing your code the bug disappeared completely. I also tried
a couple of group-by queries on my production database, and tried both
in-memory sorting and on-disk sorting, but everything seems ok now.
So I guess congratulations are in order.
Thanks!
Cheers,
Ronald
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1998-02-19 12:09:02 | Re: [HACKERS] Re: DB logging (was: Problem with the numbers I reported yesterday) |
Previous Message | Jan Wieck | 1998-02-19 10:26:29 | Re: [HACKERS] Lost a function overloading capability? |