HAWQ-860. Fix ORCA wrong plan when correlated subquery contains set-returning functions
ORCA 1.633 returns wrong result for the following query: 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: ?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 Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/e10f9a4e Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/e10f9a4e Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/e10f9a4e Branch: refs/heads/master Commit: e10f9a4e17f3012bb5afb98c53172dedefc8854e Parents: decbe0d Author: Haisheng Yuan <[email protected]> Authored: Thu Jul 14 14:59:47 2016 -0700 Committer: Ming LI <[email protected]> Committed: Mon Aug 1 10:28:44 2016 +0800 ---------------------------------------------------------------------- depends/thirdparty/gporca.commit | 2 +- src/backend/gpopt/ivy.xml | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/e10f9a4e/depends/thirdparty/gporca.commit ---------------------------------------------------------------------- diff --git a/depends/thirdparty/gporca.commit b/depends/thirdparty/gporca.commit index c576ae2..09feed4 100644 --- a/depends/thirdparty/gporca.commit +++ b/depends/thirdparty/gporca.commit @@ -1 +1 @@ -https://github.com/greenplum-db/gporca.git master 0d837569e61182f68bf1b92038c6616401790a16 +https://github.com/greenplum-db/gporca.git master 52030fd9cf56b32523f1712b094b1a2f8da8505c http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/e10f9a4e/src/backend/gpopt/ivy.xml ---------------------------------------------------------------------- diff --git a/src/backend/gpopt/ivy.xml b/src/backend/gpopt/ivy.xml index 43423eb..9aa469d 100644 --- a/src/backend/gpopt/ivy.xml +++ b/src/backend/gpopt/ivy.xml @@ -38,7 +38,7 @@ under the License. </configurations> <dependencies> - <dependency org="emc" name="optimizer" rev="1.633" conf="osx106_x86->osx106_x86_32;osx106_x86_32->osx106_x86_32;rhel5_x86_64->rhel5_x86_64;suse10_x86_64->suse10_x86_64" /> + <dependency org="emc" name="optimizer" rev="1.634" conf="osx106_x86->osx106_x86_32;osx106_x86_32->osx106_x86_32;rhel5_x86_64->rhel5_x86_64;suse10_x86_64->suse10_x86_64" /> <dependency org="emc" name="libgpos" rev="1.137" conf="osx106_x86->osx106_x86_32;osx106_x86_32->osx106_x86_32;rhel5_x86_64->rhel5_x86_64;suse10_x86_64->suse10_x86_64" /> <dependency org="xerces" name="xerces-c" rev="3.1.1-p1" conf="osx106_x86->osx106_x86_32;osx106_x86_32->osx106_x86_32;rhel5_x86_64->rhel5_x86_64;suse10_x86_64->suse10_x86_64" /> </dependencies>
