[
https://issues.apache.org/jira/browse/HAWQ-860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15378337#comment-15378337
]
ASF GitHub Bot commented on HAWQ-860:
-------------------------------------
GitHub user hsyuan opened a pull request:
https://github.com/apache/incubator-hawq/pull/795
HAWQ-860. Fix ORCA wrong plan when correlated subquery contains
set-returning functions
ORCA 1.633 returns wrong result for the following query:
```sql
select 0 is distinct from (select count(1) from (select unnest(array[1, 2,
3])) as foo);
?column?
----------
t
t
t
(3 rows)
```
Correct result should be:
```sql
?column?
----------
t
(1 row)
```
This bug was fixed by bumping ORCA version to 1.634.
For detail information, see ORCA pull request:
https://github.com/greenplum-db/gporca/pull/49
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/hsyuan/incubator-hawq HAWQ-860
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/795.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 #795
----
commit eef9fe3c330119bdeaecc8f5b18382d1b9568e46
Author: Haisheng Yuan and Omer Arap <[email protected]>
Date: 2016-07-14T19:16:40Z
Fix ORCA wrong plan when correlated subquery contains set-returning
functions
----
> Optimizer generates wrong plan when correlated subquery contains
> set-returning functions
> ----------------------------------------------------------------------------------------
>
> Key: HAWQ-860
> URL: https://issues.apache.org/jira/browse/HAWQ-860
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Optimizer
> Reporter: Venkatesh
> Assignee: Amr El-Helw
>
> Bump ORCA to 1.634 [#119042413]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
