You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/10/28 08:45:27 UTC
[jira] [Commented] (HAWQ-92) UDF could not serialize unrecognized
node
[ https://issues.apache.org/jira/browse/HAWQ-92?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14977907#comment-14977907 ]
ASF GitHub Bot commented on HAWQ-92:
------------------------------------
GitHub user jianlirong opened a pull request:
https://github.com/apache/incubator-hawq/pull/52
HAWQ-92. Add a copy function for SegFileSplitMapNode
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/jianlirong/incubator-hawq HAWQ-92
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/52.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #52
----
commit ef3bf6a7847f12cf6a11caca21dc844271090a74
Author: Lirong Jian <ji...@gmail.com>
Date: 2015-10-28T07:38:45Z
HAWQ-92. Add a copy function for SegFileSplitMapNode
----
> 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)