Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hawq.incubator.apache.org
Date: Wed, 15 Jun 2016 08:33:09 +0000 (UTC)
From: "Ruilong Huo (JIRA)" <jira@apache.org>
To: dev@hawq.incubator.apache.org
Message-ID: <JIRA.12979299.1465979577000.2733.1465979589569@Atlassian.JIRA>
In-Reply-To: <JIRA.12979299.1465979577000@Atlassian.JIRA>
References: <JIRA.12979299.1465979577000@Atlassian.JIRA> <JIRA.12979299.1465979577721@arcas>
Subject: [jira] [Created] (HAWQ-821) Inner function does not exist while
 invoking from outer function on mac osx
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 15 Jun 2016 08:33:13 -0000

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)