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 1jTknn-00020Q-MH for pgsql-bugs@arkaria.postgresql.org; Wed, 29 Apr 2020 11:22:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jTknm-00076B-Ks for pgsql-bugs@arkaria.postgresql.org; Wed, 29 Apr 2020 11:22:54 +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 1jTcIa-0007Rg-4K for pgsql-bugs@lists.postgresql.org; Wed, 29 Apr 2020 02:18:08 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jTcIV-0000fB-Ke for pgsql-bugs@lists.postgresql.org; Wed, 29 Apr 2020 02:18:07 +0000 Content-Type: multipart/mixed; boundary="===============4885901679988029012==" MIME-Version: 1.0 Subject: BUG #16400: IN (query) allows for reference to column that doesn't exist To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: postgresql@mscott.org Reply-To: postgresql@mscott.org, pgsql-bugs@lists.postgresql.org Date: Wed, 29 Apr 2020 02:17:04 +0000 Message-ID: <16400-84f68bb46ba963e5@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4885901679988029012== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQwMApMb2dnZWQgYnk6ICAgICAgICAgIFNjb3R0IE1hcmN5CkVtYWls IGFkZHJlc3M6ICAgICAgcG9zdGdyZXNxbEBtc2NvdHQub3JnClBvc3RncmVTUUwgdmVyc2lvbjog MTIuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIE1hYyBPUwpEZXNjcmlwdGlvbjogICAgICAgIAoKVGhl IGZvbGxvd2luZyBjb2RlIHNob3VsZCBnZW5lcmF0ZSBhbiBlcnJvciBmb3IgYW4gdW5rbm93biBj b2x1bW4gaW4gdGhlClNFTEVDVCBxdWVyeSB0aGF0IHVzZXMgSU4gKCksIGJ1dCBpdCBkb2VzIG5v dCwgYW5kIGl0IGJlaGF2ZXMgYXMgdGhvdWdoIGFsbApyb3dzIHBhc3MgdGhlIElOIHRlc3QuIEEg c3RhbmRhbG9uZSBTRUxFQ1Qgb24gdGhlIG1pc3NpbmcgY29sdW1uIGdlbmVyYXRlcwphbiBlcnJv ciBhcyBpdCBzaG91bGQuIEkndmUgYXR0YWNoZWQgdHdvIGV4YW1wbGVzLCBvbmUgdXNpbmcgYSB2 aWV3LCBvbmUKdXNpbmcgYSB0ZW1wb3JhcnkgdGFibGUsIGJvdGggb2Ygd2hpY2ggZXhoaWJpdCB0 aGUgc2FtZSBwcm9ibGVtLiBOb3RlLApob3dldmVyLCB0aGF0IHVzaW5nIGFub3RoZXIgY29sdW1u IG5hbWUgbGlrZSAiZm9vIiBkb2VzIHByb3Blcmx5IGdlbmVyYXRlIGFuCmVycm9yIGF0IHRoZSBJ TiBzdWJxdWVyeS4NCg0KLS0gU2FtcGxlIHVzaW5nIHZpZXcNCkJFR0lOOw0KDQpDUkVBVEUgVEFC TEUgdGVzdF90YWJsZSAoDQogIGlkICAgICAgICAgICAgU0VSSUFMIFBSSU1BUlkgS0VZLA0KICBm aXJzdF9uYW1lICAgIHRleHQsDQogIGxhc3RfbmFtZSAgICAgdGV4dCwNCiAgZW1haWwgICAgICAg ICB0ZXh0DQopOw0KDQpJTlNFUlQgSU5UTyB0ZXN0X3RhYmxlIChmaXJzdF9uYW1lLCBsYXN0X25h bWUsIGVtYWlsKSBWQUxVRVMgKCdBbGljZScsCidBYmxlJywgJ2EuYWJsZUBleGFtcGxlLmNvbScp LCAoJ0JvYicsICdCdWJibGUnLCAnYi5idWJibGVAZXhhbXBsZS5jb20nKTsNCg0KU0VMRUNUIENP VU5UKCopIEZST00gdGVzdF90YWJsZTsgIC0tIDINCg0KQ1JFQVRFIFZJRVcgdGVzdF92aWV3IEFT IFNFTEVDVCBpZCBBUyB1c2VyX2lkLCBlbWFpbCBGUk9NIHRlc3RfdGFibGUgV0hFUkUKZmlyc3Rf bmFtZSBMSUtFICdBJSc7DQoNClNFTEVDVCBDT1VOVCgqKSBGUk9NIHRlc3RfdmlldzsgLS0gMQ0K DQpTRUxFQ1QgQ09VTlQoKikgRlJPTSB0ZXN0X3RhYmxlIFdIRVJFIGlkIElOIChTRUxFQ1QgaWQg RlJPTSB0ZXN0X3ZpZXcpOyAgIC0tClNob3VsZCBiZSBlcnJvciwgImlkIiBkb2VzIG5vdCBleGlz dCBpbiB0ZXN0X3ZpZXcsIGJ1dCBvdXRwdXRzIDIuDQoNClNFTEVDVCBpZCBGUk9NIHRlc3Rfdmll dzsgLS0gUHJvb2YgImlkIiBkb2VzIG5vdCBleGlzdCBpbiB0ZXN0X3ZpZXcNCg0KUk9MTEJBQ0s7 DQoNCg0KLS0gU2FtcGxlIHVzaW5nIHRlbXBvcmFyeSB0YWJsZQ0KQkVHSU47DQoNCkNSRUFURSBU QUJMRSB0ZXN0X3RhYmxlICgNCiAgaWQgICAgICAgICAgICBTRVJJQUwgUFJJTUFSWSBLRVksDQog IGZpcnN0X25hbWUgICAgdGV4dCwNCiAgbGFzdF9uYW1lICAgICB0ZXh0LA0KICBlbWFpbCAgICAg ICAgIHRleHQNCik7DQoNCklOU0VSVCBJTlRPIHRlc3RfdGFibGUgKGZpcnN0X25hbWUsIGxhc3Rf bmFtZSwgZW1haWwpIFZBTFVFUyAoJ0FsaWNlJywKJ0FibGUnLCAnYS5hYmxlQGV4YW1wbGUuY29t JyksICgnQm9iJywgJ0J1YmJsZScsICdiLmJ1YmJsZUBleGFtcGxlLmNvbScpOw0KDQpTRUxFQ1Qg Q09VTlQoKikgRlJPTSB0ZXN0X3RhYmxlOyAgLS0gMg0KDQpDUkVBVEUgVEVNUE9SQVJZIFRBQkxF IHRlbXBfdGVzdF90YWJsZSBBUyBTRUxFQ1QgaWQgQVMgdXNlcl9pZCwgZW1haWwgRlJPTQp0ZXN0 X3RhYmxlIFdIRVJFIGZpcnN0X25hbWUgTElLRSAnQSUnOw0KDQpTRUxFQ1QgQ09VTlQoKikgRlJP TSB0ZW1wX3Rlc3RfdGFibGU7IC0tIDENCg0KU0VMRUNUIENPVU5UKCopIEZST00gdGVzdF90YWJs ZSBXSEVSRSBpZCBJTiAoU0VMRUNUIGlkIEZST00KdGVtcF90ZXN0X3RhYmxlKTsgICAtLSBTaG91 bGQgYmUgZXJyb3IsICJpZCIgZG9lcyBub3QgZXhpc3QgaW4KdGVtcF90ZXN0X3RhYmxlLCBidXQg b3V0cHV0cyAyLg0KDQpTRUxFQ1QgaWQgRlJPTSB0ZW1wX3Rlc3RfdGFibGU7IC0tIFByb29mICJp ZCIgZG9lcyBub3QgZXhpc3QgaW4KdGVtcF90ZXN0X3RhYmxlLCB3aWxsIGdlbmVyYXRlIGVycm9y IGFzIGV4cGVjdGVkDQoNClJPTExCQUNLOwoK --===============4885901679988029012==--