Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hiKLF-0002H4-46 for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Jul 2019 15:05:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hiKLC-0000Lq-UT for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Jul 2019 15:05:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hiKLC-0000Lh-Mh for pgsql-bugs@lists.postgresql.org; Tue, 02 Jul 2019 15:05:06 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hiKL9-0001rX-HV for pgsql-bugs@lists.postgresql.org; Tue, 02 Jul 2019 15:05:06 +0000 Content-Type: multipart/mixed; boundary="===============0507771141111920623==" MIME-Version: 1.0 Subject: BUG #15884: json_object_agg errors on null in field name To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: muhlemmer@gmail.com Reply-To: muhlemmer@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 02 Jul 2019 15:04:15 +0000 Message-ID: <15884-c32d848f787fcae3@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0507771141111920623== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTg4NApMb2dnZWQgYnk6ICAgICAgICAgIFRpbSBNw7ZobG1hbm4KRW1h aWwgYWRkcmVzczogICAgICBtdWhsZW1tZXJAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTEuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIEdlbnRvbyBsaW51eCAoc3RhYmxlKQpEZXNjcmlwdGlv bjogICAgICAgIAoKQWNjb3JkaW5nIHRvIHRoZSBkb2N1bWVudGF0aW9uIG9uIGFnZ3JlZ2F0ZSBl eHByZXNzaW9uczoNCg0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMS9zcWwtZXhw cmVzc2lvbnMuaHRtbCNTWU5UQVgtQUdHUkVHQVRFUw0KIk1vc3QgYWdncmVnYXRlIGZ1bmN0aW9u cyBpZ25vcmUgbnVsbCBpbnB1dHMsIHNvIHRoYXQgcm93cyBpbiB3aGljaCBvbmUgb3IKbW9yZSBv ZiB0aGUgZXhwcmVzc2lvbihzKSB5aWVsZCBudWxsIGFyZSBkaXNjYXJkZWQuIFRoaXMgY2FuIGJl IGFzc3VtZWQgdG8KYmUgdHJ1ZSwgdW5sZXNzIG90aGVyd2lzZSBzcGVjaWZpZWQsIGZvciBhbGwg YnVpbHQtaW4gYWdncmVnYXRlcy4iDQoNCk9uIGFnZ3JlZ2F0ZSBmdW5jdGlvbiBkb2N1bWVudGF0 aW9uIG5vIHNwZWNpZmljIG1lbnRpb24gaXMgbWFkZSBmb3IKanNvbl9vYmplY3RfYWdnKCkuCmh0 dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTEvZnVuY3Rpb25zLWFnZ3JlZ2F0ZS5odG1s DQoNCkhvd2V2ZXIsIGpzb25fb2JqZWN0X2FnZygpIHRocm93cyBhbiBlcnJvciBpbiBjYXNlIG9m IG51bGwgaW4gdGhlCmFyZ3VtZW50KHMpOiAiZXJyb3I6IGZpZWxkIG5hbWUgbXVzdCBub3QgYmUg bnVsbCIuIEFuZCBJIGdldCBpdCwgSlNPTiBrZXlzCm5lZWQgdG8gYmUgdW5pcXVlIHN0cmluZ3Mg YW5kIG51bGwgaXMgbm90IHRoYXQuIEhvd2V2ZXIsIHRoaXMgZXJyb3IgaXMgYWxzbwp0aHJvd24g aWYgYm90aCBrZXlzIGFuZCB2YWx1ZXMgYXJlIGFuIGVtcHR5IENURSByZXN1bHQuDQoNCkluIHRo ZSBmb2xsb3dpbmcgZXhhbXBsZSB0aGVyZSBhcmUgcGFnZXMuIEVhY2ggcGFnZSBoYXMgc2VjdGlv bnMgYW5kIGVhY2gKc2VjdGlvbnMgaGFzIHRleHQgZmllbGRzICh0ZXh0cykuIEl0IGlzIGEgc2lt cGxpZmllZCB2ZXJzaW9uIG9mIG15IGFwcCdzCnF1ZXJ5LiBXaGVuIHRoZXJlIGlzIGEgcGFnZSB3 aXRob3V0IHNlY3Rpb25zIGpzb25fb2JqZWN0X2FnZygpIGdldHMgdGhlCmVtcHR5IHJlc3VsdCBm b3IgInMudGl0bGUiIGFuZCB0aGUgbmVzdGVkIGpzb25fYnVpbGRfb2JqZWN0KCkgY2FsbC4NCg0K Y3JlYXRlIHRhYmxlIHBhZ2VzICgNCiAgICBwYWdlX2lkIHNlcmlhbCBwcmltYXJ5IGtleSwNCiAg ICBkb21haW4gdGV4dCB1bmlxdWUgbm90IG51bGwNCik7DQoNCmNyZWF0ZSB0YWJsZSBzZWN0aW9u cyAoDQogICAgc2VjdGlvbl9pZCBzZXJpYWwgcHJpbWFyeSBrZXksDQogICAgdGl0bGUgdGV4dCBu b3QgbnVsbCwNCiAgICBwYWdlX2lkIGludCByZWZlcmVuY2VzIHBhZ2VzDQopOw0KDQpjcmVhdGUg dGFibGUgdGV4dHMgKA0KICAgIHNlY3Rpb25faWQgaW50IHJlZmVyZW5jZXMgc2VjdGlvbnMsDQog ICAgcG9zIGludCBub3QgbnVsbCwNCiAgICBjb250ZW50IHRleHQgbm90IG51bGwsDQogICAgcHJp bWFyeSBrZXkgKHNlY3Rpb25faWQsIHBvcykNCik7DQoNCi0tIHNwYW5hYy5jb20gd2lsbCBoYXZl IDMgc2VjdGlvbnMgd2l0aCB0ZXh0cyBhbmQgaW1hZ2VzIGluIGVhY2gsIHZhcmlvdXMKYW1vdW50 cw0KaW5zZXJ0IGludG8gcGFnZXMgKGRvbWFpbikgdmFsdWVzICgnc3BhbmFjLmNvbScpOw0KLS0g Zm9vLmNvbSBoYXMgMSBlbXB0eSBzZWN0aW9uDQppbnNlcnQgaW50byBwYWdlcyAoZG9tYWluKSB2 YWx1ZXMgKCdmb28uY29tJyk7DQotLSBiYXIuY29tIGhhcyBubyBzZWN0aW9ucw0KaW5zZXJ0IGlu dG8gcGFnZXMgKGRvbWFpbikgdmFsdWVzICgnYmFyLmNvbScpOw0KDQotLSBzcGFuYWMuY29tDQoN CndpdGggcyBhcyAoDQogICAgaW5zZXJ0IGludG8gc2VjdGlvbnMgKHBhZ2VfaWQsIHRpdGxlKSBz ZWxlY3QgcGFnZV9pZCwgJ2ZpcnN0JyBmcm9tIHBhZ2VzCndoZXJlIGRvbWFpbiA9ICdzcGFuYWMu Y29tJyByZXR1cm5pbmcgc2VjdGlvbl9pZA0KKSwNCnQxIGFzICgNCiAgICBpbnNlcnQgaW50byB0 ZXh0cyAoc2VjdGlvbl9pZCwgcG9zLCBjb250ZW50KSBzZWxlY3Qgc2VjdGlvbl9pZCwgMSwKJ3Nw YW5hYyBvbmUub25lJyBmcm9tIHMNCikNCmluc2VydCBpbnRvIHRleHRzIChzZWN0aW9uX2lkLCBw b3MsIGNvbnRlbnQpIHNlbGVjdCBzZWN0aW9uX2lkLCAyLCAnc3BhbmFjCm9uZS50d28nIGZyb20g czsNCg0Kd2l0aCBzIGFzICgNCiAgICBpbnNlcnQgaW50byBzZWN0aW9ucyAocGFnZV9pZCwgdGl0 bGUpIHNlbGVjdCBwYWdlX2lkLCAnc2Vjb25kJyBmcm9tCnBhZ2VzIHdoZXJlIGRvbWFpbiA9ICdz cGFuYWMuY29tJyByZXR1cm5pbmcgc2VjdGlvbl9pZA0KKSwNCnQxIGFzICgNCiAgICBpbnNlcnQg aW50byB0ZXh0cyAoc2VjdGlvbl9pZCwgcG9zLCBjb250ZW50KSBzZWxlY3Qgc2VjdGlvbl9pZCwg MSwKJ3NwYW5hYyB0d28ub25lJyBmcm9tIHMNCikNCmluc2VydCBpbnRvIHRleHRzIChzZWN0aW9u X2lkLCBwb3MsIGNvbnRlbnQpIHNlbGVjdCBzZWN0aW9uX2lkLCAyLCAnc3BhbmFjCnR3by50d28n IGZyb20gczsNCg0KLS0gZm9vLmNvbQ0KDQppbnNlcnQgaW50byBzZWN0aW9ucyAocGFnZV9pZCwg dGl0bGUpIHNlbGVjdCBwYWdlX2lkLCAnZW1wdHknIGZyb20gcGFnZXMKd2hlcmUgZG9tYWluID0g J2Zvby5jb20nOw0KDQpBbmQgdGhpcyBpcyB0aGUgcXVlcnkgdGhhdCB0cmlnZ2VycyB0aGUgZXJy b3I6DQoNCndpdGggc2VjcyBhcyAoDQoJc2VsZWN0IHAucGFnZV9pZCwgcC5kb21haW4sIHMuc2Vj dGlvbl9pZCBhcyBzaWQsIHMudGl0bGUgYXMgdGl0bGUNCglmcm9tIHBhZ2VzIHANCglsZWZ0IGpv aW4gc2VjdGlvbnMgcyBvbiBwLnBhZ2VfaWQgPSBzLnBhZ2VfaWQNCgl3aGVyZSBwLmRvbWFpbiA9 ICdiYXIuY29tJyAtLSAnZm9vLmNvbScgYW5kICdzcGFuYWMuY29tJyB3b3JrIGZpbmUNCiksDQp0 eHQgYXMgKA0KCXNlbGVjdA0KCQlzaWQsDQoJCWpzb25fYWdnKA0KCQkJanNvbl9idWlsZF9vYmpl Y3QoDQoJCQkJJ1BvcycsIHBvcywNCgkJCQknVGV4dCcsIGNvbnRlbnQNCgkJCSkNCgkJCW9yZGVy IGJ5IHBvcyBhc2MNCgkJKSBhcyB0eHRzDQoJZnJvbSB0ZXh0cw0KCWpvaW4gc2VjcyBvbiBzaWQg PSBzZWN0aW9uX2lkDQoJZ3JvdXAgYnkgc2lkDQopDQpzZWxlY3QNCglqc29uX2J1aWxkX29iamVj dCgNCgkJJ0lEJywgcy5wYWdlX2lkLA0KICAgICAgICAnRG9tYWluJywgZG9tYWluLA0KCQknU2Vj dGlvbnMnLCBqc29uX29iamVjdF9hZ2cgKCAtLSBFcnJvciBvY2N1cnMgaGVyZQ0KCQkJcy50aXRs ZSwNCiAgICAgICAgICAJanNvbl9idWlsZF9vYmplY3QoDQoJCQkJJ0lEJywgcy5zaWQsDQoJCQkJ J1RleHRzJywgdC50eHRzDQoJCQkpDQoJCQlvcmRlciBieSBzLnNpZCBhc2MNCgkJKQ0KCSkNCmZy b20gc2VjcyBzDQpsZWZ0IGpvaW4gdHh0IHQgb24gcy5zaWQgPSB0LnNpZA0KZ3JvdXAgYnkgcy5w YWdlX2lkLCBkb21haW47DQoNClRoZSBhYm92ZSBpcyBhbHNvIGF2YWlsYWJsZSBpbiBhIGZpZGRs ZSwgYWx0aG91Z2ggaXQgZG9lcyBub3QgbWF0Y2ggdGhlClBvc3RncmVTUUwgdmVyc2lvbjogaHR0 cHM6Ly93d3cuZGItZmlkZGxlLmNvbS9mL256Wno3ampyRFNBWUt0WUs1M2J6N0wvMQ0KDQpJJ3Zl IGFza2VkIGEgcXVlc3Rpb24gcmVnYXJkaW5nIHRoaXMgb246Cmh0dHBzOi8vZGJhLnN0YWNrZXhj aGFuZ2UuY29tL3EvMjQxNTQxLzE1MDM5OC4gVGhlIGFuc3dlciBJIGdvdCBpcyB0aGF0IHRoaXMK bWlnaHQgYmUgYSBidWcsIGhlbmNlIEknbSBwb3N0aW5nIGhlcmUuIFR3byBub3RlczoNCjEuIEkg Y2Fubm90IHJlcHJvZHVjZSB0aGlzIHdoZW4gSSBzaW1wbGlmeSB0aGUgcXVlcnkgaW50byBub3Qg dXNpbmcgYSBDVEUKYW5kIG5lc3RlZCBqc29uX2J1aWxkX29iamVjdCgpDQoyLiBJICJibGFtZSIg anNvbl9vYmplY3RfYWdnKCkiLCBiZWNhdXNlIEkgdXNlZCBhIHJlZ3VsYXIganNvbl9hZ2coKSB3 aXRob3V0CnRoZSBzLnRpdGxlIGZpZWxkcyBiZWZvcmUgYW5kIGl0IHdvcmtlZCBmaW5lLiBBcyBp biwgdGhlIHJlc3VsdGluZyBqc29uCmRvY3VtZW50IGp1c3QgaGFkICJTZWN0aW9ucyI6IG51bGwu DQoNCkJlc3QgcmVnYXJkcywgVGltIE1vaGxtYW5uIChtdWhsZW1tZXIpCgo= --===============0507771141111920623==--