Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZZVL-001tq7-5c for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Aug 2024 17:22:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sZZVJ-00CFYF-L3 for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Aug 2024 17:22:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZZBo-00C9WK-L4 for pgsql-bugs@lists.postgresql.org; Thu, 01 Aug 2024 17:02:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZZBm-002dXj-2O for pgsql-bugs@lists.postgresql.org; Thu, 01 Aug 2024 17:02:08 +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=Vf5wlw3NpgkwPn2QoE/m0rloMuG4bMwq9i4MPpmiGk0=; b=2Oi9qlTiWPqRh1Hul+a3iBOaqy OZIAwE9ivAeX8IzwBCTKDL+0TgtyeFVCoqGcs9UkvhHxAUTxAvFTTDAg8ptnLdShrnVbJpPEFnLjB OsuHqbMlYfyWrrj2LEUHI05ShqWoB+02SUAcsQHPYtiHJPz30YoQZU9v+gxwMhgHwJgEa+nCZ59hj mk8qQZmDlXBg5abtnPI5aoiidHjgEB9NGBfYLd5VumIsrxdKsGESnqSxq+aMkXdC0BZKn1WQ9bjGG g4wY+gR63xF+6hLonF4mS0kKm0nMlwlnkjD1a7EqtDLZTuEY/ZOjPaEPnUlvNIW0SLlCiz/u5Zs+z rnlEpF5Q==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZZBk-0081kZ-D9 for pgsql-bugs@lists.postgresql.org; Thu, 01 Aug 2024 17:02:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sZZBh-00BoOK-O8 for pgsql-bugs@lists.postgresql.org; Thu, 01 Aug 2024 17:02:02 +0000 Content-Type: multipart/mixed; boundary="===============0739775236740864857==" MIME-Version: 1.0 Subject: BUG #18564: Incorrect sorting with using NULLS LAST (NULLS FIRST) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sunnybluemoon050@gmail.com Reply-To: sunnybluemoon050@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 01 Aug 2024 17:01:36 +0000 Message-ID: <18564-5985f90678ed7512@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 --===============0739775236740864857== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU2NApMb2dnZWQgYnk6ICAgICAgICAgIFN2ZXRsYW5hCkVtYWlsIGFk ZHJlc3M6ICAgICAgc3VubnlibHVlbW9vbjA1MEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNi4zCk9wZXJhdGluZyBzeXN0ZW06ICAgbWFjT1MKRGVzY3JpcHRpb246ICAgICAgICAKCklz c3VlIERlc2NyaXB0aW9uOg0KDQpJIGFtIGVuY291bnRlcmluZyBhIGJ1ZyB3aGVuIHBlcmZvcm1p bmcgYSBxdWVyeSB3aXRoIHNvcnRpbmcgb24gYSBudWxsYWJsZQpmbG9hdCBmaWVsZCB3aXRoaW4g YSBqc29uYiBjb2x1bW4sIHVzaW5nIE5VTExTIExBU1QuIERlc3BpdGUgdGhpcywgTlVMTAp2YWx1 ZXMgYXBwZWFyIGF0IHRoZSBiZWdpbm5pbmcgb2YgdGhlIHNvcnRlZCByZXN1bHRzLiBXaGVuIGNh c3RpbmcgdGhlIHZhbHVlCnRvIHRleHQsIE5VTEwgdmFsdWVzIGNvcnJlY3RseSBhcHBlYXIgYXQg dGhlIGVuZCBvZiB0aGUgcmVzdWx0cy4gSG93ZXZlciwKc29ydGluZyBpcyBpbmNvcnJlY3QgYmVj YXVzZSB0aGUgdmFsdWVzIGFyZSB0aGVuIHRyZWF0ZWQgYXMgdGV4dCwgd2hpY2gKYWZmZWN0cyB0 aGUgc29ydGluZyBvcmRlci4NCg0KRGV0YWlsczoNCg0KRmllbGQgVHlwZTogTnVsbGFibGUgZmxv YXQgd2l0aGluIGEganNvbmIgY29sdW1uLg0KRGVzaXJlZCBCZWhhdmlvcjogU29ydCBieSB0aGUg ZmxvYXQgZmllbGQgd2l0aCBOVUxMUyBMQVNULg0KT2JzZXJ2ZWQgQmVoYXZpb3I6IE5VTEwgdmFs dWVzIGFwcGVhciBhdCB0aGUgYmVnaW5uaW5nIG9mIHRoZSByZXN1bHRzLg0KU3RlcHMgdG8gUmVw cm9kdWNlOg0KQ3JlYXRlIGEgdGFibGUgYGV4YW1wbGVfdGFibGVgIHdpdGgganNvbmIgY29sdW1u IGBleGFtcGxlX2pzb25iX2NvbHVtbmAuDQpJbnNlcnQgZGF0YSBpbnRvIHRoZSB0YWJsZQ0KYGBg DQpJTlNFUlQgSU5UTyBleGFtcGxlX3RhYmxlIChleGFtcGxlX2pzb25iX2NvbHVtbikNClZBTFVF Uw0KKCd7InNvcnRpbmdfcGFyYW0iOiAxLjB9Jzo6anNvbmIpLA0KKCd7InNvcnRpbmdfcGFyYW0i OiAyLjB9Jzo6anNvbmIpLA0KKCd7InNvcnRpbmdfcGFyYW0iOiBudWxsfSc6Ompzb25iKSwNCign eyJzb3J0aW5nX3BhcmFtIjogbnVsbH0nOjpqc29uYik7DQpgYGANClBlcmZvcm0gYSBxdWVyeSB3 aXRoIHNvcnRpbmcgb24gdGhlIG51bGxhYmxlIGZsb2F0IGZpZWxkIHdpdGhpbiB0aGUganNvbmIK Y29sdW1uLCBzcGVjaWZ5aW5nIE5VTExTIExBU1QuDQpgYGANClNFTEVDVCBleGFtcGxlX2pzb25i X2NvbHVtbi0+J3NvcnRpbmdfcGFyYW0nDQpGUk9NIGV4YW1wbGVfdGFibGUNCk9SREVSIEJZIGV4 YW1wbGVfanNvbmJfY29sdW1uLT4nc29ydGluZ19wYXJhbScgQVNDIE5VTExTIExBU1QNCmBgYA0K T2JzZXJ2ZSB0aGF0IE5VTEwgdmFsdWVzIGFyZSBpbmNvcnJlY3RseSBwbGFjZWQgYXQgdGhlIGJl Z2lubmluZyBvZiB0aGUKcmVzdWx0cy4NCkNhc3QgdGhlIGZpZWxkIHRvIHRleHQgYW5kIG9ic2Vy dmUgdGhhdCBOVUxMIHZhbHVlcyBhcmUgY29ycmVjdGx5IHBsYWNlZCBhdAp0aGUgZW5kLCBidXQg dGhlIHNvcnRpbmcgb3JkZXIgaXMgaW5jb3JyZWN0Lg0KYGBgDQpTRUxFQ1QgZXhhbXBsZV9qc29u Yl9jb2x1bW4tPj4nc29ydGluZ19wYXJhbScNCkZST00gZXhhbXBsZV90YWJsZQ0KT1JERVIgQlkg ZXhhbXBsZV9qc29uYl9jb2x1bW4tPj4nc29ydGluZ19wYXJhbScgQVNDIE5VTExTIExBU1QNCmBg YA0KDQpFeHBlY3RlZCBCZWhhdmlvcjoNCk5VTEwgdmFsdWVzIHNob3VsZCBhcHBlYXIgYXQgdGhl IGVuZCBvZiB0aGUgc29ydGVkIHJlc3VsdHMsIGFuZCB0aGUgc29ydGluZwpzaG91bGQgYmUgYWNj dXJhdGUgYmFzZWQgb24gdGhlIG51bWVyaWMgdmFsdWVzLg0KDQpBY3R1YWwgQmVoYXZpb3I6DQpO VUxMIHZhbHVlcyBhcHBlYXIgYXQgdGhlIGJlZ2lubmluZyB3aGVuIHNvcnRpbmcgbnVtZXJpY2Fs bHkuCgo= --===============0739775236740864857==--