Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ljGcr-0008HI-Tw for pgsql-bugs@arkaria.postgresql.org; Wed, 19 May 2021 07:28:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ljGcq-0004wb-Qm for pgsql-bugs@arkaria.postgresql.org; Wed, 19 May 2021 07:28:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ljGAc-00033E-CX for pgsql-bugs@lists.postgresql.org; Wed, 19 May 2021 06:59:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ljGAZ-0004SR-Ur for pgsql-bugs@lists.postgresql.org; Wed, 19 May 2021 06:59:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=VwDXhgtV3lQi3oOD8+Ud0U/QsL1npMo082HjuK75bgk=; b=TNfpUkd6Vw2CUXKAXNCtTd73ut FkN4U/yre74d6hcxgCGqVPGaRT5xmqGgdu9S4eejmCBBefrfQjj5KqMNAUHLuNnevzUZ7ACDBIdL2 4xCChiDsx3GVgKwOu2qbDQTHDZcewGFu6SqIf0F88ChcSs6kuNcwqa1ItW/b9ZDfILeDQyMKVsZDq 6fbDHxyyX6JIl+y4EuoznSfvboiiaUzotcm6kbsnLyRZkua2MWWJBfLfX1n+zaeijHwBH780j0sep gs4A6utXZCoUvx8yr84Wi9lXhieJdJlpKWJx9ucRq13J+g6t+HknP/dNZC6vyoshhMJeGTEQm4LoM 5vMRpW9w==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ljGAZ-00026K-KT for pgsql-bugs@lists.postgresql.org; Wed, 19 May 2021 06:59:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ljGAY-0002jE-2L for pgsql-bugs@lists.postgresql.org; Wed, 19 May 2021 06:59:02 +0000 Content-Type: multipart/mixed; boundary="===============7670925321016693344==" MIME-Version: 1.0 Subject: BUG #17022: SQL causing engine crash To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tharakan@gmail.com Reply-To: tharakan@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 19 May 2021 06:58:19 +0000 Message-ID: <17022-8e7e280c9b4baedb@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7670925321016693344== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzAyMgpMb2dnZWQgYnk6ICAgICAgICAgIFJvYmlucyBUaGFyYWthbgpF bWFpbCBhZGRyZXNzOiAgICAgIHRoYXJha2FuQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEzLjMKT3BlcmF0aW5nIHN5c3RlbTogICBBbWF6b24gTGludXggMgpEZXNjcmlwdGlvbjogICAg ICAgIAoKSGksDQoNClNRTFNtaXRoIGlzIGNvbnN0YW50bHkgY3Jhc2hpbmcgdjEzLjMgd2l0aCBT UUwocykgdGhhdCBhcHBlYXIgbGlua2VkIHRvIGEKUG9zdEdJUyAodjMuMC4zKSBidWcgLSBzZWUg RXJyb3IgUmVwb3J0IGJlbG93Lg0KDQpJIGRlY2lkZWQgdG8gcG9zdCB0aGlzIGhlcmUgKGJhY2t0 cmFja2luZyBvbiBhbiBlYXJsaWVyIHRob3VnaHQpLCBzaW5jZSAjMCAvCiMxIGFyZcKgcG9zdGdy ZXMgZnVuY3Rpb25zIGFuZCBJIHdhc24ndCByZWFsbHkgc3VyZSBpZiB0aGUgYXJndW1lbnRzIHRv IHRoZXNlCmZ1bmN0aW9ucyBhcmUgc2FuaXRpemVkLiBGb3IgZS5nLiB3aGV0aGVyIHBnX2RldG9h c3RfZGF0dW1fc2xpY2UoKSBpcwpleHBlY3RlZCB0byBjaGVjayBpbnB1dCBib3VuZHMgKGNvdW50 PTQwIGluIHRoaXMgY2FzZSkuDQoNClNhbXBsZSBTUUwgKEkgY291bGRuJ3QgbmFycm93IHRoaXMg ZG93biBmdXJ0aGVyKToNCj09PT09PT09PT0NCiQgcHNxbA0KcHNxbCAoMTNiZXRhMiwgc2VydmVy IDEzLjMpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4NCg0KcmVncmVzc2lvbj0+IMKgIHNlbGVjdCAx DQpmcm9tIHB1YmxpYy5zcGF0aWFsX3JlZl9zeXMgYXMgc2FtcGxlXzAgdGFibGVzYW1wbGUgYmVy bm91bGxpICg2LjgpDQp3aGVyZSBjYXNlIHdoZW4gKChjYXN0KG51bGwgYXMgZ2VvbWV0cnkpICYm IGNhc3QobnVsbCBhcyBnZW9tZXRyeSkpDQrCoCDCoCDCoCDCoCBhbmQgKE5VTEwgaXMgTlVMTCkp DQrCoCDCoCDCoCDCoHRoZW4gY2FzZSB3aGVuIHNhbXBsZV8wLmF1dGhfc3JpZCBpcyBOVUxMIHRo ZW4gY2FzdChudWxsIGFzIGdlb21ldHJ5KQplbHNlIGNhc3QobnVsbCBhcyBnZW9tZXRyeSkgZW5k DQrCoCDCoCDCoCDCoGVsc2UgY2FzZSB3aGVuIHNhbXBsZV8wLmF1dGhfc3JpZCBpcyBOVUxMIHRo ZW4gY2FzdChudWxsIGFzIGdlb21ldHJ5KQplbHNlIGNhc3QobnVsbCBhcyBnZW9tZXRyeSkgZW5k DQrCoCDCoCDCoCDCoGVuZA0KwqAgwqAgwqAmLyYgY2FzZSB3aGVuIChwZ19jYXRhbG9nLnBnX2N1 cnJlbnRfc25hcHNob3QoKSBpcyBub3QgTlVMTCkNCsKgIMKgIMKgIGFuZCAoY2FzdChudWxsIGFz IHRpbWVzdGFtcHR6KSA+PSAoc2VsZWN0IGJhY2tlbmRfc3RhcnQgZnJvbQpwZ19jYXRhbG9nLnBn X3N0YXRfYWN0aXZpdHkgbGltaXQgMSBvZmZzZXQgNCkNCsKgIMKgIMKgIMKgIMKgICkgdGhlbiBw dWJsaWMuZ2VvbWV0cnkoDQrCoCDCoCDCoCBjYXN0KGNhc3QobnVsbCBhcyBnZW9ncmFwaHkpIGFz IGdlb2dyYXBoeSkpIGVsc2UgcHVibGljLmdlb21ldHJ5KA0KwqAgwqAgwqAgY2FzdChjYXN0KG51 bGwgYXMgZ2VvZ3JhcGh5KSBhcyBnZW9ncmFwaHkpKSBlbmQ7DQpzZXJ2ZXIgY2xvc2VkIHRoZSBj b25uZWN0aW9uIHVuZXhwZWN0ZWRseQ0KwqAgwqAgwqAgwqAgVGhpcyBwcm9iYWJseSBtZWFucyB0 aGUgc2VydmVyIHRlcm1pbmF0ZWQgYWJub3JtYWxseQ0KwqAgwqAgwqAgwqAgYmVmb3JlIG9yIHdo aWxlIHByb2Nlc3NpbmcgdGhlIHJlcXVlc3QuDQpUaGUgY29ubmVjdGlvbiB0byB0aGUgc2VydmVy IHdhcyBsb3N0LiBBdHRlbXB0aW5nIHJlc2V0OiBGYWlsZWQuDQoNCg0KDQoNCkFub3RoZXIgRXhh bXBsZToNCj09PT09PT09PT09PT09DQpTRUxFQ1QgMSBGUk9NIChTRUxFQ1QgTlVMTDo6aW50IGEg TElNSVQgMCkgQVMgcmVmXzANCldIRVJFIENBU0UNCsKgIMKgIFdIRU4gQ0FTRQ0KwqAgwqAgwqAg wqAgV0hFTiBwZ19jYXRhbG9nLmpzb25iX2J1aWxkX2FycmF5KCkgPyB2ZXJzaW9uKCkNCsKgIMKg IMKgIMKgIMKgIFRIRU4gY2FzdChOVUxMIEFTIHBvaW50KQ0KwqAgwqAgwqAgwqAgRUxTRSBjYXN0 KE5VTEwgQVMgcG9pbnQpDQrCoCDCoCDCoCDCoCBFTkQgQChTRUxFQ1QgTlVMTDo6bHNlZyBMSU1J VCAwKQ0KwqAgwqAgwqAgVEhFTiBjYXN0KE5VTEwgQVMgR0VPR1JBUEhZKQ0KwqAgwqAgRU5EICYm IENBU0UNCsKgIMKgIFdIRU4gKA0KwqAgwqAgwqAgwqAgQ0FTRQ0KwqAgwqAgwqAgwqAgwqAgV0hF TiByZWZfMC5hIElTIE5VTEwNCsKgIMKgIMKgIMKgIMKgIFRIRU4gY2FzdChOVUxMIEFTIGZsb2F0 NCkNCsKgIMKgIMKgIMKgIMKgIEVMU0UgY2FzdChOVUxMIEFTIGZsb2F0NCkNCsKgIMKgIMKgIMKg IEVORCA8PSAoDQrCoCDCoCDCoCDCoCDCoCBTRUxFQ1QgTlVMTDo6cmVhbCBMSU1JVCAwDQrCoCDC oCDCoCDCoCDCoCApDQrCoCDCoCDCoCDCoCApDQrCoCDCoCDCoCBUSEVOIE5VTEw6OkdFT0dSQVBI WQ0KwqAgwqAgRU5EDQpsaW1pdCA1ODsNCg0KDQoNCg0KQmFja3RyYWNlIChjb21tb24gdG8gbW9z dCBzdWNoIGNyYXNoZXMpOg0KPT09PT09PT0NCiMwIMKgZGV0b2FzdF9hdHRyX3NsaWNlIChhdHRy PWF0dHJAZW50cnk9MHgwLApzbGljZW9mZnNldD1zbGljZW9mZnNldEBlbnRyeT0wLCBzbGljZWxl bmd0aD1zbGljZWxlbmd0aEBlbnRyeT00MCkgYXQKZGV0b2FzdC5jOjIyNg0KIzEgwqAweDAwMDAw MDAwMDA4YTNiNTUgaW4gcGdfZGV0b2FzdF9kYXR1bV9zbGljZSAoZGF0dW09ZGF0dW1AZW50cnk9 MHgwLApmaXJzdD1maXJzdEBlbnRyeT0wLCBjb3VudD1jb3VudEBlbnRyeT00MCkgYXQgZm1nci5j OjE3NTQNCiMyIMKgMHgwMDAwMTRlMjE3ZjRmNzkzIGluIGdzZXJpYWxpemVkX2RhdHVtX2dldF9n aWR4X3AKKGdzZGF0dW09Z3NkYXR1bUBlbnRyeT0wLCBnaWR4PWdpZHhAZW50cnk9MHg3ZmZmYjFi YTc3MzApIGF0CmdzZXJpYWxpemVkX2dpc3QuYzoxODUNCiMzIMKgMHgwMDAwMTRlMjE3ZjRmYWE5 IGluIGdzZXJpYWxpemVkX2RhdHVtX2dldF9nYm94X3AgKGdzZGF0dW09MCwKZ2JveD1nYm94QGVu dHJ5PTB4N2ZmZmIxYmE3N2QwKSBhdCBnc2VyaWFsaXplZF9naXN0LmM6MTU3DQojNCDCoDB4MDAw MDE0ZTIxN2VmOTcxYiBpbiBnc2VyaWFsaXplZF9zZWxfaW50ZXJuYWwgKHJvb3Q9PG9wdGltaXpl ZCBvdXQ+LAphcmdzPTxvcHRpbWl6ZWQgb3V0PiwgdmFyUmVsaWQ9PG9wdGltaXplZCBvdXQ+LCBt b2RlPTApIGF0CmdzZXJpYWxpemVkX2VzdGltYXRlLmM6MjI1Mw0KIzUgwqAweDAwMDAxNGUyMTdl Zjk3OTkgaW4gZ3NlcmlhbGl6ZWRfZ2lzdF9zZWwKKGZjaW5mbz1mY2luZm9AZW50cnk9MHg3ZmZm YjFiYTc4NTApIGF0IGdzZXJpYWxpemVkX2VzdGltYXRlLmM6MjI4MQ0KIzYgwqAweDAwMDAwMDAw MDA4YTI0ZjQgaW4gRGlyZWN0RnVuY3Rpb25DYWxsNUNvbGwKKGZ1bmM9ZnVuY0BlbnRyeT0weDE0 ZTIxN2VmOTc4MCA8Z3NlcmlhbGl6ZWRfZ2lzdF9zZWw+LApjb2xsYXRpb249Y29sbGF0aW9uQGVu dHJ5PTAsIGFyZzE9PG9wdGltaXplZCBvdXQ+LA0KwqAgwqAgYXJnMj08b3B0aW1pemVkIG91dD4s IGFyZzM9PG9wdGltaXplZCBvdXQ+LCBhcmc0PTxvcHRpbWl6ZWQgb3V0PiwKYXJnNT0wKSBhdCBm bWdyLmM6OTA4DQojNyDCoDB4MDAwMDE0ZTIxN2VmOTZhNCBpbiBnc2VyaWFsaXplZF9naXN0X3Nl bF9uZCAoZmNpbmZvPTxvcHRpbWl6ZWQgb3V0PikKYXQgZ3NlcmlhbGl6ZWRfZXN0aW1hdGUuYzoy MjA0DQojOCDCoDB4MDAwMDAwMDAwMDhhMmM2ZSBpbiBGdW5jdGlvbkNhbGw0Q29sbCAoZmxpbmZv PTB4N2ZmZmIxYmE3OTcwLApjb2xsYXRpb249PG9wdGltaXplZCBvdXQ+LCBhcmcxPTxvcHRpbWl6 ZWQgb3V0PiwgYXJnMj08b3B0aW1pemVkIG91dD4sCmFyZzM9PG9wdGltaXplZCBvdXQ+LA0KwqAg wqAgYXJnND08b3B0aW1pemVkIG91dD4pIGF0IGZtZ3IuYzoxMjE2DQojOSDCoDB4MDAwMDAwMDAw MDhhMzI0NyBpbiBPaWRGdW5jdGlvbkNhbGw0Q29sbCAoZnVuY3Rpb25JZD08b3B0aW1pemVkIG91 dD4sCmNvbGxhdGlvbj1jb2xsYXRpb25AZW50cnk9MCwgYXJnMT1hcmcxQGVudHJ5PTQ5MTg5MDE2 LAphcmcyPWFyZzJAZW50cnk9MTExODAyOCwNCsKgIMKgIGFyZzM9YXJnM0BlbnRyeT01MDE2NDIz MiwgYXJnND1hcmc0QGVudHJ5PTApIGF0IGZtZ3IuYzoxNDUyDQojMTAgMHgwMDAwMDAwMDAwNzBi NDVkIGluIHJlc3RyaWN0aW9uX3NlbGVjdGl2aXR5Cihyb290PXJvb3RAZW50cnk9MHgyZWU5MDk4 LCBvcGVyYXRvcmlkPTExMTgwMjgsIGFyZ3M9MHgyZmQ3MjA4LAppbnB1dGNvbGxpZD0wLCB2YXJS ZWxpZD12YXJSZWxpZEBlbnRyeT0wKQ0KwqAgwqAgYXQgcGxhbmNhdC5jOjE3ODUNCg0KDQpSZWZl cmVuY2U6DQphKSBQb3N0R0lTIEJ1ZyByZXBvcnQgLSBodHRwczovL3RyYWMub3NnZW8ub3JnL3Bv c3RnaXMvdGlja2V0LzQ5MTkNCg0KLQ0KUm9iaW5zDQpBV1MgRGF0YWJhc2UgRW5naW5lZXIKCg== --===============7670925321016693344==--