Bug #662: In plpgsql, returning "text" instead of "setof text" puts backend in infinite loop

Kristis Makris (kristis(dot)makris(at)datasoft(dot)com) reports a bug with a severity of 4
The lower the number the more severe it is.

Short Description
In plpgsql, returning "text" instead of "setof text" puts backend in infinite loop

Long Description
This was run against postgres 7.1.3. While experimenting with "setof" in writing a plpgsql function I came across a case where if text is returned in place of setof text, the backend never came up with a reply. top reported the postmaster running at %99.9 until I Ctrl-C'ed.

Sure, text should not be returned in place of setof text, but still...

=# select AAA(now());

Cancel request sent
ERROR: Query was cancelled.
=#

Sample Code
create function AAA(date) returns setof text as '
declare
-- _date alias for $1;

_reads text;
begin

return _reads;
end;
' language 'plpgsql';

SELECT AAA(now());

No file was uploaded with this report