[jira] [Closed] (HAWQ-92) UDF could not serialize unrecognized node

["Lei Chang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-92?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lei Chang closed HAWQ-92.
-------------------------

> UDF could not serialize unrecognized node
> -----------------------------------------
>
>                 Key: HAWQ-92
>                 URL: https://issues.apache.org/jira/browse/HAWQ-92
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Core
>            Reporter: Lirong Jian
>            Assignee: Lirong Jian
>             Fix For: 2.0.0-beta-incubating
>
>
> This issue can be reproduced by the following steps:
> postgres=# CREATE TABLE func_call_modes_data ( c1 INT, c2 INT ) DISTRIBUTED BY (c1);
> CREATE TABLE
> postgres=# INSERT INTO func_call_modes_data SELECT i, i FROM generate_series(1,3) i;
> INSERT 0 3
> postgres=# CREATE OR REPLACE FUNCTION func_plpgsql() RETURNS SETOF func_call_modes_data
> postgres-# AS $$
> postgres$#         DECLARE r
> postgres$#                 func_call_modes_data%rowtype;
> postgres$#         BEGIN
> postgres$#                 FOR r IN SELECT * FROM func_call_modes_data ORDER BY c1
> postgres$#                 LOOP
> postgres$#                 RETURN NEXT r;
> postgres$#                 END LOOP;
> postgres$#         RETURN;
> postgres$# END
> postgres$# $$ LANGUAGE PLPGSQL;
> CREATE FUNCTION
> postgres=# SELECT func_plpgsql();
> ERROR:  could not serialize unrecognized node type: 2139062143 (outfast.c:4737)
> CONTEXT:  PL/pgSQL function "func_plpgsql" line 4 at for over select rows



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)