[
https://issues.apache.org/jira/browse/HAWQ-821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruilong Huo resolved HAWQ-821.
------------------------------
Resolution: Not A Bug
Fix Version/s: 2.0.0
Resolved as "Not A Bug" since it is expected behaviour per investigation.
> 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
> Affects Versions: 2.0.0
> Reporter: Ruilong Huo
> Assignee: Ruilong Huo
> Fix For: 2.0.0
>
>
> 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)
