You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by ml...@apache.org on 2016/08/01 02:54:32 UTC
[2/5] incubator-hawq git commit: HAWQ-860. Fix ORCA wrong plan when
correlated subquery contains set-returning functions
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 <hy...@pivotal.io>
Authored: Thu Jul 14 14:59:47 2016 -0700
Committer: Ming LI <ml...@pivotal.io>
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>