Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ea35y-0007xL-F1 for pgsql-committers@arkaria.postgresql.org; Fri, 12 Jan 2018 17:26:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ea35x-00077l-P4 for pgsql-committers@arkaria.postgresql.org; Fri, 12 Jan 2018 17:26:21 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ea34j-00033m-ML for pgsql-committers@lists.postgresql.org; Fri, 12 Jan 2018 17:25:05 +0000 Received: from mahout.postgresql.org ([2001:4800:1501:1::227]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ea34g-0000OJ-1s for pgsql-committers@postgresql.org; Fri, 12 Jan 2018 17:25:03 +0000 Received: from gemulon.postgresql.org ([2001:4800:1501:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1ea34f-0002Fq-4I for pgsql-committers@postgresql.org; Fri, 12 Jan 2018 17:25:01 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.84_2) (envelope-from ) id 1ea34e-0001Gr-Px for pgsql-committers@postgresql.org; Fri, 12 Jan 2018 17:25:00 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@postgresql.org From: Tom Lane Subject: pgsql: Fix incorrect handling of subquery pullup in the presence of gro Message-Id: Date: Fri, 12 Jan 2018 17:25:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Rml4IGluY29ycmVjdCBoYW5kbGluZyBvZiBzdWJxdWVyeSBwdWxsdXAgaW4gdGhlIHByZXNlbmNl IG9mIGdyb3VwaW5nIHNldHMuCgpJZiB3ZSBmbGF0dGVuIGEgc3VicXVlcnkgd2hvc2UgdGFyZ2V0 IGxpc3QgY29udGFpbnMgY29uc3RhbnRzIG9yCmV4cHJlc3Npb25zLCB3aGVuIHRob3NlIG91dHB1 dCBjb2x1bW5zIGFyZSB1c2VkIGluIEdST1VQSU5HIFNFVCBjb2x1bW5zLAp0aGUgcGxhbm5lciB3 YXMgY2FwYWJsZSBvZiBkb2luZyB0aGUgd3JvbmcgdGhpbmcgYnkgbWVyZ2luZyBhIHB1bGxlZC11 cApleHByZXNzaW9uIGludG8gdGhlIHN1cnJvdW5kaW5nIGV4cHJlc3Npb24gZHVyaW5nIGNvbnN0 LXNpbXBsaWZpY2F0aW9uLgpUaGVuIHRoZSBsYXRlIHByb2Nlc3NpbmcgdGhhdCBhdHRlbXB0cyB0 byBtYXRjaCBzdWJleHByZXNzaW9ucyB0byBncm91cGluZwpzZXRzIHdvdWxkIGZhaWwgdG8gbWF0 Y2ggdGhvc2Ugc3ViZXhwcmVzc2lvbnMgdG8gZ3JvdXBpbmcgc2V0cywgd2l0aCB0aGUKZWZmZWN0 IHRoYXQgdGhleSdkIG5vdCBnbyB0byBudWxsIHdoZW4gZXhwZWN0ZWQuCgpUbyBmaXgsIHdyYXAg c3VjaCBzdWJxdWVyeSBvdXRwdXRzIGluIFBsYWNlSG9sZGVyVmFycywgZW5zdXJpbmcgdGhhdAp0 aGV5IHByZXNlcnZlIHRoZWlyIHNlcGFyYXRlIGlkZW50aXR5IHRocm91Z2hvdXQgdGhlIHBsYW5u ZXIncyBleHByZXNzaW9uCnByb2Nlc3NpbmcuICBUaGlzIGlzIGEgYml0IG9mIGEgYmFuZC1haWQs IGJlY2F1c2UgdGhlIHdyYXBwZXIgZGVmZWF0cwpjb25zdC1zaW1wbGlmaWNhdGlvbiBldmVuIGlu IHBsYWNlcyB3aGVyZSBpdCB3b3VsZCBiZSBzYWZlIHRvIGFsbG93LgpCdXQgYSBuaWNlciBmaXgg d291bGQgbGlrZWx5IGJlIHRvbyBpbnZhc2l2ZSB0byBiYWNrLXBhdGNoLCBhbmQgdGhlCmNvbnNl cXVlbmNlcyBvZiB0aGUgbWlzc2VkIG9wdGltaXphdGlvbnMgcHJvYmFibHkgYXJlbid0IGxhcmdl IGluIG1vc3QKY2FzZXMuCgpCYWNrLXBhdGNoIHRvIDkuNSB3aGVyZSBncm91cGluZyBzZXRzIHdl cmUgaW50cm9kdWNlZC4KCkhlaWtraSBMaW5uYWthbmdhcywgd2l0aCBzbWFsbCBtb2RzIGFuZCBi ZXR0ZXIgdGVzdCBjYXNlcyBieSBtZTsKYWRkaXRpb25hbCByZXZpZXcgYnkgQW5kcmV3IEdpZXJ0 aAoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS83ZGJkY2Y1Yy1iNWE2LWVmODktNDk1 OC1kYTIxMmZlMTAxNzZAaWtpLmZpCgpCcmFuY2gKLS0tLS0tClJFTDlfNl9TVEFCTEUKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzY1MjBk NGE5NjkyODgyYTdkNTIzM2RhYzQwYzRiN2ZmMDdmNTUwNDkKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wcmVwL3ByZXBqb2ludHJlZS5jICB8IDQ4 ICsrKysrKysrKysrKysrKysrKysrKysrKystLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVk L2dyb3VwaW5nc2V0cy5vdXQgfCA0NSArKysrKysrKysrKysrKysrKysrKysrKysrKysrCnNyYy90 ZXN0L3JlZ3Jlc3Mvc3FsL2dyb3VwaW5nc2V0cy5zcWwgICAgICB8IDIwICsrKysrKysrKysrKysK MyBmaWxlcyBjaGFuZ2VkLCAxMDUgaW5zZXJ0aW9ucygrKSwgOCBkZWxldGlvbnMoLSkKCg==