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 1rhzQP-00ETzF-RK for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Mar 2024 22:07:46 +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 1rhzQN-00ExKZ-D0 for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Mar 2024 22:07:43 +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 1rhyfL-00EXSy-Ai for pgsql-bugs@lists.postgresql.org; Wed, 06 Mar 2024 21:19:07 +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 1rhyfH-003CYp-P8 for pgsql-bugs@lists.postgresql.org; Wed, 06 Mar 2024 21:19:06 +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=k8vKeFPnxvre5g218nbeGFzVK4q3e2nG+eAvsRkd2vo=; b=x3z6qL2xtTjAcUOVSr0rH2b6Lt s2OHdNTymUKpOmCFNLWlpLvBIBxmOpGMT4tMIufJ/Ypr0U9QRTnYEAtq8MdCoBOdfnFATbvyb1xaf zdV5EoBiAPhgMT5nQzsh9QP05z/mpuSLngt/XvSboIGkjs/ZrWbbtMta0hsRI/rzdRoWrAFJZYD5x uQ7/0n8+Au35ZW8juud1hFgoKLDuJabWd0eKdbd4M8oRFanopVXpFQWhCsMTS3ykMDAtUXfHQ24Mc guBAXmfB+1379i82G6P13OHdEp/rjconUmCPmz3BDnnEK9msDGwci9D5HBvRTt2OPf3VTfSk/kxG4 RcDYRDMw==; 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 1rhyfH-007kwk-MS for pgsql-bugs@lists.postgresql.org; Wed, 06 Mar 2024 21:19: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 1rhyfF-003IbY-8K for pgsql-bugs@lists.postgresql.org; Wed, 06 Mar 2024 21:19:02 +0000 Content-Type: multipart/mixed; boundary="===============1234465484002585541==" MIME-Version: 1.0 Subject: BUG #18380: BUG: notify stops working after LEFT JOIN if enable_mergejoin is ON To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: grothoff@gnu.org Reply-To: grothoff@gnu.org, pgsql-bugs@lists.postgresql.org Date: Wed, 06 Mar 2024 21:18:24 +0000 Message-ID: <18380-c795d2b4033dfca0@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 --===============1234465484002585541== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM4MApMb2dnZWQgYnk6ICAgICAgICAgIENocmlzdGlhbiBHcm90aG9m ZgpFbWFpbCBhZGRyZXNzOiAgICAgIGdyb3Rob2ZmQGdudS5vcmcKUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIEdOVS9MaW51eApEZXNjcmlwdGlvbjog ICAgICAgIAoKV2UgdGVzdGVkIHdpdGggUG9zdGdyZXMgMTQsIDE1LCAxNi4xIGFuZCAxNi4yOyBz YW1lIHJlc3VsdHMuDQoNCk92ZXJ2aWV3Og0KPT09PT09PT0NCg0KV2UgdXNlIExJU1RFTiArIE5P VElGWSB0byBpbXBsZW1lbnQgc29tZSBsb25nIHBvbGxpbmcuIFRoaXMgdXN1YWxseSB3b3Jrcy4K SG93ZXZlciwgd2Ugc3RvcCBnZXR0aW5nIE5PVElGWSBtZXNzYWdlcyBhZnRlciBhIExJU1RFTmlu ZyBjbGllbnQgaXNzdWVkIGEKcGFydGljdWxhciBTRUxFQ1QgcXVlcnkgd2l0aCBhIExFRlQgSk9J TiBpbiB0aGUgTElTVEVOaW5nIGNsaWVudC4gIERpc2FibGluZwoiZW5hYmxlX21lcmdlam9pbiIg Zml4ZXMgdGhlIGlzc3VlLiBXZSBiZWxpZXZlIHRoYXQgdGhlICJlbmFibGVfbWVyZ2Vqb2luIgps b2dpYyBzb21laG93IGNvcnJ1cHRzIHRoZSBub3RpZnkgc3RhdGUgKGxpa2VseSBhbiBvYnNjdXJl IHJhcmUgbWVtb3J5CmNvcnJ1cHRpb24gaXNzdWUpLiBUaGUgYnVnIGlzIDEwMCUgcmVwcm9kdWNl YWJsZSBvbiBzZXZlcmFsIG9mIG91cgpzeXN0ZW1zLg0KDQpIb3cgdG8gcmVwcm9kdWNlOg0KPT09 PT09PT09PT09PT09DQoqIEluc3RhbGwgR05VbmV0IDAuMjEuMCBbb3I6IGdpdC5nbnVuZXQub3Jn L2dudW5ldC5naXQgbWFzdGVyXQ0KKiBJbnN0YWxsIEdOVSBUYWxlciBleGNoYW5nZSwgY2hlY2tv dXQgdGFnICdwb3N0Z3Jlcy1idWctbWVyZ2Vqb2luJyBbZnJvbQpnaXQudGFsZXIubmV0L2V4Y2hh bmdlLmdpdF0NCiogSW5zdGFsbCB0YWxlci13YWxsZXQtY29yZSBbZnJvbSBnaXQudGFsZXIubmV0 L3RhbGVyLXdhbGxldC1jb3JlXQ0KKiBydW4gJCB0YWxlci1oYXJuZXNzIHJ1bi1pbnRlZ3JhdGlv bnRlc3RzIGRlcG9zaXQgDQoNCkJ1Z2d5IG91dGNvbWUNCj09PT09PT09PT09PT0NCg0KSWYgZW5h YmxlX21lcmdlam9pbiBpcyBPTiwgdGhlIHRlc3QgcmVwb3J0cyB0aGlzIGF0IHRoZSBlbmQ6DQog ICAgICBwYXJlbnQ6IGdvdCByZXN1bHQKeyJuYW1lIjoiZGVwb3NpdCIsInRpbWVTZWMiOjM1LjE2 OCwic3RhdHVzIjoicGFzcyJ9DQpOb3RlIHRoYXQgdGhlIDM1cyBpcyBkdWUgdG8gYWxsIGtpbmRz IG9mIHRoaW5ncyBpbiB0aGUgdGVzdCwgbm9uZSByZWxhdGVkIHRvCmFjdHVhbCBwb3N0Z3JlcyBx dWVyeSBwZXJmb3JtYW5jZS4NClRoaXMgaXMgTk9UIGEgcGVyZm9ybWFuY2UgaXNzdWUuIFdlIGNh biBzZXQgdGhlIGxvbmctcG9sbCB0aHJlc2hvbGQgaGlnaGVyLAphbmQgdGhlIHRpbWUgd2lsbCBn byB1cCBhY2NvcmRpbmdseS4NCg0KRXhwZWN0ZWQgYmVoYXZpb3Igd2l0aCB3b3JrLWFyb3VuZA0K PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQoNCiBJZiBlbmFibGVfbWVyZ2Vqb2luIGlz IE9GRiwgbG9uZy1wb2xsaW5nIHdvcmtzIGFuZCB0aGUgdGVzdCByZXBvcnRzCnNvbWV0aGluZyBs aWtlIHRoaXMgYXQgdGhlIGVuZDoNCiAgICAgIHBhcmVudDogZ290IHJlc3VsdAp7Im5hbWUiOiJk ZXBvc2l0IiwidGltZVNlYyI6MTYuMDk0LCJzdGF0dXMiOiJwYXNzIn0NCg0KVGhpcyBpcyBiYXNp Y2FsbHkgdGhlIGZhc3Rlc3QgdGhlIGludGVncmF0aW9uIHRlc3Qgd2lsbCBydW4gKH4xNS0xNwpz ZWNvbmRzKSwgdGhlIE5PVElGWSBoYXBwZW5zIGFzIGV4cGVjdGVkLg0KDQpSZWxldmFudCBTUUwg cXVlcnkgYnJlYWstZG93bg0KPT09PT09PT09PT09PT09PT09PT09PT09PT0NCg0KVGhlIHF1ZXJ5 IHRoYXQgY2F1c2VzIHRoaW5ncyB0byBicmVhayBpcyBpbgpleGNoYW5nZS9zcmMvZXhjaGFuZ2Vk Yi9wZ19sb29rdXBfdHJhbnNmZXJfYnlfZGVwb3NpdC5jLiBUaGUgYnVnZ3kKc3ViLWNsYXVzZSBp cyBtYXJrZWQgd2l0aA0KI2lmIEJVRyBiZWxvdzoNCg0KICAgIFBSRVBBUkUgKHBnLA0KICAgICAg ICAgICAgICJnZXRfZGVwb3NpdF93aXRob3V0X3d0aWQiLA0KICAgICAgICAgICAgICJTRUxFQ1Qi DQogICAgICAgICAgICAgIiBiZGVwLndpcmVfc2FsdCINCiAgICAgICAgICAgICAiLHd0LnBheXRv X3VyaSINCiAgICAgICAgICAgICAiLGNkZXAuYW1vdW50X3dpdGhfZmVlIg0KICAgICAgICAgICAg ICIsZGVub20uZmVlX2RlcG9zaXQiDQogICAgICAgICAgICAgIixiZGVwLndpcmVfZGVhZGxpbmUi DQojaWYgQlVHDQogICAgICAgICAgICAgIixhZ3QubGVnaXRpbWl6YXRpb25fcmVxdWlyZW1lbnRf c2VyaWFsX2lkIg0KI2VuZGlmDQogICAgICAgICAgICAgIixhbWwuc3RhdHVzIg0KICAgICAgICAg ICAgICIsYW1sLmt5Y19yZXF1aXJlbWVudCINCiAgICAgICAgICAgICAiIEZST00gY29pbl9kZXBv c2l0cyBjZGVwIg0KICAgICAgICAgICAgICIgSk9JTiBiYXRjaF9kZXBvc2l0cyBiZGVwIg0KICAg ICAgICAgICAgICIgICBVU0lORyAoYmF0Y2hfZGVwb3NpdF9zZXJpYWxfaWQpIg0KICAgICAgICAg ICAgICIgSk9JTiB3aXJlX3RhcmdldHMgd3QiDQogICAgICAgICAgICAgIiAgIFVTSU5HICh3aXJl X3RhcmdldF9oX3BheXRvKSINCiAgICAgICAgICAgICAiIEpPSU4ga25vd25fY29pbnMga2MiDQog ICAgICAgICAgICAgIiAgIE9OIChrYy5jb2luX3B1YiA9IGNkZXAuY29pbl9wdWIpIg0KICAgICAg ICAgICAgICIgSk9JTiBkZW5vbWluYXRpb25zIGRlbm9tIg0KICAgICAgICAgICAgICIgICBVU0lO RyAoZGVub21pbmF0aW9uc19zZXJpYWwpIg0KI2lmIEJVRw0KICAgICAgICAgICAgICIgTEVGVCBK T0lOIGFnZ3JlZ2F0aW9uX3RyYW5zaWVudCBhZ3QgIg0KICAgICAgICAgICAgICIgICBPTiAoIChi ZGVwLndpcmVfdGFyZ2V0X2hfcGF5dG8gPSBhZ3Qud2lyZV90YXJnZXRfaF9wYXl0bykKQU5EIg0K ICAgICAgICAgICAgICIgICAgICAgIChiZGVwLm1lcmNoYW50X3B1YiA9IGFndC5tZXJjaGFudF9w dWIpICkiDQojZW5kaWYNCiAgICAgICAgICAgICAiIExFRlQgSk9JTiBhbWxfc3RhdHVzIGFtbCIN CiAgICAgICAgICAgICAiICAgT04gKHd0LndpcmVfdGFyZ2V0X2hfcGF5dG8gPSBhbWwuaF9wYXl0 bykiDQogICAgICAgICAgICAgIiBXSEVSRSBjZGVwLmNvaW5fcHViPSQxIg0KICAgICAgICAgICAg ICIgICBBTkQgYmRlcC5tZXJjaGFudF9wdWI9JDMiDQogICAgICAgICAgICAgIiAgIEFORCBiZGVw LmhfY29udHJhY3RfdGVybXM9JDIiDQogICAgICAgICAgICAgIiBMSU1JVCAxOyIpOw0KDQpJZiB3 ZSAjZGVmaW5lIEJVRyB0byAwIGZvciB0aGUgY29kZSBhYm92ZSwgd2UgZG8gTk9UIGhhdmUgdG8g ZGlzYWJsZSB0aGUKbWVyZ2Vfam9pbiB0byBnZXQgdGhlIGRlc2lyZWQgYmVoYXZpb3IuCgo= --===============1234465484002585541==--