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 1lvcv7-0004Dm-LM for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Jun 2021 09:42:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lvcv5-0000uP-Qg for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Jun 2021 09:42:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lvTve-0006ns-0z for pgsql-bugs@lists.postgresql.org; Tue, 22 Jun 2021 00:06:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lvTva-0007M4-8k for pgsql-bugs@lists.postgresql.org; Tue, 22 Jun 2021 00:06:09 +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=SKj+eTRumWaEtCXJUrR9TcqJK1HgSqZDRTOuRpWmBZk=; b=Y+daykLrfdyp/tPgb5mDWQF2X3 hcEfd89kJwf+RYVoqoEuZa1y/ol+R9KLRNzx/V4EInu4aEh76pO32J/LrVkuKd3HkeHAIp65pJ8xu IJyxhQpK/IKQ2vXPAr3Vj035qVXBxV5GzrVC1RBqi+7kKcLhyuapKc5d4JoNuTMNuEQabgUYFK1Jz O3hbnqoI1Fwz5mWFjLi+SaQ9MwnC1zrj4FtP7xpZ+5/ZC1giEuXeX0B776uFvbrZYyykdMsly7oGh WcG9k+2u2CimFQmWyouQKluTStLhKxMnO4y7UCPJy5aQiz9DM2qOBIMtOa6wArdQKeJYx4WY8Aef1 z2BW+hLw==; 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 1lvTvY-0007kV-SV for pgsql-bugs@lists.postgresql.org; Tue, 22 Jun 2021 00:06: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 1lvTvW-0004KR-6I for pgsql-bugs@lists.postgresql.org; Tue, 22 Jun 2021 00:06:02 +0000 Content-Type: multipart/mixed; boundary="===============3569097568392095369==" MIME-Version: 1.0 Subject: BUG #17068: Incorrect ordering of a particular row. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ganeshmmahesh@gmail.com Reply-To: ganeshmmahesh@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 22 Jun 2021 00:05:34 +0000 Message-ID: <17068-18d0626f1d26394d@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 --===============3569097568392095369== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA2OApMb2dnZWQgYnk6ICAgICAgICAgIGdhbmVzaCBtYWhlc2gKRW1h aWwgYWRkcmVzczogICAgICBnYW5lc2htbWFoZXNoQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDEwLjE1Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1CkRlc2NyaXB0aW9uOiAgICAgICAg CgpWZXJzaW9uOg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgdmVyc2lvbiAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQog UG9zdGdyZVNRTCAxMC4xNSAoVWJ1bnR1IDEwLjE1LTB1YnVudHUwLjE4LjA0LjEpIG9uIHg4Nl82 NC1wYy1saW51eC1nbnUsCmNvbXBpbGVkIGJ5IGdjYyAoVWJ1bnR1IDcuNS4wLTN1YnVudHUxfjE4 LjA0KSA3LjUuMCwgNjQtYml0DQoNClF1ZXJ5IGluIHF1ZXN0aW9uOiANClNFTEVDVCBBTEwgbnVs bG5hbWVzYi5pZCwgYWxpYXMzLiogRlJPTSBudWxsbmFtZXNiICBSSUdIVCBKT0lOIChTRUxFQ1Qg QUxMCmFsaWFzMS55ZWFyc1RlbnVyZWQsIGFsaWFzMS5maXJzdE5hbWUgRlJPTSBudWxsbmFtZXMg YWxpYXMxIE9SREVSIEJZCmFsaWFzMS5maXJzdE5hbWUsIGFsaWFzMS55ZWFyc1RlbnVyZWQpIEFT IGFsaWFzMSBPTgooKG51bGxuYW1lc2IueWVhcnNUZW51cmVkIDw9IGFsaWFzMS55ZWFyc1RlbnVy ZWQpIE9SIChudWxsbmFtZXNiLmlkID0KYWxpYXMxLnllYXJzVGVudXJlZCkpIExFRlQgSk9JTiAo U0VMRUNUIERJU1RJTkNUIGFsaWFzMy5sYXN0TmFtZSBGUk9NCm51bGxuYW1lc2IgYWxpYXMzIE9S REVSIEJZIGFsaWFzMy5sYXN0TmFtZSkgQVMgYWxpYXMzIE9OCigoKG51bGxuYW1lc2IubGFzdE5h bWUgIT0gYWxpYXMzLmxhc3ROYW1lKSkgT1IgTk9UIChudWxsbmFtZXNiLnNhbGFyeSA8PSBBTlkK KFNFTEVDVCBESVNUSU5DVCBhbGlhczQuc2FsYXJ5IEZST00gbnVsbG5hbWVzIGFsaWFzNCBPUkRF UiBCWSBhbGlhczQuc2FsYXJ5CkxJTUlUIDEpKSkgV0hFUkUgbnVsbG5hbWVzYi5leGVtcHQgPSBG QUxTRSBPUkRFUiBCWSBhbGlhczMuKiwKbnVsbG5hbWVzYi5pZDsNCg0KSW5mbyBvbiB0aGUgdGFi bGVzIGl0c2VsZjoNClxkKyBudWxsbmFtZXM6DQoNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLm51bGxuYW1lcyINCiAgICBDb2x1bW4gICAg fCAgICAgICAgIFR5cGUgICAgICAgICAgfCBDb2xsYXRpb24gfCBOdWxsYWJsZSB8IERlZmF1bHQg fApTdG9yYWdlICB8IFN0YXRzIHRhcmdldCB8IERlc2NyaXB0aW9uIA0KLS0tLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0r LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tDQogaWQgICAgICAgICAgIHwg aW50ZWdlciAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51bGwgfCAgICAgICAgIHwK cGxhaW4gICAgfCAgICAgICAgICAgICAgfCANCiBmaXJzdG5hbWUgICAgfCBjaGFyYWN0ZXIgdmFy eWluZygzMCkgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfApleHRlbmRlZCB8ICAg ICAgICAgICAgICB8IA0KIGxhc3RuYW1lICAgICB8IGNoYXJhY3RlciB2YXJ5aW5nKDMwKSB8ICAg ICAgICAgICB8ICAgICAgICAgIHwgICAgICAgICB8CmV4dGVuZGVkIHwgICAgICAgICAgICAgIHwg DQogc2FsYXJ5ICAgICAgIHwgbnVtZXJpYyAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90 IG51bGwgfCAgICAgICAgIHwKbWFpbiAgICAgfCAgICAgICAgICAgICAgfCANCiBleGVtcHQgICAg ICAgfCBib29sZWFuICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8ICAgICAg ICAgfApwbGFpbiAgICB8ICAgICAgICAgICAgICB8IA0KIHllYXJzdGVudXJlZCB8IGludGVnZXIg ICAgICAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgICAgIHwgICAgICAgICB8CnBsYWluICAg IHwgICAgICAgICAgICAgIHwgDQpJbmRleGVzOg0KICAgICJudWxsbmFtZXNfcGtleSIgUFJJTUFS WSBLRVksIGJ0cmVlIChpZCkNCg0KXGQrIG51bGxuYW1lc2I6DQoNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBUYWJsZSAicHVibGljLm51bGxuYW1lc2IiDQogICAg Q29sdW1uICAgIHwgICAgICAgICBUeXBlICAgICAgICAgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUg fCBEZWZhdWx0IHwKU3RvcmFnZSAgfCBTdGF0cyB0YXJnZXQgfCBEZXNjcmlwdGlvbiANCi0tLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0r LS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KIGlkICAg ICAgICAgICB8IGludGVnZXIgICAgICAgICAgICAgICB8ICAgICAgICAgICB8IG5vdCBudWxsIHwg ICAgICAgICB8CnBsYWluICAgIHwgICAgICAgICAgICAgIHwgDQogZmlyc3RuYW1lICAgIHwgY2hh cmFjdGVyIHZhcnlpbmcoMzApIHwgICAgICAgICAgIHwgICAgICAgICAgfCAgICAgICAgIHwKZXh0 ZW5kZWQgfCAgICAgICAgICAgICAgfCANCiBsYXN0bmFtZSAgICAgfCBjaGFyYWN0ZXIgdmFyeWlu ZygzMCkgfCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgfApleHRlbmRlZCB8ICAgICAg ICAgICAgICB8IA0KIHNhbGFyeSAgICAgICB8IG51bWVyaWMgICAgICAgICAgICAgICB8ICAgICAg ICAgICB8IG5vdCBudWxsIHwgICAgICAgICB8Cm1haW4gICAgIHwgICAgICAgICAgICAgIHwgDQog ZXhlbXB0ICAgICAgIHwgYm9vbGVhbiAgICAgICAgICAgICAgIHwgICAgICAgICAgIHwgbm90IG51 bGwgfCAgICAgICAgIHwKcGxhaW4gICAgfCAgICAgICAgICAgICAgfCANCiB5ZWFyc3RlbnVyZWQg fCBpbnRlZ2VyICAgICAgICAgICAgICAgfCAgICAgICAgICAgfCBub3QgbnVsbCB8ICAgICAgICAg fApwbGFpbiAgICB8ICAgICAgICAgICAgICB8IA0KSW5kZXhlczoNCiAgICAibnVsbG5hbWVzYl9w a2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGlkKQ0KDQpEYXRhIGluIHRoZSB0YWJsZToNCnNlbGVj dCAqIGZyb20gbnVsbG5hbWVzOw0KDQogaWQgfCBmaXJzdG5hbWUgfCBsYXN0bmFtZSB8ICAgc2Fs YXJ5ICAgfCBleGVtcHQgfCB5ZWFyc3RlbnVyZWQgDQotLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tDQogIDAgfCBaZXJvICAgICAg fCBDb29sICAgICB8ICAgMjUwMDAuMDEgfCB0ICAgICAgfCAgICAgICAgICAgMTANCiAgMSB8IEFj aWQgICAgICB8IEJ1cm4gICAgIHwgICA2MjUzMC41NiB8IGYgICAgICB8ICAgICAgICAgICAgNQ0K ICAyIHwgQ2VyZWFsICAgIHwgS2lsbGVyICAgfCAgICAgICAgICAwIHwgZiAgICAgIHwgICAgICAg ICAgICAgDQogIDMgfCBMb3JkICAgICAgfCBOaWtvbiAgICB8IDIwMDA1NjcuNDkgfCB0ICAgICAg fCAgICAgICAgICAgIDINCiAgNCB8IEpvZXkgICAgICB8ICAgICAgICAgIHwgICAgICAgICAgMCB8 IGYgICAgICB8ICAgICAgICAgICAgIA0KICA1IHwgWmVybyAgICAgIHwgQ29vbCAgICAgfCAgIDI1 MDAwLjAxIHwgdCAgICAgIHwgICAgICAgICAgIDEwDQooNiByb3dzKQ0KDQpzZWxlY3QgKiBmcm9t IG51bGxuYW1lc2I7DQpudWxsbmFtZXM9PiBzZWxlY3QgKiBmcm9tIG51bGxuYW1lc2I7DQogaWQg fCBmaXJzdG5hbWUgfCBsYXN0bmFtZSB8ICAgc2FsYXJ5ICAgfCBleGVtcHQgfCB5ZWFyc3RlbnVy ZWQgDQotLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0tKy0t LS0tLS0tLS0tLS0tDQogIDAgfCBaZXJvICAgICAgfCBDb29sICAgICB8ICAgMjUwMDAuMDEgfCBm ICAgICAgfCAgICAgICAgICAgMjANCiAgMSB8IEFjaWQgICAgICB8IEJ1cm4gICAgIHwgICA2MjUz MC41NiB8IGYgICAgICB8ICAgICAgICAgICAgNQ0KICAyIHwgQ2VyZWFsICAgIHwgS2lsbGVyICAg fCAgICAgICAgICAwIHwgdCAgICAgIHwgICAgICAgICAgICAwDQogIDMgfCBMb3JkICAgICAgfCBO aWtvbiAgICB8IDIwMDA1NjcuNDkgfCBmICAgICAgfCAgICAgICAgICAgIDINCiAgNCB8IEpvZXkg ICAgICB8ICAgICAgICAgIHwgICAgICAgICAgMCB8IGYgICAgICB8ICAgICAgICAgICAgMA0KICA1 IHwgWmVybyAgICAgIHwgQ29vbCAgICAgfCAgIDI1MDAwLjAxIHwgZiAgICAgIHwgICAgICAgICAg IDIwDQooNiByb3dzKQ0KDQpQYXJ0aWFsIFF1ZXJ5IHJlc3VsdDoNCmBgYA0KLg0KLg0KICA1IHwg Tmlrb24NCiAgMSB8IA0KICAxIHwgDQogIDEgfCANCiAgMyB8IA0KICAzIHwgDQogIDMgfCANCiAg MyB8IA0KICA1IHwgDQogIDQgfCANCiAgNCB8IA0KICA0IHwgDQogIDQgfCANCig0NCByb3dzKQ0K YGBgDQoNClByb2JsZW06IA0KYDV8YCBvcmRlcmluZyBpcyBpbmNvcnJlY3QuDQoNClJlc3VsdCBl eHBlY3RlZDoNCmA1fGAgcm93IHNob3VsZCBiZSB0aGUgbGFzdCByb3cgaW4gdGhlIG91dHB1dC4K Cg== --===============3569097568392095369==--