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 1pHgtU-0003cP-8K for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Jan 2023 08:00:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pHgtS-00059J-Ol for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Jan 2023 08:00:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pHgtQ-000598-TH for pgsql-bugs@lists.postgresql.org; Tue, 17 Jan 2023 08:00:30 +0000 Received: from out162-62-57-49.mail.qq.com ([162.62.57.49]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pHgtI-0000U6-IY for pgsql-bugs@lists.postgresql.org; Tue, 17 Jan 2023 08:00:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; t=1673942410; bh=WhLZ72eF7o7tHx2ooXihld5iB9f3/IC8p5BfbReE/24=; h=From:To:Subject:Date; b=lc+/hyLnJUN8mzPakTf0USqXlluiW9DfW/OHR4xYDv+1UQaBBLZU3jkvaLGjd38P+ fxC415MH7oyq8EHHO5kAAPKbaU1DFuo3ve+nffmALLP0LIBNJoMbkVc2+DW0wQCsqy UIzQO232Um2/kDNaTbJx8GuhdoK5JCrxSVQrRlRE= X-QQ-FEAT: oHWrrGTW1dBTnKP3Che0i2Hp9hOJtN+C X-QQ-SSF: 00000000000000F0000000000000 X-QQ-XMAILINFO: NlVsI/9Uy/sMQGkDxlPh6ZPBsPlBnbLr3Ji3Wt+uG243Gqhi9PHlbO9SC1PtjD EovJz4bjHMtyC7ceY4PNc85KErwR0mI007JOEgCjYJHiuJZoWaH6EEtDRHs3zfaO4eBgmDyguPKB/ y/aPDDNk+zUv6J0w9Erix4QwllwVm8reIt+PTx1G1QWJMdDKTlYi46QqY5w4zoqexbixyWdgMvk0h R5NH4Ca8Mv9moS0+3/g07I40QOAP5wMArMbAxsVg3SWUbJUJ0LDM4IsyUYQPTSvmqecjeo9bSnzKO P7Xr8tEhVQvQhEFH2Z7Dq08mWWQpD9sItVzSMvDuuqgrYYQxQoOGfYTCrFA+pUy6pe8QBcZz6F7o4 1B6CHhj9NN/PNRG1hJMm54P2Ge6qzyQq6phZZBV1mxrXjucYmkIj0mybnZURJs+H+VwiUg9d2SFNv c64afrsehzaTVYJqMoMyUOM9R3pKzF4pbmtX/1MPMaL9ZIy5frDLcVAlz5zL9lC3X454aoxtqOWVf Dwdx7rL1ngcfgiwEGCxebHs79w0M5ZLJ/aUtK20YyDaQteCicxg5Jr525r0I9MfKjJnSlpailg8Re FFbgbwYSdLprWYwMUO/3f+lAHfE7xc1O0CoxqG6u8UorDdDfcU1P1CSXXwV3KKcSnbZ9UT9bOMhOv FBiKKazSzbvYuxLoLmEJoV1qcwiD+DumSNGA6pSM6s0ZUoK+kaV5uVahOgiGAePERiM9z8rf+lBTg c1II61FwmkAt0Qr0gWi/+jyuuZWa5eAqyggL1t8wAmCjijTYgplbgKEogmHGmDDRhmaZ1hn5YjSbB yyRNJclwhZmoMtWIOj7+l+EpfIz/V7xCAef/IysKCl2gYd1z+2m0pfeXwpvjeF4PFbVif/9Is/P3p 8S4IVGz9KSOHa/6a6h2qOjwUUB/wxy+k6MGZNUoh4tvhLPdl6igDYRuhCJT7nNzPdNLOoeWx2aRxY 0mZGFGEUs6K3t8gkBgOyGHQCxlJWXBQcuh3ozlj+KSS57i1wCLEt8BzXBt9meRSiWx22DsOA== X-HAS-ATTACH: no X-QQ-BUSINESS-ORIGIN: 2 X-Originating-IP: 130.214.175.204 X-QQ-STYLE: X-QQ-mid: webmail322t1673942410t3931265 From: "=?ISO-8859-1?B?WGlvbmcgSGU=?=" To: "=?ISO-8859-1?B?cGdzcWwtYnVncw==?=" Subject: Possible wrong result with some "in" subquery with non-existing columns Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_63C65589_120BB6C8_1825E6BE" Content-Transfer-Encoding: 8Bit Date: Tue, 17 Jan 2023 08:00:09 +0000 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_63C65589_120BB6C8_1825E6BE Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 RGVhciBBbGwsDQoNCg0KVGhpcyBpcyBhIGNvbW1vbiBzY2VuYXJpbyBpbiBiZWxvdyBxdWVy eS4mbmJzcDsgSSBqdXN0IHZlcmlmaWVkIGluIHRoZSBwZzE0LnguDQoNCg0KDQpteWRiPSMg Y3JlYXRlIHRhYmxlIHRlc3QxKGlkMSBpbnQgcHJpbWFyeSBrZXksIGNvbDIgdmFyY2hhcigz MikpOw0KQ1JFQVRFIFRBQkxFDQpteWRiPSMgY3JlYXRlIHRhYmxlIHRlc3QyKGlkMiBpbnQg cHJpbWFyeSBrZXksIGNvbDIgdmFyY2hhcigzMikpOw0KQ1JFQVRFIFRBQkxFDQpteWRiPSMg aW5zZXJ0IGludG8gdGVzdDEgdmFsdWVzKDEsICd3YW5nJyk7DQpJTlNFUlQgMCAxDQpteWRi PSMgaW5zZXJ0IGludG8gdGVzdDIgdmFsdWVzKDIsICd0dHR0Jyk7DQpJTlNFUlQgMCAxDQpt eWRiPSMgc2VsZWN0ICogZnJvbSB0ZXN0MSB3aGVyZSBpZDEgaW4gKHNlbGVjdCBpZDEgZnJv bSB0ZXN0MiB3aGVyZSBpZDIgPSAyKTsNCiZuYnNwO2lkMSB8IGNvbDINCi0tLS0tKy0tLS0t LQ0KJm5ic3A7Jm5ic3A7IDEgfCB3YW5nDQooMSByb3cpDQoNCm15ZGI9IyBpbnNlcnQgaW50 byB0ZXN0MSB2YWx1ZXMoMywgJ3dhbmcnKTsNCklOU0VSVCAwIDENCm15ZGI9IyBzZWxlY3Qg KiBmcm9tIHRlc3QxIHdoZXJlIGlkMSBpbiAoc2VsZWN0IGlkMSBmcm9tIHRlc3QyIHdoZXJl IGlkMiA9IDIpOw0KJm5ic3A7aWQxIHwgY29sMg0KLS0tLS0rLS0tLS0tDQombmJzcDsmbmJz cDsgMSB8IHdhbmcNCiZuYnNwOyZuYnNwOyAzIHwgd2FuZw0KKDIgcm93cykNCg0KDQoNCklu IHRoZSBhYm92ZSBxdWVyeTombmJzcDsgaWQxIGlzIG5vdCBhIGNvbHVtbiBvZiB0YWJsZSB0 ZXN0Mi4NClNob3VsZCBub3Qgd2UgZXhwZWN0IHRoaXMgc2hvdWxkIGJlIGVuIGVycm9yIGlu c3RlYWQgb2YgaXQgdGhpbmtpbmcgaXQncyBhIGNvbHVtbiBmcm9tIHRoZSB0YWJsZSA6IHRl c3QxPyANCg0KDQpSZWdhcmRzLA0KWGlvbmc= ------=_NextPart_63C65589_120BB6C8_1825E6BE Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: base64 PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNo YXJzZXQ9R0IxODAzMCI+PGRpdj5EZWFyIEFsbCw8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2 PlRoaXMgaXMgYSBjb21tb24gc2NlbmFyaW8gaW4gYmVsb3cgcXVlcnkuJm5ic3A7IEkganVz dCB2ZXJpZmllZCBpbiB0aGUgcGcxNC54Ljxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2 Pm15ZGI9IyBjcmVhdGUgdGFibGUgdGVzdDEoaWQxIGludCBwcmltYXJ5IGtleSwgY29sMiB2 YXJjaGFyKDMyKSk7PGJyPkNSRUFURSBUQUJMRTxicj5teWRiPSMgY3JlYXRlIHRhYmxlIHRl c3QyKGlkMiBpbnQgcHJpbWFyeSBrZXksIGNvbDIgdmFyY2hhcigzMikpOzxicj5DUkVBVEUg VEFCTEU8YnI+bXlkYj0jIGluc2VydCBpbnRvIHRlc3QxIHZhbHVlcygxLCAnd2FuZycpOzxi cj5JTlNFUlQgMCAxPGJyPm15ZGI9IyBpbnNlcnQgaW50byB0ZXN0MiB2YWx1ZXMoMiwgJ3R0 dHQnKTs8YnI+SU5TRVJUIDAgMTxicj5teWRiPSMgc2VsZWN0ICogZnJvbSB0ZXN0MSB3aGVy ZSBpZDEgaW4gKHNlbGVjdCBpZDEgZnJvbSB0ZXN0MiB3aGVyZSBpZDIgPSAyKTs8YnI+Jm5i c3A7aWQxIHwgY29sMjxicj4tLS0tLSstLS0tLS08YnI+Jm5ic3A7Jm5ic3A7IDEgfCB3YW5n PGJyPigxIHJvdyk8YnI+PGJyPm15ZGI9IyBpbnNlcnQgaW50byB0ZXN0MSB2YWx1ZXMoMywg J3dhbmcnKTs8YnI+SU5TRVJUIDAgMTxicj5teWRiPSMgc2VsZWN0ICogZnJvbSB0ZXN0MSB3 aGVyZSBpZDEgaW4gKHNlbGVjdCBpZDEgZnJvbSB0ZXN0MiB3aGVyZSBpZDIgPSAyKTs8YnI+ Jm5ic3A7aWQxIHwgY29sMjxicj4tLS0tLSstLS0tLS08YnI+Jm5ic3A7Jm5ic3A7IDEgfCB3 YW5nPGJyPiZuYnNwOyZuYnNwOyAzIHwgd2FuZzxicj4oMiByb3dzKTxicj48L2Rpdj48ZGl2 Pjxicj48L2Rpdj48ZGl2PkluIHRoZSBhYm92ZSBxdWVyeTombmJzcDsgaWQxIGlzIG5vdCBh IGNvbHVtbiBvZiB0YWJsZSB0ZXN0Mi48L2Rpdj48ZGl2PlNob3VsZCBub3Qgd2UgZXhwZWN0 IHRoaXMgc2hvdWxkIGJlIGVuIGVycm9yIGluc3RlYWQgb2YgaXQgdGhpbmtpbmcgaXQncyBh IGNvbHVtbiBmcm9tIHRoZSB0YWJsZSA6IHRlc3QxPyA8YnI+PC9kaXY+PGJyPjxkaXY+PGRp diBzdHlsZT0iZm9udC1zaXplOjE0cHg7Zm9udC1mYW1pbHk6VmVyZGFuYTtjb2xvcjojMDAw OyI+PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6ICdsdWNpZGEgR3JhbmRlJywgVmVyZGFuYTsg Zm9udC1zaXplOiAxMnB4OyBsaW5lLWhlaWdodDogMThweDsgIj5SZWdhcmRzLDwvZGl2Plhp b25nIDxicj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTogJ2x1Y2lkYSBHcmFuZGUnLCBWZXJk YW5hOyBmb250LXNpemU6IDEycHg7IGxpbmUtaGVpZ2h0OiAxOHB4OyAiPjxicj48L2Rpdj48 L2Rpdj48L2Rpdj4= ------=_NextPart_63C65589_120BB6C8_1825E6BE--