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 1odWBz-00084S-16 for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Sep 2022 12:29:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1odWBx-0001ty-U6 for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Sep 2022 12:29:33 +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 1odW5j-00040x-Jo for pgsql-bugs@lists.postgresql.org; Wed, 28 Sep 2022 12:23:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1odW5g-00068u-GO for pgsql-bugs@lists.postgresql.org; Wed, 28 Sep 2022 12:23: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=N5a3lZpOfYNXTPoZ9mpQ01s+0cm3DjpIHxRcl9GrME8=; b=6MSn7CruW7enG/u5Ek8/b97h9M ay9dX3bU9AWMIw6I8dlOKaXdIkwlFoEKPktpKp3xN38KOsLJxu1pyz5gigRlZt6O/AQfp0ezLlZ/N MYS0124hqs5s9/IEAH34gvVzIBym4LhHIJpmYl1NRzsUyUBGh4cvX3BCvazK5ZwsKwG5LYyaNbUnk YvnEeIdopZo3xJmHFFzBtlZAsOWBDJ2Lo6NQFltuwUJ6jtTUKxsjN0pvM3j0805ielwJtnqjEUnQR zHsCfSWxXLhgDskQhRq/CTXQCh8sEOjXTD1EB8hFq2nggw/PNjZZ54DFDJbDq4S2oImNV3oWH6es+ HiRr0gBg==; 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 1odW5g-0000lG-4X for pgsql-bugs@lists.postgresql.org; Wed, 28 Sep 2022 12:23: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 1odW5e-008T4N-Ec for pgsql-bugs@lists.postgresql.org; Wed, 28 Sep 2022 12:23:02 +0000 Content-Type: multipart/mixed; boundary="===============0034080284964498034==" MIME-Version: 1.0 Subject: BUG #17623: WHERE should be evaluated after FROM clause when operators may throw To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zabetak@gmail.com Reply-To: zabetak@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 28 Sep 2022 12:22:50 +0000 Message-ID: <17623-2bef2f4ff7fe8051@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 --===============0034080284964498034== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzYyMwpMb2dnZWQgYnk6ICAgICAgICAgIFN0YW1hdGlzIFphbXBldGFr aXMKRW1haWwgYWRkcmVzczogICAgICB6YWJldGFrQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE0LjUKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTAuMi4xLTYKRGVzY3JpcHRpb246 ICAgICAgICAKClN0ZXBzIHRvIHJlcHJvZHVjZToNCkNSRUFURSBUQUJMRSBlbXAgKGVtcG5vIElO VCwgbmFtZSBWQVJDSEFSLCBkZXB0bm8gSU5UKTsNCklOU0VSVCBJTlRPIGVtcCBWQUxVRVMgKDAs ICdBbGV4JywgMCk7DQpJTlNFUlQgSU5UTyBlbXAgVkFMVUVTICgxMCwgJ0JvYicsIDEpOw0KDQpD UkVBVEUgVEFCTEUgZGVwdCAoZGVwdG5vIElOVCk7DQpJTlNFUlQgSU5UTyBkZXB0IFZBTFVFUyAo MSk7DQoNClNFTEVDVCBlLm5hbWUNCkZST00gZW1wIGUgDQpJTk5FUiBKT0lOIGRlcHQgZCBPTiBl LmRlcHRubyA9IGQuZGVwdG5vDQpXSEVSRSAoMTAgLyBlLmVtcG5vKSA9IDENCg0KQWN0dWFsIG91 dHB1dDoNCkVSUk9SOiAgZGl2aXNpb24gYnkgemVybw0KDQpFeHBlY3RlZCBvdXRwdXQ6DQpCb2IN Cg0KVGhlIGVycm9yIGlzIGNhdXNlZCBzaW5jZSB0aGUgZmlsdGVyIGNvbmRpdGlvbiBpbiB0aGUg V0hFUkUgY2xhdXNlIGlzCmV2YWx1YXRlZCBiZWZvcmUgdGhlIGpvaW4uIEZpbHRlciBwdXNoLWRv d24gaXMgYSB2ZXJ5IGNvbW1vbiBhbmQgcG93ZXJmdWwKb3B0aW1pemF0aW9uIGJ1dCB3aGVuIHRo ZXJlIGFyZSBvcGVyYXRvcnMgaW4gdGhlIFdIRVJFIGNsYXVzZSB0aGF0IG1heSB0aHJvdwooc3Vj aCBhcyBkaXZpc2lvbiwgY2FzdCwgZXRjKSB0aGlzIG9wdGltaXphdGlvbiBpcyB1bnNhZmUuIA0K DQpUaGUgU1FMIHN0YW5kYXJkIChTZWN0aW9uIDcuNCBnZW5lcmFsIHJ1bGUgMSkgbWFuZGF0ZXMg dGhhdCBXSEVSRSBzaG91bGQgYmUKYXBwbGllZCB0byB0aGUgcmVzdWx0IG9mIEZST00gc28gaW4g dGhlIGNhc2UgYWJvdmUgcHVzaGluZyBmaWx0ZXJzIGJlbG93IHRoZQpqb2luIHNlZW1zIHRvIHZp b2xhdGUgdGhlIHN0YW5kYXJkLiANCg0KQ2l0aW5nIHRoZSBzdGFuZGFyZDoNCiJJZiBhbGwgb3B0 aW9uYWwgY2xhdXNlcyBhcmUgb21pdHRlZCwgdGhlbiB0aGUgcmVzdWx0IG9mIHRoZSA8dGFibGUK ZXhwcmVzc2lvbj4gaXMgdGhlIHNhbWUgYXMgdGhlIHJlc3VsdCBvZiB0aGUNCjxmcm9tIGNsYXVz ZT4uIE90aGVyd2lzZSwgZWFjaCBzcGVjaWZpZWQgY2xhdXNlIGlzIGFwcGxpZWQgdG8gdGhlIHJl c3VsdCBvZgp0aGUgcHJldmlvdXNseSBzcGVjaWZpZWQgY2xhdXNlDQphbmQgdGhlIHJlc3VsdCBv ZiB0aGUgPHRhYmxlIGV4cHJlc3Npb24+IGlzIHRoZSByZXN1bHQgb2YgdGhlIGFwcGxpY2F0aW9u IG9mCnRoZSBsYXN0IHNwZWNpZmllZCBjbGF1c2UuIg0KDQpPbmUgb2YgdGhlIG9wdGlvbmFsIGNs YXVzZXMgbWVudGlvbmVkIGluIHRoZSBwcmV2aW91cyBwYXJhZ3JhcGggaXMgdGhlCjx3aGVyZSBj bGF1c2U+LiBUaGVyZSBzZWVtcyB0byBiZSBhIGNsZWFybHkgZGVmaW5lZCBvcmRlciBiZXR3ZWVu IHRoZSA8ZnJvbQpjbGF1c2U+LCB3aGljaCBpbmNsdWRlcyBpbm5lciBqb2lucywgYW5kIHRoZSA8 d2hlcmUgY2xhdXNlPi4KCg== --===============0034080284964498034==--