BUG #8393: "ERROR: failed to locate grouping columns" on grouping by varchar returned from function

From: postgresql(at)realityexists(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8393: "ERROR: failed to locate grouping columns" on grouping by varchar returned from function
Date: 2013-08-23 08:25:15
Message-ID: E1VCmgF-0001uF-9I@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8393
Logged by: Evan Martin
Email address: postgresql(at)realityexists(dot)net
PostgreSQL version: 9.2.4
Operating system: Windows 7 x64 SP1
Description:

version(): PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit

Run the following:

CREATE OR REPLACE FUNCTION test_group_by()
RETURNS TABLE (my_col varchar(5))
AS $BODY$
SELECT 'hello'::varchar(5);
$BODY$ LANGUAGE sql STABLE;

SELECT my_col
FROM test_group_by()
GROUP BY 1;

Expected result:

'hello'

Actual result:

ERROR: failed to locate grouping columns

Interestingly, if the function is marked "VOLATILE" it works. Casting the
result to "text" also makes it work.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Valdas Dienas 2013-08-23 12:16:53 PG_restore
Previous Message ダンミンフーン 2013-08-23 00:56:30 Re: After promote, DB can not UPDATE with SAVEPOINT (could not access status of transaction 1409172)