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 1ltEC3-0003FZ-EY for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jun 2021 18:53:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltEC1-0005lA-Ew for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jun 2021 18:53:45 +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 1ltDr6-0001VJ-40 for pgsql-bugs@lists.postgresql.org; Tue, 15 Jun 2021 18:32:08 +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 1ltDr3-0006Bk-13 for pgsql-bugs@lists.postgresql.org; Tue, 15 Jun 2021 18:32:07 +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=zRMFcb7YKmaC/8j3Sr2iZq1DjFoWhtN7YZqrDvbIiqw=; b=m3e5AllNAN0ZtspUNo4RFIe7Cc RYRYdKriBZC0D7HHeLZp1xMTzBy3Yf35aQTfw2pNEx0qQ+F0+tcDH8IiU3bsLwnIEXOYsPiSf7kUX qAZTfCf0UqtwAmnhE3PxNEPGiZ+dJXp+Rx7kF42/7ApYQsVwM/Hwu3arcQeNcNQvBA2XQS56GrRnU JjyZ54GDRgxj5gP01JM4xcQUOiGJPTpMpwbecy5uRxK17Pp6SePSaV6L78WEExohmg2Rh+Gm4TDoh Jyrp7CzvUDhCowuLHjahbnNkFn8aTOn6AOPxOozt4QunfKeNszDUB+gASY9mmSG47E08VI9aYZpmD EkO6B1VQ==; 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 1ltDr2-0008VF-8r for pgsql-bugs@lists.postgresql.org; Tue, 15 Jun 2021 18:32:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltDqz-0005it-SY for pgsql-bugs@lists.postgresql.org; Tue, 15 Jun 2021 18:32:01 +0000 Content-Type: multipart/mixed; boundary="===============8112643122759781178==" MIME-Version: 1.0 Subject: BUG #17059: postgresql 13 version problem related to query. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ram.maurya@lavainternational.in Reply-To: ram.maurya@lavainternational.in, pgsql-bugs@lists.postgresql.org Date: Tue, 15 Jun 2021 18:31:31 +0000 Message-ID: <17059-c96d70e84d7bb4ce@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 --===============8112643122759781178== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA1OQpMb2dnZWQgYnk6ICAgICAgICAgIFJhbSBQcmF0YXRwIG1hdXJ5 YQpFbWFpbCBhZGRyZXNzOiAgICAgIHJhbS5tYXVyeWFAbGF2YWludGVybmF0aW9uYWwuaW4KUG9z dGdyZVNRTCB2ZXJzaW9uOiAxMy4wCk9wZXJhdGluZyBzeXN0ZW06ICAgUkhFTCA4LjMKRGVzY3Jp cHRpb246ICAgICAgICAKCkhpIHRlYW0sDQoNCkkgYW0gZmFjaW5nIHByb2JsZW0gcmVsYXRlZCB0 byBxdWVyeS4NCg0KSSBoYXZlIHR3byBEQiBzZXJ2ZXIgb25lIGlzIHJ1bm5pbmcgb24gcG9zdGdy ZXMxMiAgKFJIRUwgNikgYW5kIHNlY29uZCBpcwpydW5uaW5nIG9uIHBvc3RncmVzcWwgLTEzICAo UkhFTCA4LjMpLg0KU2VydmVyIEgvVyBjb25maWd1cmF0aW9uIGlzIHNhbWUgYW5kIHBvc3RncmVz cWwuY29uZiAgZmlsZSBjb25maWd1cmF0aW9uCnBhcmFtZXRlciBpcyBhbHNvIHNhbWUuDQoNCldo ZW4gSSBhbSBydW5uaW5nIGJlbG93IHF1ZWFyeSBvbiBzZXJ2ZXIgcG9zdGdyZXNxbC0xMiBkYXRh IGNvbWVzIHdpdGhpbiAyCm1pbiBhbmQgd2hlbiBJIHJ1biB0aGlzIHF1ZWFyIG9uIHBvc3RncmVz cWwtMTMgc2VydmVyIGl0cyB0YWtlIDMwIG1pbgpkaXNwbGF5IHJlc3VsdC4NCg0KQ2FuIHlvdSBw bGVhc2Ugc3VnZ2VzdCBhbnkgIHByb2JsZW0gaW4gcG9zdGdyZXNxbC0xMy4NCg0KTm90ZSA6IERC IHNpemUgb2YgcG9zdGdyZXNxbC0xMiBpcyAyNDIgR0IgKDEgeWVhciBvbGQgZGF0YSkgYW5kIERC IHNpemUgb2YKcG9zdGdyZXNxbC0xMiBpcyAzNTAgR0IuDQoNCi4uLi4uLi4uLi4uLi4uLi4uLi4u Li4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4u Li4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4u Li4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4u Li4uLi4uLi4uLg0Kc2VsZWN0CkRJU1RJTkNUKCJPcmRlciIub3JkZXJfbm8pLCJPcmRlciIucmV0 YWlsZXJfY29kZSwiT3JkZXIiLm9yZGVyX3N0YXR1cyxPcmRlckRlbGl2ZXJ5Tm90ZS5hc3NpZ25l ZF90b191c2VybmFtZSwKT3JkZXJEZWxpdmVyeU5vdGUuYXNzaWduZWRfdG9fcm9sZSwNCk9yZGVy RGVsaXZlcnlOb3RlLmRlbGl2ZXJ5X25vdGVfbm8sIE9yZGVyRGVsaXZlcnlOb3RlLmRhdGUsCk9y ZGVyRGVsaXZlcnlOb3RlLnRvdGFsX3ZhbHVlLA0KbGVhdmUuZGF0ZSwgbGVhdmUudXNlcm5hbWUs IFJldGFpbGVyTGlzdC5yZXRhaWxlcl9vdXRsZXQsCkRTRV91c2VyLmZpcnN0X25hbWUsICJPcmRl ciIucGFyZW50X29yZGVyX25vLA0KQ0FTRSBXSEVOICJPcmRlciIuIm9yZGVyX3N0YXR1cyI9J2Rp c3BhdGNoZWQnIHRoZW4gMw0KV0hFTiAiT3JkZXIiLiJvcmRlcl9zdGF0dXMiPSdwYXJ0aWFsbHkg ZGlzcGF0Y2hlZCcgdGhlbiAzDQpXSEVOICJPcmRlciIuIm9yZGVyX3N0YXR1cyI9J2Fja25vd2xl ZGdlbWVudCBwZW5kaW5nJyB0aGVuIDQNCldIRU4gIk9yZGVyIi4ib3JkZXJfc3RhdHVzIj0nZGVs aXZlcmVkJyB0aGVuIDINCldIRU4gIk9yZGVyIi4ib3JkZXJfc3RhdHVzIj0nZG4gcGVuZGluZycg dGhlbiAxIEVMU0UgMCBFTkQgQVMKIk9yZGVyX19hY3Rpb25hYmxlIg0KZnJvbSB0b3JkZXIgIk9y ZGVyIg0Kam9pbiB0cmV0YWlsZXJfbXN0IGFzIFJldGFpbGVyTGlzdCBvbgoiT3JkZXIiLnJldGFp bGVyX2NvZGU9UmV0YWlsZXJMaXN0LnJldGFpbGVyX2NvZGUNCmpvaW4gdG9yZGVyX2RlbGl2ZXJ5 X25vdGUgYXMgT3JkZXJEZWxpdmVyeU5vdGUgb24KIk9yZGVyIi5vcmRlcl9ubz1PcmRlckRlbGl2 ZXJ5Tm90ZS5vcmRlcl9ubw0KbGVmdCBqb2luIHRsZWF2ZSBsZWF2ZSBvbiAiT3JkZXIiLm9yZGVy X25vPU9yZGVyRGVsaXZlcnlOb3RlLm9yZGVyX25vIGFuZApsZWF2ZS5kYXRlPScyMDIxLTA2LTE1 JyBhbmQgbGVhdmUucm9sZT0nREInDQpqb2luIHR1c2VyX21zdCBEU0VfdXNlciBvbgpPcmRlckRl bGl2ZXJ5Tm90ZS5hc3NpZ25lZF90b191c2VybmFtZT1EU0VfdXNlci51c2VybmFtZQ0Kd2hlcmUg ZGJyX2NvZGU9JzMwNDcxNycgQU5EIChvcmRlcl9zdGF0dXMgSU4gKCgnZGVsaXZlcmVkJyksKCdk bgpwZW5kaW5nJyksKCdhY2tub3dsZWRnZW1lbnQgcGVuZGluZycpLA0KKCdwYXJ0aWFsbHkgZGVs aXZlcmVkJykpIG9yICgob3JkZXJfc3RhdHVzID0gJ2Rpc3BhdGNoZWQnIG9yIG9yZGVyX3N0YXR1 cyA9CidwYXJ0aWFsbHkgZGlzcGF0Y2hlZCcpIGFuZCBsZWF2ZS5kYXRlID0gJzIwMjEtMDYtMTUn KSkNCmdyb3VwIGJ5ICJPcmRlciIub3JkZXJfbm8KLCJPcmRlciIucmV0YWlsZXJfY29kZSwiT3Jk ZXIiLm9yZGVyX3N0YXR1cyxPcmRlckRlbGl2ZXJ5Tm90ZS5hc3NpZ25lZF90b191c2VybmFtZSwK T3JkZXJEZWxpdmVyeU5vdGUuYXNzaWduZWRfdG9fcm9sZSwNCk9yZGVyRGVsaXZlcnlOb3RlLmRl bGl2ZXJ5X25vdGVfbm8sIE9yZGVyRGVsaXZlcnlOb3RlLmRhdGUsCk9yZGVyRGVsaXZlcnlOb3Rl LnRvdGFsX3ZhbHVlLA0KbGVhdmUuZGF0ZSwgbGVhdmUudXNlcm5hbWUsIFJldGFpbGVyTGlzdC5y ZXRhaWxlcl9vdXRsZXQsCkRTRV91c2VyLmZpcnN0X25hbWUsICJPcmRlciIucGFyZW50X29yZGVy X25vDQpvcmRlciBieSBPcmRlckRlbGl2ZXJ5Tm90ZS5kYXRlIGRlc2MgbGltaXQgNTA7Cgo= --===============8112643122759781178==--