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 1rKboy-003WiQ-1e for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Jan 2024 10:16:28 +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 1rKbow-00F1Gs-6v for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Jan 2024 10:16:26 +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 1rKamr-00EhFZ-Qw for pgsql-bugs@lists.postgresql.org; Tue, 02 Jan 2024 09:10:14 +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 1rKamk-00F7wc-Bz for pgsql-bugs@lists.postgresql.org; Tue, 02 Jan 2024 09:10:13 +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=nOdWjvMNovJAvmzp4D3FDBWzeQUMVL8Dkq9vWR4MVfI=; b=um9fjPCLzAyhpUbeWr3HZCvF+e 7hOakNCfaHePf9zONrANh76HA9E00yideVgm7SqiATT/QUa1X3GpAUzyvdiZwj5oGaLh9E4qNzgiC KWUiCZU653QU+Ij6hBG213+M5oeKxFvsEIpJVko713y6wFSaEqj1BWwOkenP1wVfYRcWc1R2Dkm3C USacMObMuEnxGC5nZjVbh2wM1NDzOajhWxINWQ4bU5jGjgtllLc/QNLS4yHbCNBAmCO7Tub2t07Rm 2tVF55Jhpy+JB6+lpN7h0kje97WYHEGwJqIGa3ERg70QdF9uTD1t0kPorJBQUs2nXkWlZeN57d5Kn MPspg0nQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rKamh-00A0tk-Og for pgsql-bugs@lists.postgresql.org; Tue, 02 Jan 2024 09:10: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 1rKamf-0052BR-6s for pgsql-bugs@lists.postgresql.org; Tue, 02 Jan 2024 09:10:02 +0000 Content-Type: multipart/mixed; boundary="===============0245601123974939451==" MIME-Version: 1.0 Subject: BUG #18265: jsonb comparison order is inconsistent To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: neil.chen@protonbase.io Reply-To: neil.chen@protonbase.io, pgsql-bugs@lists.postgresql.org Date: Tue, 02 Jan 2024 09:09:42 +0000 Message-ID: <18265-fd06fa2f9ad3d1db@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 --===============0245601123974939451== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI2NQpMb2dnZWQgYnk6ICAgICAgICAgIG5laWwgY2hlbgpFbWFpbCBh ZGRyZXNzOiAgICAgIG5laWwuY2hlbkBwcm90b25iYXNlLmlvClBvc3RncmVTUUwgdmVyc2lvbjog MTQuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIG9wZXJhdGluZyBzeXN0ZW0gaXJyZWxldmFudApEZXNj cmlwdGlvbjogICAgICAgIAoKQXMgdGhlIGRvY3VlbW50IHNhaWVkLCAgZm9yIGpzb25iIHR5cGUs IE9iamVjdCA+IEFycmF5ID4gQm9vbGVhbiA+IE51bWJlciA+ClN0cmluZyA+IE51bGwsIGJ1dCBh Y3R1YWxseSBlbXB0eSBqc29uIGFycmF5IGlzIHNvcnQgdG8gYmUgdGhlIHNtYWxsZXN0CnZhbHVl Lg0KQW5kIHRoaXMgaXMgdHJ1ZSBvbmx5IHdoZW4gaXQgaXMgdGhlIG91dG1vc3QganNvbiB2YWx1 ZSwgdGhhdCBpcywgCidbXSc6Ompzb25iIGlzIGxlc3MgdGhhbiAnbnVsbCc6Ompzb25iLg0KYnV0 IHdoZW4gaXQgaXMgYSBpbm5lciBlbGVtZW50IG9mIGpzb24gYXJyYXksICB0aGUgY29tcGFyaXNv biByZXN1bHQgd2lsbApjaGFuZ2VkLCB0aGF0IGlzLCAnW1tdXSc6Ompzb25iIGlzIGdyZWF0ZXIg dGhhbiAnW251bGxdJy4NClRoaXMgYmVoYXZpb3IgbG9va3Mgc3RyYW5nZSwgdGhhdCBtYXliZSBh IG1pc3Rha2UgaW4KY29tcGFyZUpzb25iQ29udGFpbmVycygpLg0KCQkJCQkJLyoNCgkJCQkJCSAq IFRoaXMgY291bGQgYmUgYSAicmF3IHNjYWxhciIgcHNldWRvIGFycmF5LiAgVGhhdCdzDQoJCQkJ CQkgKiBhIHNwZWNpYWwgY2FzZSBoZXJlIHRob3VnaCwgc2luY2Ugd2Ugc3RpbGwgd2FudCB0aGUN CgkJCQkJCSAqIGdlbmVyYWwgdHlwZS1iYXNlZCBjb21wYXJpc29ucyB0byBhcHBseSwgYW5kIGFz IGZhcg0KCQkJCQkJICogYXMgd2UncmUgY29uY2VybmVkIGEgcHNldWRvIGFycmF5IGlzIGp1c3Qg YSBzY2FsYXIuDQoJCQkJCQkgKi8NCgkJCQkJCWlmICh2YS52YWwuYXJyYXkucmF3U2NhbGFyICE9 IHZiLnZhbC5hcnJheS5yYXdTY2FsYXIpDQovLyBIZXJlIG9uZSBpcyBqc29uIGFycmF5LCBhbmQg YW5vdGhlciBpcyBub3QganNvbiBhcnJheSwgbWF5YmUgd2Ugc2hvdWxkCnNpbXBseSBjb21wYXJl IHRoZWlyIHR5cGUuDQovLyBBbmQgdGhlIGNvbXBhcmlzb24gcmVzdWx0IHNob3VsZCBub3QgYmUg b3ZlcndyaXR0ZW4gYnkgdGhlIGZvbGxvd2luZyBpZgpzdGF0ZW1lbnQuDQoJCQkJCQkJcmVzID0g KHZhLnZhbC5hcnJheS5yYXdTY2FsYXIpID8gLTEgOiAxOyANCgkJCQkJCWlmICh2YS52YWwuYXJy YXkubkVsZW1zICE9IHZiLnZhbC5hcnJheS5uRWxlbXMpDQoJCQkJCQkJcmVzID0gKHZhLnZhbC5h cnJheS5uRWxlbXMgPiB2Yi52YWwuYXJyYXkubkVsZW1zKSA/IDEgOiAtMTsNCgkJCQkJCWJyZWFr Ow0KcG9zdGdyZXM9IyBzZWxlY3QgKiBmcm9tCih2YWx1ZXMoJ251bGwnOjpqc29uYiksKCdbXSc6 Ompzb25iKSwoJ1tudWxsXSc6Ompzb25iKSwoJ1tbXV0nOjpqc29uYikpIGFzCnQoaikgb3JkZXIg YnkgajsNCiAgIGogICAgDQotLS0tLS0tLQ0KIFtdDQogbnVsbA0KIFtudWxsXQ0KIFtbXV0KCg== --===============0245601123974939451==--