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 1q9lfN-0001dC-0M for pgsql-bugs@arkaria.postgresql.org; Thu, 15 Jun 2023 12:01:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9lfL-0001dW-Pn for pgsql-bugs@arkaria.postgresql.org; Thu, 15 Jun 2023 12:01:27 +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 1q9iEE-0007gV-R2 for pgsql-bugs@lists.postgresql.org; Thu, 15 Jun 2023 08:21: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 1q9iE7-002Udn-Sg for pgsql-bugs@lists.postgresql.org; Thu, 15 Jun 2023 08:21:14 +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=8r9LaGWGxxtMXMhN4G16GZfkuFD7yrZxlcf/nAYoGzg=; b=WRfaHCrs5VMy8C/8IOV4v2vN5/ 579gmKpPY151PO+AfXtrk8TtGbBul/QsMu7tkrmHNJwq7qQnT2Gci1cQgAQWVhFGfwh5BG9aaio1c z19KRfGpGLfB8704th6lcu1WYdhyqfFLU5F/CNfqMLjHT05CFUcu6Y9ltm0qkJ74AZ11Zs9foDEnz BTb7PMQK/96OXZI7u+MoiQo7sMsYZlxnHPjMxnY0CPjchLLeQQIo+avFWvhiD5Juf21KFu5r9w2tJ Ia6D4uLsYg2slaXymEGy9cYPAX5m7kEL6Xc3vmc/RYO+2HJox+nqoxj4uW7sW87Q6o6f+gQz57eD7 3nFq7Ngw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q9iE5-0000li-1N for pgsql-bugs@lists.postgresql.org; Thu, 15 Jun 2023 08:21:06 +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 1q9iE1-006cK9-Ui for pgsql-bugs@lists.postgresql.org; Thu, 15 Jun 2023 08:21:03 +0000 Content-Type: multipart/mixed; boundary="===============5958688452922388897==" MIME-Version: 1.0 Subject: BUG #17978: Unexpected error: "wrong varnullingrels (b) (expected (b 5)) for Var 6/2" triggered by 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: Thu, 15 Jun 2023 08:20:39 +0000 Message-ID: <17978-12f3d93a55297266@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 --===============5958688452922388897== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk3OApMb2dnZWQgYnk6ICAgICAgICAgIFp1bWluZyBKaWFuZwpFbWFp bCBhZGRyZXNzOiAgICAgIHp1bWluZy5qaWFuZ0BpbmYuZXRoei5jaApQb3N0Z3JlU1FMIHZlcnNp b246IDE2YmV0YTEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246 ICAgICAgICAKCk15IGZ1enplciBmaW5kcyBhIGJ1ZyBpbiBQb3N0Z3Jlcywgd2hpY2ggdHJpZ2dl cnMgYW4gdW5leHBlY3RlZCBlcnJvciBpbgpQb3N0Z3Jlcy4NCg0KLS0tIFNldCB1cCBkYXRhYmFz ZSAtLS0NCkNSRUFURSBUQUJMRSB0MCAodmtleSBpbnRlZ2VyLCBjMSB0aW1lc3RhbXApOw0KQ1JF QVRFIFRBQkxFIHQxICh2a2V5IGludGVnZXIsIHBrZXkgaW50ZWdlcik7DQpDUkVBVEUgVEFCTEUg dDIgKGMxMSB0aW1lc3RhbXAsIGMxNCB0aW1lc3RhbXApOw0KQ1JFQVRFIFZJRVcgdDMgQVMNCiBT RUxFQ1QgcmVmXzAudmtleSBBUyBjXzANCiAgIEZST00gKHQwIHJlZl8wDQogICAgIExFRlQgSk9J TiB0MiByZWZfMSBPTiAoKHJlZl8wLmMxID0gcmVmXzEuYzExKSkpDQogIFdIRVJFICgoZmFsc2Ug PCAoIFNFTEVDVCAocmVmXzAuYzEgPD4gcmVmXzEuYzE0KSBBUyBjXzANCiAgICAgICAgICAgRlJP TSB0MiByZWZfNg0KICAgICAgICAgT1JERVIgQlkgcmVmXzAuYzEsIHJlZl8xLmMxNA0KICAgICAg ICBMSU1JVCAxKSkpOw0KQ1JFQVRFIFZJRVcgdDYgQVMgU0VMRUNUIDEgQVMgY18wLCAyIEFTIGNf MSwgMyBBUyBjXzI7DQpJTlNFUlQgSU5UTyB0MSBWQUxVRVMgKDgwLCA5MDAwMCk7DQpBTFRFUiBU QUJMRSBPTkxZIHQxIEFERCBDT05TVFJBSU5UIHQxX3BrZXkgUFJJTUFSWSBLRVkgKHBrZXkpOw0K LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoNClRoZSBmdXp6ZXIgZ2VuZXJhdGVzIFRlc3QgY2Fz ZToNCg0KLS0tIFRlc3QgY2FzZSAtLS0NCnNlbGVjdCAgDQogICAgcmVmXzM4LmNfMCBhcyBjXzEw IA0KICBmcm9tIA0KICAgICgodDMgYXMgcmVmXzM4DQogICAgICAgIGZ1bGwgb3V0ZXIgam9pbiB0 NiBhcyByZWZfMzkNCiAgICAgICAgb24gKHJlZl8zOC5jXzAgPSByZWZfMzkuY18xKSkNCiAgICAg IHJpZ2h0IG91dGVyIGpvaW4gdDEgYXMgcmVmXzQwDQogICAgICBvbiAocmVmXzM4LmNfMCA9IHJl Zl80MC52a2V5KSk7DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KLS0tIEV4cGVjdGVkIGJl aGF2aW9yIC0tLQ0KVGhlIHRlc3QgY2FzZSBzaG91bGQgbm90IHRyaWdnZXIgYW55IGVycm9yLg0K DQotLS0gQWN0dWFsIGJlaGF2aW9yIC0tLQ0KVGhlIHRlc3QgY2FzZSB0cmlnZ2VyIGFuIGVycm9y OiANCg0KRVJST1I6ICB3cm9uZyB2YXJudWxsaW5ncmVscyAoYikgKGV4cGVjdGVkIChiIDUpKSBm b3IgVmFyIDYvMg0KDQotLS0gUG9zdGdyZXMgdmVyc2lvbiAtLS0NCkdpdGh1YiBjb21taXQ6IDNm MWFhYWExODA2ODlmMjAxNWU3ZjdiZDAxYzliZTZkN2E5OTNiNDINClZlcnNpb246IFBvc3RncmVT UUwgMTZiZXRhMSBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKFVidW50 dQo5LjQuMC0xdWJ1bnR1MX4yMC4wNC4xKSA5LjQuMCwgNjQtYml0DQoNCi0tLSBQbGF0Zm9ybSBp bmZvcm1hdGlvbiAtLS0NClBsYXRmb3JtOiBVYnVudHUgMjAuMDQNCktlcm5lbDogTGludXggNS40 LjAtMTQ3LWdlbmVyaWMKCg== --===============5958688452922388897==--