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 1sLocJ-00GinH-FO for pgsql-bugs@arkaria.postgresql.org; Mon, 24 Jun 2024 18:40:39 +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 1sLocH-00B1Qg-GL for pgsql-bugs@arkaria.postgresql.org; Mon, 24 Jun 2024 18:40:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLoFc-00Aui4-7D for pgsql-bugs@lists.postgresql.org; Mon, 24 Jun 2024 18:17:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLoFV-002vUK-K7 for pgsql-bugs@lists.postgresql.org; Mon, 24 Jun 2024 18:17:11 +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=0H8oH+vewgKIVl1nbq8JK/GUEmtj5qSMegK1M2XmYxk=; b=sRJQXaka/UkxrjibxUffPX55at hxvUBNZpz8SwhVupJzUI3H3N0ERPjzOK1P4abhU1orbQ6olas6cIbpqqHgkkADv80FnTjLIXiKQ/v nTrJjYhZoaaoQZ23CzAzvfVJJjiXD2Sxw6DIrSZcV5RpGf24pXw2teONL9BTxBgZRWxT9d73GMbdz V1n+oqE2sDCEHf2JCwf/PmXc5D7oCvGLIiYKgMBogxjKq7T3rLa6GPPGpJj5zJPGmAkcrKLtrg4Cj 1y9IpIaX9mi+hASiB5MDH14L1ThENsu7MN6f+R2px+0z3la4w+r5goTFr3quIODrugWUBlKsVDDYD Id0iJQrA==; 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 1sLoFU-009HcU-L1 for pgsql-bugs@lists.postgresql.org; Mon, 24 Jun 2024 18:17: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 1sLoFT-002cms-Bn for pgsql-bugs@lists.postgresql.org; Mon, 24 Jun 2024 18:17:03 +0000 Content-Type: multipart/mixed; boundary="===============6633707471377494549==" MIME-Version: 1.0 Subject: BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: antti@lampinen.eu Reply-To: antti@lampinen.eu, pgsql-bugs@lists.postgresql.org Date: Mon, 24 Jun 2024 18:16:38 +0000 Message-ID: <18522-c7a8956126afdfd0@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 --===============6633707471377494549== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODUyMgpMb2dnZWQgYnk6ICAgICAgICAgIEFudHRpIExhbXBpbmVuCkVt YWlsIGFkZHJlc3M6ICAgICAgYW50dGlAbGFtcGluZW4uZXUKUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ni4zCk9wZXJhdGluZyBzeXN0ZW06ICAgQVdTIFJEUyArIE1hY29zCkRlc2NyaXB0aW9uOiAgICAg ICAgCgpUaGUgZm9sbG93aW5nIHR3byBxdWVyaWVzIHJlc3VsdCBpbiBkaWZmZXJlbnQgcXVlcnkg cGxhbnMgYW5kIGRpZmZlcmVudA0KcmVzdWx0cywgZXZlbiB0aG91Z2ggdGhlcmUgaXMgb25seSBh IGR1bW15IGNvbmRpdGlvbiBjaGFuZ2UgYmV0d2VlbiB0aGVtLgpUaGUNCmxhdHRlciByZXN1bHRz IGFyZSBjb3JyZWN0LCB0aGVyZSBhcmUgdHdvIHJvd3MgdGhhdCBtYXRjaCB0aGUgY29uZGl0aW9u cy4NCg0KVGhlIGZvbGxvd2luZyB3YXMgcnVuIGJvdGggaW4gQVdTIFJEUyBhbmQgYWZ0ZXIgcmVz dG9yaW5nIGRhdGFiYXNlIGZyb20KcGxhaW4NClNRTCBkdW1wIHRvIGxvY2FsIE1hY29zIHN5c3Rl bS4NCg0KDQpGaXJzdCBxdWVyeS4NCg0KRVhQTEFJTiAoQU5BTFlaRSwgU0VUVElOR1MsIFZFUkJP U0UgKQ0KU0VMRUNUIGlkLCBtYXJrZXRfaWQNCkZST00gIm9yZGVyIg0KV0hFUkUgIm9yZGVyIi4i ZGVsZXRlZF9hdCIgSVMgTlVMTCBBTkQNCiAgICAgICJvcmRlciIuImFyY2hpdmVkX2F0IiBJUyBO VUxMIEFORA0KICAgICAgTk9UIEVYSVNUUyAoU0VMRUNUDQogICAgICAgICAgICAgICAgICBGUk9N ICJtYXRjaG1ha2luZ19yZXF1ZXN0Ig0KICAgICAgICAgICAgICAgICAgV0hFUkUgKCJtYXRjaG1h a2luZ19yZXF1ZXN0Ii4ib3JkZXJfaWQiID0gIm9yZGVyIi4iaWQiCkFORA0KICAgICAgICAgICAg ICAgICAgICAgICAgICJtYXRjaG1ha2luZ19yZXF1ZXN0Ii4ic3RhcnRlZF9hdCIgSVMgTk9UIE5V TEwKQU5EDQogICAgICAgICAgICAgICAgICAgICAgICAgIm1hdGNobWFraW5nX3JlcXVlc3QiLiJj YW5jZWxsZWRfYXQiIElTIE5VTEwpKQpBTkQNCiAgICAgICJvcmRlciIuIm1hcmtldF9pZCIgSU4g KDEpOw0KDQpRVUVSWSBQTEFODQpNZXJnZSBSaWdodCBBbnRpIEpvaW4gIChjb3N0PTQxNS44NS4u NTI3LjM5IHJvd3M9MzUwIHdpZHRoPTgpIChhY3R1YWwKdGltZT02LjAxNS4uNi4wMTggcm93cz0x IGxvb3BzPTEpDQogIE91dHB1dDogIm9yZGVyIi5pZCwgIm9yZGVyIi5tYXJrZXRfaWQNCiAgSW5u ZXIgVW5pcXVlOiB0cnVlDQogIE1lcmdlIENvbmQ6IChtYXRjaG1ha2luZ19yZXF1ZXN0Lm9yZGVy X2lkID0gIm9yZGVyIi5pZCkNCiAgLT4gIEluZGV4IFNjYW4gdXNpbmcgbWF0Y2htYWtpbmdfcmVx dWVzdF9vcmRlcl9pZF9pZHggb24KcHVibGljLm1hdGNobWFraW5nX3JlcXVlc3QgIChjb3N0PTAu MjguLjgzNC4wNyByb3dzPTU4NDAgd2lkdGg9NCkgKGFjdHVhbAp0aW1lPTAuMDMyLi4yLjA4OSBy b3dzPTcwMiBsb29wcz0xKQ0KICAgICAgICBPdXRwdXQ6IDxyZXRyYWN0ZWQ+DQogICAgICAgIEZp bHRlcjogKChtYXRjaG1ha2luZ19yZXF1ZXN0LnN0YXJ0ZWRfYXQgSVMgTk9UIE5VTEwpIEFORAoo bWF0Y2htYWtpbmdfcmVxdWVzdC5jYW5jZWxsZWRfYXQgSVMgTlVMTCkpDQogICAgICAgIFJvd3Mg UmVtb3ZlZCBieSBGaWx0ZXI6IDMwMQ0KICAtPiAgU29ydCAgKGNvc3Q9NDE1LjU2Li40MTYuODIg cm93cz01MDMgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTMuNjk1Li4zLjczMApyb3dzPTQ5MyBsb29w cz0xKQ0KICAgICAgICBPdXRwdXQ6ICJvcmRlciIuaWQsICJvcmRlciIubWFya2V0X2lkDQogICAg ICAgIFNvcnQgS2V5OiAib3JkZXIiLmlkDQogICAgICAgIFNvcnQgTWV0aG9kOiBxdWlja3NvcnQg IE1lbW9yeTogNDBrQg0KICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBvcmRlcl9tYXJrZXRf aWRfaWR4IG9uIHB1YmxpYy4ib3JkZXIiIAooY29zdD0wLjI4Li4zOTIuOTkgcm93cz01MDMgd2lk dGg9OCkgKGFjdHVhbCB0aW1lPTAuMDM1Li4zLjU1NSByb3dzPTQ5Mwpsb29wcz0xKQ0KICAgICAg ICAgICAgICBPdXRwdXQ6ICJvcmRlciIuaWQsICJvcmRlciIubWFya2V0X2lkDQogICAgICAgICAg ICAgIEluZGV4IENvbmQ6ICgib3JkZXIiLm1hcmtldF9pZCA9IDEpDQogICAgICAgICAgICAgIEZp bHRlcjogKCgib3JkZXIiLmRlbGV0ZWRfYXQgSVMgTlVMTCkgQU5EICgib3JkZXIiLmFyY2hpdmVk X2F0CklTIE5VTEwpKQ0KICAgICAgICAgICAgICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiA4NzEN ClNldHRpbmdzOiByYW5kb21fcGFnZV9jb3N0ID0gJzEnDQpQbGFubmluZyBUaW1lOiAwLjY0MyBt cw0KRXhlY3V0aW9uIFRpbWU6IDYuMzAxIG1zDQoNClNlY29uZCBxdWVyeS4gTm90ZSB0aGUgZHVt bXkgY29uZGl0aW9uIGF0IHRoZSBlbmQuDQoNCkVYUExBSU4gKEFOQUxZWkUsIFNFVFRJTkdTLCBW RVJCT1NFICkNClNFTEVDVCBpZCwgbWFya2V0X2lkDQpGUk9NICJvcmRlciINCldIRVJFICJvcmRl ciIuImRlbGV0ZWRfYXQiIElTIE5VTEwgQU5EDQogICAgICAib3JkZXIiLiJhcmNoaXZlZF9hdCIg SVMgTlVMTCBBTkQNCiAgICAgIE5PVCBFWElTVFMgKFNFTEVDVA0KICAgICAgICAgICAgICAgICAg RlJPTSAibWF0Y2htYWtpbmdfcmVxdWVzdCINCiAgICAgICAgICAgICAgICAgIFdIRVJFICgibWF0 Y2htYWtpbmdfcmVxdWVzdCIuIm9yZGVyX2lkIiA9ICJvcmRlciIuImlkIgpBTkQNCiAgICAgICAg ICAgICAgICAgICAgICAgICAibWF0Y2htYWtpbmdfcmVxdWVzdCIuInN0YXJ0ZWRfYXQiIElTIE5P VCBOVUxMCkFORA0KICAgICAgICAgICAgICAgICAgICAgICAgICJtYXRjaG1ha2luZ19yZXF1ZXN0 Ii4iY2FuY2VsbGVkX2F0IiBJUyBOVUxMKSkKQU5EDQogICAgICAib3JkZXIiLiJtYXJrZXRfaWQi IElOICgxLCAxKTsgLS0gZHVtbXkgY29uZGl0aW9uDQoNClFVRVJZIFBMQU4NCk1lcmdlIEFudGkg Sm9pbiAgKGNvc3Q9MC41Ni4uNTc5LjU2IHJvd3M9NTAzIHdpZHRoPTgpIChhY3R1YWwKdGltZT02 LjYyMi4uNi43NzMgcm93cz0yIGxvb3BzPTEpDQogIE91dHB1dDogIm9yZGVyIi5pZCwgIm9yZGVy Ii5tYXJrZXRfaWQNCiAgTWVyZ2UgQ29uZDogKCJvcmRlciIuaWQgPSBtYXRjaG1ha2luZ19yZXF1 ZXN0Lm9yZGVyX2lkKQ0KICAtPiAgSW5kZXggU2NhbiB1c2luZyBvcmRlcl9wa2V5IG9uIHB1Ymxp Yy4ib3JkZXIiICAoY29zdD0wLjI4Li40NjcuNzcKcm93cz03MjMgd2lkdGg9OCkgKGFjdHVhbCB0 aW1lPTAuMDc4Li40LjQzNSByb3dzPTQ5MyBsb29wcz0xKQ0KICAgICAgICBPdXRwdXQ6IDxyZXRy YWN0ZWQ+DQogICAgICAgIEZpbHRlcjogKCgib3JkZXIiLmRlbGV0ZWRfYXQgSVMgTlVMTCkgQU5E ICgib3JkZXIiLmFyY2hpdmVkX2F0IElTCk5VTEwpIEFORCAoIm9yZGVyIi5tYXJrZXRfaWQgPSBB TlkgKCd7MSwxfSc6OmludGVnZXJbXSkpKQ0KICAgICAgICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVy OiAxOTM1DQogIC0+ICBJbmRleCBTY2FuIHVzaW5nIG1hdGNobWFraW5nX3JlcXVlc3Rfb3JkZXJf aWRfaWR4IG9uCnB1YmxpYy5tYXRjaG1ha2luZ19yZXF1ZXN0ICAoY29zdD0wLjI4Li44MzQuMDcg cm93cz01ODQwIHdpZHRoPTQpIChhY3R1YWwKdGltZT0wLjAxNy4uMS45OTYgcm93cz03MDIgbG9v cHM9MSkNCiAgICAgICAgT3V0cHV0OiA8cmV0cmFjdGVkPg0KICAgICAgICBGaWx0ZXI6ICgobWF0 Y2htYWtpbmdfcmVxdWVzdC5zdGFydGVkX2F0IElTIE5PVCBOVUxMKSBBTkQKKG1hdGNobWFraW5n X3JlcXVlc3QuY2FuY2VsbGVkX2F0IElTIE5VTEwpKQ0KICAgICAgICBSb3dzIFJlbW92ZWQgYnkg RmlsdGVyOiAzMDENClNldHRpbmdzOiByYW5kb21fcGFnZV9jb3N0ID0gJzEnDQpQbGFubmluZyBU aW1lOiAwLjYyOSBtcw0KRXhlY3V0aW9uIFRpbWU6IDYuODUzIG1zCgo= --===============6633707471377494549==--