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 1jjGqX-0007YW-KD for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Jun 2020 06:37:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jjGqV-0002vO-2p for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Jun 2020 06:37:51 +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 1jjCyo-0006nO-W0 for pgsql-bugs@lists.postgresql.org; Thu, 11 Jun 2020 02:30:10 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jjCyi-0005kV-0A for pgsql-bugs@lists.postgresql.org; Thu, 11 Jun 2020 02:30:10 +0000 Content-Type: multipart/mixed; boundary="===============7362617792956195770==" MIME-Version: 1.0 Subject: BUG #16489: Cannot strictly compare arrays in jsonb_path_query call that uses vars To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jeremydahan@protonmail.com Reply-To: jeremydahan@protonmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 11 Jun 2020 02:29:49 +0000 Message-ID: <16489-d3b890452bd13422@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7362617792956195770== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQ4OQpMb2dnZWQgYnk6ICAgICAgICAgIERhaGFuIEplcmVteQpFbWFp bCBhZGRyZXNzOiAgICAgIGplcmVteWRhaGFuQHByb3Rvbm1haWwuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTIuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIG1hY09TIDEwLjE0CkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIaSwNCkkgZm91bmQgdGhpcyB2ZXJ5IHN0cmFuZ2UgYmVoYXZpb3Igb2YgdGhlIGpz b25iX3BhdGhfcXVlcnkgZnVuY3Rpb24gOg0KDQpFeGFtcGxlIDogDQpgYGANClNFTEVDVCBqc29u Yl9wYXRoX3F1ZXJ5KCd7ImEiOlsiYiIsImMiXX0nOjpqc29uYiwgJyQuYSA/IChAID09ICRkKScg LAoneyJkIjpbImIiLCJjIiwiZSJdfSc6Ompzb25iKQ0KYGBgDQpXaGVuIHVzaW5nIHRoZSBqc29u Yl9wYXRoX3F1ZXJ5IGZ1bmN0aW9uIHdpdGggYSB2YXJzIGFyZ3VtZW50IHRoYXQgaW5jbHVkZXMK YW4gYXJyYXkgKGhlcmUgd2l0aCBrZXkgZCksIEkgY2Fubm90IGNvbXBhcmUgdGhlIHF1ZXJpZWQg YXJyYXkgYWdhaW5zdCB0aGUKdmFycyBhcnJheS4NCkluc3RlYWQsIEkgZ2V0IGEgcGVyIGVsZW1l bnQgY29tcGFyaXNvbiwgd2hpY2ggbWVhbnMgaW5zdGVhZCBvZiByZXR1cm5pbmcgDQpbImIiLCJj Il0NCg0KdGhlIHF1ZXJ5IHJldHVybnMgDQoiYiINCiJjIg0KDQpqdXN0IGxpa2UgdGhlIHF1ZXJ5 DQpgYGANClNFTEVDVCBqc29uYl9wYXRoX3F1ZXJ5KCd7ImEiOlsiYiIsImMiXX0nOjpqc29uYiwg JyQuYVsqXSA/IChAID09ICRkKScgLAoneyJkIjpbImIiLCJjIiwiZSJdfSc6Ompzb25iKQ0KYGBg DQoobm90aWNlIHRoZSAkLmFbKl0gaW5zdGVhZCBvZiB0aGUgJC5hKQ0KDQpJbnRlcmVzdGluZ2x5 LCB0aGlzIG1lYW5zIHRoYXQgdGhlIGZvbGxvd2luZyBxdWVyeSBhbHNvIHJldHVybnMgdGhlIHNh bWUKcmVzdWx0DQpgYGANClNFTEVDVCBqc29uYl9wYXRoX3F1ZXJ5KCd7ImEiOlsiYiIsImMiXX0n Ojpqc29uYiwgJyQuYVsqXSA/IChAICE9ICRkKScgLAoneyJkIjpbImIiLCJjIiwiZSJdfSc6Ompz b25iKQ0KYGBgDQoobm90aWNlIHRoZSAhPSBpbnN0ZWFkIG9mIHRoZSA9PSkNCg0KSSBjb3VsZCBu b3QgZmluZCBtZW50aW9ucyBvZiB0aGlzIHN0cmFuZ2UgYmVoYXZpb3IgaW4gdGhlIGRvY3VtZW50 YXRpb24sIGFuZApJIHdvdWxkIGxvdmUgdG8ga25vdyBpZiB0aGVyZSBpcyBhIHdheSBvZiBjb21w YXJpbmcgYW4gYXJyYXkgYWdhaW5zdCBhbm90aGVyCmFycmF5IGluIGEganNvbmJfcGF0aF9xdWVy eSBmdW5jdGlvbiBjYWxsICh3aXRob3V0IHVzaW5nIGEgV0hFUkUgY2xhdXNlKS4NCkJ5IHRoZSB3 YXksIHRoZSBjdXJyZW50IGJlaGF2aW9yIGNhbiBiZSB1c2VmdWwgZm9yIGZpbmRpbmcgaW50ZXJz ZWN0aW9ucyBvZgphcnJheXMuDQoNCg0KVGhhbmsgeW91IGZvciB0aGlzIHRydWx5IGluY3JlZGli bGUgcHJvamVjdA0KDQpCZXN0IHJlZ2FyZHMsDQoNCkplcmVteSBEYWhhbgoK --===============7362617792956195770==--