Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id CF764200B63 for ; Mon, 1 Aug 2016 04:54:43 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id CE09E160AA9; Mon, 1 Aug 2016 02:54:43 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 208A1160A81 for ; Mon, 1 Aug 2016 04:54:42 +0200 (CEST) Received: (qmail 75786 invoked by uid 500); 1 Aug 2016 02:54:37 -0000 Mailing-List: contact commits-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list commits@hawq.incubator.apache.org Received: (qmail 75777 invoked by uid 99); 1 Aug 2016 02:54:37 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Aug 2016 02:54:37 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 1E864C041B for ; Mon, 1 Aug 2016 02:54:37 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -4.646 X-Spam-Level: X-Spam-Status: No, score=-4.646 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-1.426] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id LWrchKH26z41 for ; Mon, 1 Aug 2016 02:54:33 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id 516AA5FB8F for ; Mon, 1 Aug 2016 02:54:32 +0000 (UTC) Received: (qmail 75403 invoked by uid 99); 1 Aug 2016 02:54:31 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Aug 2016 02:54:31 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 4F767E2C1A; Mon, 1 Aug 2016 02:54:31 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: mli@apache.org To: commits@hawq.incubator.apache.org Date: Mon, 01 Aug 2016 02:54:32 -0000 Message-Id: <16f1508361634dfc8826730d3db197e0@git.apache.org> In-Reply-To: <19086b79c1c440e18edcd0c1121092e2@git.apache.org> References: <19086b79c1c440e18edcd0c1121092e2@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [2/5] incubator-hawq git commit: HAWQ-860. Fix ORCA wrong plan when correlated subquery contains set-returning functions archived-at: Mon, 01 Aug 2016 02:54:44 -0000 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 Authored: Thu Jul 14 14:59:47 2016 -0700 Committer: Ming LI 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. - +