[jira] [Assigned] (HAWQ-821) Inner function does not exist while invoking from outer function on mac osx

["Ruilong Huo (JIRA)" <ji...@apache.org>]

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

Ruilong Huo reassigned HAWQ-821:
--------------------------------

    Assignee: Ruilong Huo  (was: George Caragea)

> Inner function does not exist while invoking from outer function on mac osx
> ---------------------------------------------------------------------------
>
>                 Key: HAWQ-821
>                 URL: https://issues.apache.org/jira/browse/HAWQ-821
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Query Execution
>            Reporter: Ruilong Huo
>            Assignee: Ruilong Huo
>
> In suite of function basics in new feature test framework, inner function does not exist while invoking from outer function on mac osx. It works on rhel 6.x.
>  
> {noformat}
> -- 1. prepare schema and data
> DROP TABLE IF EXISTS foo;
> CREATE TABLE foo AS SELECT * FROM generate_series(1, 10) x;
> CREATE FUNCTION inner(int) RETURNS INTEGER AS 'SELECT 1' LANGUAGE SQL IMMUTABLE;
> CREATE FUNCTION outer(x INT) RETURNS INT AS $$
> BEGIN
> RETURN inner(x);
> END
> $$ LANGUAGE PLPGSQL;
> -- 2. run query on mac errors out with inner function does not exist
> SELECT outer(0);
>  outer
> -------
>      1
> (1 row)
> SELECT outer(0) FROM foo;
> ERROR:  function inner(integer) does not exist  (seg2 localhost:40000 pid=30499)
> DETAIL:  PL/pgSQL function "outer" line 2 at return
> -- 3. run query on rhel 6.x succeed
> SELECT outer(0);
>  outer
> -------
>      1
> (1 row)
> SELECT outer(0) FROM foo;
>  outer
> -------
>      1
>      1
>      1
>      1
>      1
>      1
>      1
>      1
>      1
>      1
> (10 rows)
> -- 4. clean up
> DROP FUNCTION outer(int)
> DROP FUNCTION inner(int);
> {noformat}



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