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 1rIQzh-008YhX-3e for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Dec 2023 10:18:33 +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 1rIQzf-00401i-GS for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Dec 2023 10:18:31 +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 1rIQIi-003csT-7g for pgsql-bugs@lists.postgresql.org; Wed, 27 Dec 2023 09:34:08 +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 1rIQIf-00CQ6d-Ls for pgsql-bugs@lists.postgresql.org; Wed, 27 Dec 2023 09:34:07 +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=opftTjXoFzME79rfvaYCKf1mfWGS63z1oJgCx2T/YN0=; b=Fbjc/jZDxxrmd+K2msNCcklfkm p3AGL+52Sc+NkXahCmrdjCtn1DZcJHhWV8h0aoYyRyOu4umDlOMwfVJRFxfiere1enfibFSBcAPBK FWuejgu1QA37vYmmfn9Jrvt7Y1K6HnmDOj5hLZOysvsIkEGsmVEHnUTUweUTWg4przC97OgzcVaDb Gshqd+tZCpZ4G+atuv3czALQP5FhVJLE6RwmW4MpKDoDUPAs3ulUpFaK6U1DDKwfOIkfPfWSYamPZ f/qUln4Nd9lW9NxzyBPy/4FA2e+75jJ6EGZeW8A0t8oCPDWD9S80DmDGzEsQoHRCKuSvfMRdruIPz akDMSs+w==; 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 1rIQIe-0071s9-0M for pgsql-bugs@lists.postgresql.org; Wed, 27 Dec 2023 09:34:05 +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 1rIQIb-00H4vd-GN for pgsql-bugs@lists.postgresql.org; Wed, 27 Dec 2023 09:34:02 +0000 Content-Type: multipart/mixed; boundary="===============3586674245783283722==" MIME-Version: 1.0 Subject: BUG #18260: Unexpected error: "negative bitmapset member not allowed" triggered by multiple JOIN To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zuming.jiang@inf.ethz.ch Reply-To: zuming.jiang@inf.ethz.ch, pgsql-bugs@lists.postgresql.org Date: Wed, 27 Dec 2023 09:33:34 +0000 Message-ID: <18260-1b6a0c4ae311b837@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 --===============3586674245783283722== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI2MApMb2dnZWQgYnk6ICAgICAgICAgIFp1bWluZyBKaWFuZwpFbWFp bCBhZGRyZXNzOiAgICAgIHp1bWluZy5qaWFuZ0BpbmYuZXRoei5jaApQb3N0Z3JlU1FMIHZlcnNp b246IDE2LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCk15IGZ1enplciBmaW5kcyBhIGJ1ZyBpbiBQb3N0Z3JlcyAxN2RldmVsLCB3aGljaCB0 cmlnZ2VycyBhbiB1bmV4cGVjdGVkCmVycm9yICJFUlJPUjogIG5lZ2F0aXZlIGJpdG1hcHNldCBt ZW1iZXIgbm90IGFsbG93ZWQiLg0KDQotLS0gU2V0IHVwIGRhdGFiYXNlIC0tLQ0KY3JlYXRlIHRh YmxlIHQwICh2a2V5IGludDQsIGMxIG51bWVyaWMpOw0KY3JlYXRlIHRhYmxlIHQxICh2a2V5IGlu dDQsIGM5IHRleHQsIHByaW1hcnkga2V5KHZrZXkpKTsNCmNyZWF0ZSB2aWV3IHQzIGFzDQpzZWxl Y3QNCiAgICByZWZfMy5jMSBhcyBjXzAsDQogICAgcmVmXzMuYzEgYXMgY18yLA0KICAgIG51bGw6 OmludDQgYXMgY180LA0KICAgIHJpZ2h0KHJlZl8yLmM5LCByZWZfMi52a2V5KSBhcyBjXzYNCiAg ZnJvbQ0KICAgICgoc2VsZWN0IHJlZl8wLnZrZXkgYXMgY18yIGZyb20gdDEgYXMgcmVmXzApIGFz IHN1YnFfMA0KICAgICAgbGVmdCBvdXRlciBqb2luICh0MSBhcyByZWZfMg0KICAgICAgICAgICAg cmlnaHQgb3V0ZXIgam9pbiB0MCBhcyByZWZfMw0KICAgICAgICAgICAgb24gKHJlZl8yLnZrZXkg PSByZWZfMy52a2V5KSkNCiAgICAgIG9uIChzdWJxXzAuY18yID0gcmVmXzMudmtleSkpOw0KDQpU aGUgZnV6emVyIGdlbmVyYXRlcyBhIHRlc3QgY2FzZToNCg0KLS0tIFRlc3QgY2FzZSAtLS0NCndp dGggY3RlXzEgYXMgKHNlbGVjdA0KICAgIHJlZl8xLmNfMCBhcyBjXzIsDQogICAgcmVmXzEuY180 IGFzIGNfMywNCiAgICBjYXNlIHdoZW4gKG51bGxpZihyZWZfMS5jXzIsIHJlZl8xLmNfMCkgPD4g KA0KICAgICAgICAgIHNlbGVjdA0KICAgICAgICAgICAgICByZWZfNTMuY18yIGFzIGNfMA0KICAg ICAgICAgICAgZnJvbQ0KICAgICAgICAgICAgICAodDEgYXMgcmVmXzUyIGxlZnQgb3V0ZXIgam9p biB0MyBhcyByZWZfNTMgb24gdHJ1ZSkNCiAgICAgICAgICAgIHdoZXJlIChyZWZfNTMuY182KSB+ fiAocmVmXzUzLmNfNikNCiAgICAgICAgICAgIG9yZGVyIGJ5IGNfMCBsaW1pdCAxKQ0KICAgICAg ICAgICkgdGhlbiBudWxsIGVsc2UgbnVsbCBlbmQNCiAgICAgICAgIGFzIGNfNA0KICBmcm9tDQog ICAgdDMgYXMgcmVmXzEpDQpzZWxlY3QgMQ0KICBmcm9tDQogICAgY3RlXzEgYXMgcmVmXzMzDQog IHdoZXJlIChyZWZfMzMuY18yID4gKA0KICAgICAgICBzZWxlY3QNCiAgICAgICAgICAgIHJlZl8y MDAuY18yIGFzIGNfMA0KICAgICAgICAgIGZyb20NCiAgICAgICAgICAgIHQzIGFzIHJlZl8yMDAN CiAgICAgICAgICB3aW5kb3cgdzAgYXMgKHBhcnRpdGlvbiBieSByZWZfMzMuY18zIG9yZGVyIGJ5 IHJlZl8zMy5jXzQgZGVzYykNCiAgICAgICAgICBvcmRlciBieSBjXzAgbGltaXQgMSkpOw0KDQot LS0gRXhwZWN0ZWQgYmVoYXZpb3IgLS0tDQpUaGUgdGVzdCBjYXNlIHNob3VsZCBub3QgdHJpZ2dl ciBhbnkgZXJyb3IuDQoNCi0tLSBBY3R1YWwgYmVoYXZpb3IgLS0tDQpUaGUgdGVzdCBjYXNlIHRy aWdnZXIgYW4gZXJyb3I6IA0KDQpFUlJPUjogIG5lZ2F0aXZlIGJpdG1hcHNldCBtZW1iZXIgbm90 IGFsbG93ZWQNCg0KLS0tIFBvc3RncmVzIHZlcnNpb24gLS0tDQpHaXRodWIgY29tbWl0OiAwZWFj M2M3OThjMmQyMjNkNjU1N2E1NDQwZDc1MzQzMTdkYmQ0ZmEwDQpWZXJzaW9uOiBQb3N0Z3JlU1FM IDE3ZGV2ZWwgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChVYnVudHUK OS40LjAtMXVidW50dTF+MjAuMDQuMSkgOS40LjAsIDY0LWJpdA0KDQotLS0gUGxhdGZvcm0gaW5m b3JtYXRpb24gLS0tDQpQbGF0Zm9ybTogVWJ1bnR1IDIwLjA0DQpLZXJuZWw6IExpbnV4IDUuNC4w LTE0Ny1nZW5lcmljCgo= --===============3586674245783283722==--