Re: review: More frame options in window functions
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Hitoshi Harada <umi.tanuki@gmail.com>
Cc: Erik Rijkers <er@xs4all.nl>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-01-16T12:26:30Z
Lists: pgsql-hackers
2010/1/16 Hitoshi Harada <umi.tanuki@gmail.com>: > 2010/1/16 Erik Rijkers <er@xs4all.nl>: >> >>> Thanks for the review. I've found another crash today and attached is >>> fixed version. The case is: >>> >>> SELECT four, sum(ten) over (PARTITION BY four ORDER BY four RANGE 1 >>> PRECEDING) FROM tenk1 WHERE unique1 < 10; >>> >> >> Hi, >> >> The patch (more_frame_options.20100115.patch.gz) applies cleanly, but the regression test gives: on fedora 32 bit is all ok. I'll check it on 64bit fedora on Monday. Regards Pavel > > It doesn't happen here. Could you send more information like configure > options and EXPLAIN output of that query? > > Regards, > > > -- > Hitoshi Harada > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >