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 1iuvH7-0000nf-0f for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Jan 2020 09:29:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iuvH5-0004e3-ES for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Jan 2020 09:29:11 +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 1iuvH5-0004dw-5b for pgsql-hackers@lists.postgresql.org; Fri, 24 Jan 2020 09:29:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1iuvGy-0003ax-M5 for pgsql-hackers@lists.postgresql.org; Fri, 24 Jan 2020 09:29:10 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iuvGw-0008J0-JN for pgsql-hackers@lists.postgresql.org; Fri, 24 Jan 2020 09:29:02 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1iuvGw-0000AR-5e for pgsql-hackers@lists.postgresql.org; Fri, 24 Jan 2020 09:29:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: BUG #16171: Potential malformed JSON in explain output To: pgsql-hackers@lists.postgresql.org From: Hamid Akhtar Cc: Daniel Gustafsson Date: Fri, 24 Jan 2020 09:28:50 +0000 User-Agent: pgcommitfest X-cfsender: hamidakhtar In-Reply-To: <495433FC-A268-4956-9B61-5FB135EE5B73@yesql.se> References: <16171-b72259ab75505fa2@postgresql.org> <495433FC-A268-4956-9B61-5FB135EE5B73@yesql.se> Message-ID: <157985813081.742.12901374861257824963.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgdGVzdGVkLCBwYXNzZWQK SW1wbGVtZW50cyBmZWF0dXJlOiAgICAgICB0ZXN0ZWQsIHBhc3NlZApTcGVjIGNvbXBsaWFudDog ICAgICAgICAgIHRlc3RlZCwgcGFzc2VkCkRvY3VtZW50YXRpb246ICAgICAgICAgICAgdGVzdGVk LCBwYXNzZWQKCkkndmUgcmV2aWV3ZWQgYW5kIHZlcmlmaWVkIHRoaXMgcGF0Y2ggYW5kIElNSE8s IHRoaXMgaXMgcmVhZHkgdG8gYmUgY29tbWl0dGVkLg0KDQoNClNvIEkgaGF2ZSB2ZXJpZmllZCB0 aGlzIHBhdGNoIGFnYWluc3QgdGhlIHRpcCBvZiBSRUxfMTJfU1RBQkxFIGJyYW5jaCAoY29tbWl0 IGM0Yzc2ZDE5KS4NCi0gZ2l0IGFwcGx5IDxwYXRjaD4gd29ya3Mgd2l0aG91dCBpc3N1ZXMuDQoN CkFsdGhvdWdoIHRoZSBwYXRjaCBkZXNjcmlwdGlvbiBtZW50aW9ucyB0aGF0IGl0IGZpeGVzIGEg bWFsZm9ybWVkIEpTT04gaW4gZXhwbGFpbiBvdXRwdXQgYnkgY3JlYXRpbmcgYSAiUGxhbiIgZ3Jv dXAsIHRoaXMgYWxzbyBmaXhlcyB0aGUgc2FtZSBtYWxmb3JtYXRpb24gaXNzdWUgZm9yIFhNTCBh bmQgWUFNTCBmb3JtYXRzLiBJdCBkb2VzIG5vdCBpbXBhY3QgdGhlIHRleHQgb3V0cHV0IHRob3Vn aC4NCg0KSSdtIHNoYXJpbmcgdGhlIHByb2JsZW1hdGljIHBhcnQgb2Ygb3V0cHV0IGZvciBhbiB1 bnBhdGNoZWQgdmVyc2lvbiBmb3IgSlNPTiwgWE1MLCBhbmQgWUFNTCBmb3JtYXRzOg0KLS0gSlNP Tg0KICAgICAgICJQbGFucyI6IFsNCiAgICAgICAgICJTdWJwbGFucyBSZW1vdmVkIjogMSwNCiAg ICAgICAgIHsNCiAgICAgICAgICAgIk5vZGUgVHlwZSI6ICJTZXEgU2NhbiIsDQoNCi0tIFhNTA0K ICAgICAgIDxQbGFucz4NCiAgICAgICAgIDxTdWJwbGFucy1SZW1vdmVkPjE8L1N1YnBsYW5zLVJl bW92ZWQ+DQogICAgICAgICA8UGxhbj4NCg0KLS0gWUFNTA0KICAgICBQbGFuczoNCiAgICAgICBT dWJwbGFucyBSZW1vdmVkOiAxDQogICAgICAgLSBOb2RlIFR5cGU6ICJTZXEgU2NhbiINCg0KVGhl IHBhdGNoZWQgdmVyc2lvbiBnaXZlcyB0aGUgZm9sbG93aW5nIGFuZCBjb3JyZWN0IG91dHB1dDoN Ci0tIEpTT04NCiAgICAgICAiUGxhbnMiOiBbDQogICAgICAgICB7DQogICAgICAgICAgICJTdWJw bGFucyBSZW1vdmVkIjogMQ0KICAgICAgICAgfSwgDQogICAgICAgICB7DQogICAgICAgICAgICJO b2RlIFR5cGUiOiAiU2VxIFNjYW4iLA0KDQotLSBYTUwNCiAgICAgICA8UGxhbnM+DQogICAgICAg ICA8UGxhbj4NCiAgICAgICAgICAgPFN1YnBsYW5zLVJlbW92ZWQ+MTwvU3VicGxhbnMtUmVtb3Zl ZD4NCiAgICAgICAgIDwvUGxhbj4NCiAgICAgICAgIDxQbGFuPg0KDQotLSBZQU1MDQogICAgIFBs YW5zOg0KICAgICAgIC0gU3VicGxhbnMgUmVtb3ZlZDogMQ0KICAgICAgIC0gTm9kZSBUeXBlOiAi U2VxIFNjYW4iDQoNCkZvbGxvd2luZyBpcyB0aGUgcXVlcnkgdGhhdCBJIHVzZWQgZm9yIHZhbGlk YXRpbmcgdGhlIG91dHB1dC4gSSBwaWNrZWQgaXQgdXAgKGFuZCBzaW1wbGlmaWVkKSBmcm9tICJz cmMvdGVzdC9yZWdyZXNzL3NxbC9wYXJ0aXRpb25fcHJ1bmUuc3FsIi4gWW91IGNhbiBwcm9iYWJs eSBjb21lIHVwIHdpdGggYSBzaW1wbGVyIHF1ZXJ5LCBidXQgdGhpcyBkb2VzIHRoZSBqb2IuIFRo ZSBxdWVyeSBiZWxvdyBnaXZlcyB0aGUgb3V0cHV0IGluIEpTT04gZm9ybWF0Og0KLS0tLQ0KY3Jl YXRlIHRhYmxlIGFiIChhIGludCBub3QgbnVsbCwgYiBpbnQgbm90IG51bGwpIHBhcnRpdGlvbiBi eSBsaXN0IChhKTsNCmNyZWF0ZSB0YWJsZSBhYl9hMiBwYXJ0aXRpb24gb2YgYWIgZm9yIHZhbHVl cyBpbigyKSBwYXJ0aXRpb24gYnkgbGlzdCAoYik7DQpjcmVhdGUgdGFibGUgYWJfYTJfYjEgcGFy dGl0aW9uIG9mIGFiX2EyIGZvciB2YWx1ZXMgaW4gKDEpOw0KY3JlYXRlIHRhYmxlIGFiX2ExIHBh cnRpdGlvbiBvZiBhYiBmb3IgdmFsdWVzIGluKDEpIHBhcnRpdGlvbiBieSBsaXN0IChiKTsNCmNy ZWF0ZSB0YWJsZSBhYl9hMV9iMSBwYXJ0aXRpb24gb2YgYWJfYTEgZm9yIHZhbHVlcyBpbiAoMik7 DQoNCi0tIERpc2FsbG93IGluZGV4IG9ubHkgc2NhbnMgYXMgY29uY3VycmVudCB0cmFuc2FjdGlv bnMgbWF5IHN0b3AgdmlzaWJpbGl0eQ0KLS0gYml0cyBiZWluZyBzZXQgY2F1c2luZyAiSGVhcCBG ZXRjaGVzIiB0byBiZSB1bnN0YWJsZSBpbiB0aGUgRVhQTEFJTiBBTkFMWVpFDQotLSBvdXRwdXQu DQpzZXQgZW5hYmxlX2luZGV4b25seXNjYW4gPSBvZmY7DQoNCnByZXBhcmUgYWJfcTEgKGludCwg aW50LCBpbnQpIGFzDQpzZWxlY3QgKiBmcm9tIGFiIHdoZXJlIGEgYmV0d2VlbiAkMSBhbmQgJDIg YW5kIGIgPD0gJDM7DQoNCi0tIEV4ZWN1dGUgcXVlcnkgNSB0aW1lcyB0byBhbGxvdyBjaG9vc2Vf Y3VzdG9tX3BsYW4NCi0tIHRvIHN0YXJ0IGNvbnNpZGVyaW5nIGEgZ2VuZXJpYyBwbGFuLg0KZXhl Y3V0ZSBhYl9xMSAoMSwgOCwgMyk7DQpleGVjdXRlIGFiX3ExICgxLCA4LCAzKTsNCmV4ZWN1dGUg YWJfcTEgKDEsIDgsIDMpOw0KZXhlY3V0ZSBhYl9xMSAoMSwgOCwgMyk7DQpleGVjdXRlIGFiX3Ex ICgxLCA4LCAzKTsNCg0KZXhwbGFpbiAoZm9ybWF0IGpzb24sIGFuYWx5emUsIGNvc3RzIG9mZiwg c3VtbWFyeSBvZmYsIHRpbWluZyBvZmYpIGV4ZWN1dGUgYWJfcTEgKDIsIDIsIDMpOw0KDQpkZWFs bG9jYXRlIGFiX3ExOw0KZHJvcCB0YWJsZSBhYjsNCi0tLS0KClRoZSBuZXcgc3RhdHVzIG9mIHRo aXMgcGF0Y2ggaXM6IFJlYWR5IGZvciBDb21taXR0ZXIK