Skip site navigation (1) Skip section navigation (2)

Window function bug

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Window function bug
Date: 2011-07-12 00:48:06
Message-ID: 1310431686.497.26.camel@jdavis-ux.asterdata.local (view raw or flat)
Thread:
Lists: pgsql-bugs
In branch postgresql/master:

SELECT SUM(SUM(a)) OVER ()
 FROM (SELECT NULL::int4 AS a WHERE FALSE) R;

ERROR:  XX000: cannot extract attribute from empty tuple slot

Honestly, I'm not sure what the semantics of that are supposed to be. Is
it even allowed by the standard?

Regards,
	Jeff Davis


Responses

pgsql-bugs by date

Next:From: Dave PageDate: 2011-07-12 01:03:53
Subject: Re: application_name appears in Reporting and logging
Previous:From: Bruce MomjianDate: 2011-07-12 00:41:47
Subject: Re: BUG #6085: pg_upgrade fails when unix_socket_directory != /tmp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group