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

[Ruilong Huo (JIRA)]

Ruilong Huo created HAWQ-821:
--------------------------------

             Summary: 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: George Caragea


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)