Re: Window Functions: v07 APIs and buffering strateties - Mailing list pgsql-hackers

From David Rowley
Subject Re: Window Functions: v07 APIs and buffering strateties
Date
Msg-id 435B8B37E7DB41259C44714247A6D1AF@amd64
Whole thread Raw
In response to Window Functions: v07 APIs and buffering strateties  ("Hitoshi Harada" <umi.tanuki@gmail.com>)
Responses Re: Window Functions: v07 APIs and buffering strateties
List pgsql-hackers
Hitoshi Harada Wrote:

> As I promised, version 7 of the window functions is now released. At
> the same time, git repository branch comes back to master.
>
> git: http://git.postgresql.org/?p=~davidfetter/window_functions/.git
> patch: http://umitanuki.net/pgsql/window_functions.patch.20081028.gz

I've been testing for a couple of hours now and just comparing results to
the results Oracle gives me. Perhaps not the best method but it's faster
than reading through the spec.

I managed to get a seg-fault with the following query.

select salary,dense_rank() over (order by salary desc)
from employee
group by salary;


It's the group by that does it.

test=# select salary,dense_rank() over (order by salary desc) from employee
group by salary;
server closed the connection unexpectedly       This probably means the server terminated abnormally       before or
whileprocessing the request. 
The connection to the server was lost. Attempting reset: Failed.


It seems to be possible to crash not just dense_rank() and rank().

This crashes too.

select relid,AVG(seq_Scan) OVER (ORDER BY relid)
FROM pg_stat_user_tables
GROUP BY relid,seq_scan;

Oracle allows both these queries.

Of course I changed table names and column names to make the test case a bit
easier to re-produce.

Looking forward to seeing windowing functions in 8.4!

David



pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Website request -- developer docs along with release docs
Next
From: "Hitoshi Harada"
Date:
Subject: Re: Window Functions: v07 APIs and buffering strateties