[ https://issues.apache.org/jira/browse/HAWQ-92?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14977932#comment-14977932 ]
ASF GitHub Bot commented on HAWQ-92: ------------------------------------ Github user asfgit closed the pull request at: https://github.com/apache/incubator-hawq/pull/52 > 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 > > 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)