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

["Lirong Jian (JIRA)" <ji...@apache.org>]

Lirong Jian created HAWQ-92:
-------------------------------

             Summary: 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: Lei Chang


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)