testing nested case-when scoping

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Subject: testing nested case-when scoping
Date: 2011-06-15 11:43:35
Message-ID: BANLkTikJt3wab9XSisT-NUBh1jeC3q=yiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello Heikki,

probably I found a bug in patch:

CREATE FUNCTION fx(i integer) RETURNS integer
LANGUAGE plpgsql
AS $$begin raise notice '>>%<<', i; return i; end;$$;

CREATE FUNCTION fx1(integer) RETURNS text
LANGUAGE sql
AS $_$ select case $1 when 1 then 'A' else 'B' end$_$;

CREATE FUNCTION fx2(text) RETURNS text
LANGUAGE sql
AS $_$ select case $1 when 'A' then 'a' else 'b' end$_$;

CREATE TABLE foo (
a integer
);

COPY foo (a) FROM stdin;
1
0
\.

postgres=# select fx2(fx1(fx(a))) from foo;
NOTICE: >>1<<
ERROR: invalid expression parameter reference (1 levels up, while
stack is only 1 elements deep)

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-06-15 12:02:59 Re: pg_upgrade using appname to lock out other users
Previous Message Dave Page 2011-06-15 11:16:01 Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name