You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Lirong Jian (JIRA)" <ji...@apache.org> on 2015/10/28 09:00:37 UTC
[jira] [Resolved] (HAWQ-92) UDF could not serialize unrecognized
node
[ https://issues.apache.org/jira/browse/HAWQ-92?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lirong Jian resolved HAWQ-92.
-----------------------------
Resolution: Fixed
> 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)