hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From m..@apache.org
Subject [2/5] incubator-hawq git commit: HAWQ-860. Fix ORCA wrong plan when correlated subquery contains set-returning functions
Date Mon, 01 Aug 2016 02:54:32 GMT
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 <hyuan@pivotal.io>
Authored: Thu Jul 14 14:59:47 2016 -0700
Committer: Ming LI <mli@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>


Mime
View raw message