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 1r3dx7-004tEg-Bc for pgsql-committers@arkaria.postgresql.org; Thu, 16 Nov 2023 15:06:45 +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 1r3dx5-007PTX-OU for pgsql-committers@arkaria.postgresql.org; Thu, 16 Nov 2023 15:06:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r3dw0-007NTm-Qo for pgsql-committers@lists.postgresql.org; Thu, 16 Nov 2023 15:05:36 +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 1r3dvx-006knR-Lx for pgsql-committers@lists.postgresql.org; Thu, 16 Nov 2023 15:05:36 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r3dvu-004Afl-D4 for pgsql-committers@lists.postgresql.org; Thu, 16 Nov 2023 15:05:30 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r3dvs-005jqP-Lc for pgsql-committers@lists.postgresql.org; Thu, 16 Nov 2023 15:05:29 +0000 Content-Type: multipart/mixed; boundary="===============3281295202719741293==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Ensure we preprocess expressions before checking their volatilit X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 16 Nov 2023 15:05:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3281295202719741293== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5zdXJlIHdlIHByZXByb2Nlc3MgZXhwcmVzc2lvbnMgYmVmb3JlIGNoZWNraW5nIHRoZWlyIHZv bGF0aWxpdHkuCgpjb250YWluX211dGFibGVfZnVuY3Rpb25zIGFuZCBjb250YWluX3ZvbGF0aWxl X2Z1bmN0aW9ucyBnaXZlCnJlbGlhYmxlIGFuc3dlcnMgb25seSBhZnRlciBleHByZXNzaW9uIHBy ZXByb2Nlc3NpbmcgKHNwZWNpZmljYWxseQpldmFsX2NvbnN0X2V4cHJlc3Npb25zKS4gIFNvbWUg cGxhY2VzIHVuZGVyc3RhbmQgdGhpcywgYnV0IHNvbWUgZGlkCm5vdCBnZXQgdGhlIG1lbW8gLS0t IHdoaWNoIGlzIG5vdCBlbnRpcmVseSB0aGVpciBmYXVsdCwgYmVjYXVzZSB0aGUKcHJvYmxlbSBp cyBkb2N1bWVudGVkIG9ubHkgaW4gcGxhY2VzIGZhciBhd2F5IGZyb20gdGhvc2UgZnVuY3Rpb25z LgpJbnRyb2R1Y2Ugd3JhcHBlciBmdW5jdGlvbnMgdGhhdCBhbGxvdyBkb2luZyB0aGUgcmlnaHQg dGhpbmcgZWFzaWx5LAphbmQgYWRkIGNvbW1lbnRhcnkgaW4gaG9wZXMgb2YgcHJldmVudGluZyBm dXR1cmUgbWlzdGFrZXMgZnJvbQpjb3B5LWFuZC1wYXN0ZSBvZiBjb2RlIHRoYXQncyBvbmx5IGNv bmRpdGlvbmFsbHkgc2FmZS4KClR3byBhY3R1YWwgYnVncyBvZiB0aGlzIGlsayBhcmUgZml4ZWQg aGVyZS4gIFdlIGZhaWxlZCB0byBwcmVwcm9jZXNzCmNvbHVtbiBHRU5FUkFURUQgZXhwcmVzc2lv bnMgYmVmb3JlIGNoZWNraW5nIG11dGFiaWxpdHksIHNvIHRoYXQgdGhlCmNvZGUgY291bGQgZmFp bCB0byBkZXRlY3QgdGhlIHVzZSBvZiBhIHZvbGF0aWxlIGZ1bmN0aW9uCmRlZmF1bHQtYXJndW1l bnQgZXhwcmVzc2lvbiwgb3IgaXQgY291bGQgcmVqZWN0IGEgcG9seW1vcnBoaWMgZnVuY3Rpb24K dGhhdCBpcyBhY3R1YWxseSBpbW11dGFibGUgb24gdGhlIGRhdGF0eXBlIG9mIGludGVyZXN0LiAg TGlrZXdpc2UsCmNvbHVtbiBERUZBVUxUIGV4cHJlc3Npb25zIHdlcmVuJ3QgcHJlcHJvY2Vzc2Vk IGJlZm9yZSBkZXRlcm1pbmluZyBpZgppdCdzIHNhZmUgdG8gYXBwbHkgdGhlIGF0dG1pc3Npbmd2 YWwgbWVjaGFuaXNtLiAgQSBmYWxzZSBuZWdhdGl2ZQp3b3VsZCBqdXN0IHJlc3VsdCBpbiBhbiB1 bm5lY2Vzc2FyeSB0YWJsZSByZXdyaXRlLCBidXQgYSBmYWxzZQpwb3NpdGl2ZSBjb3VsZCBhbGxv dyB0aGUgYXR0bWlzc2luZ3ZhbCBtZWNoYW5pc20gdG8gYmUgdXNlZCBpbiBhIGNhc2UKd2hlcmUg aXQgc2hvdWxkIG5vdCBiZSwgcmVzdWx0aW5nIGluIHVuZXhwZWN0ZWQgaW5pdGlhbCB2YWx1ZXMg aW4gYQpuZXcgY29sdW1uLgoKSW4gcGFzc2luZywgcmUtb3JkZXIgdGhlIHN0ZXBzIGluIENvbXB1 dGVQYXJ0aXRpb25BdHRycyBzbyB0aGF0IGl0cwpjaGVja3MgZm9yIGludmFsaWQgY29sdW1uIHJl ZmVyZW5jZXMgYXJlIGRvbmUgYmVmb3JlIGFwcGx5aW5nCmV4cHJlc3Npb25fcGxhbm5lciwgcmF0 aGVyIHRoYW4gYWZ0ZXIuICBUaGUgcHJldmlvdXMgY29kaW5nIHdvdWxkCm5vdCBjb21wbGFpbiBp ZiBhIHBhcnRpdGlvbiBleHByZXNzaW9uIGNvbnRhaW5zIGEgZGlzYWxsb3dlZCBjb2x1bW4KcmVm ZXJlbmNlIHRoYXQgZ2V0cyBvcHRpbWl6ZWQgYXdheSBieSBjb25zdGFudCBmb2xkaW5nLCB3aGlj aCBzZWVtcwp0byBtZSB0byBiZSBhIGJlaGF2aW9yIHdlIGRvIG5vdCB3YW50LgoKUGVyIGJ1ZyAj MTgwOTcgZnJvbSBKaW0gS2VlbmVyLiAgQmFjay1wYXRjaCB0byBhbGwgc3VwcG9ydGVkIHZlcnNp b25zLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xODA5Ny1lYmIxNzk2NzRmMjI5 MzJmQHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0tLS0tClJFTF8xNF9TVEFCTEUKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzliZDBmNzRl YWMxOTk1OTc5ODBhZWE0NWVhZjg4YzUwMmEyMDI2NjUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL2NhdGFsb2cvaGVhcC5jICAgICAgICAgICAgICAgICB8ICA3ICsr Ky0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvY29weWZyb20uYyAgICAgICAgICAgIHwgIDYgKystCnNy Yy9iYWNrZW5kL2NvbW1hbmRzL2luZGV4Y21kcy5jICAgICAgICAgICB8IDMxICstLS0tLS0tLS0t LS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgICB8IDUwICsrKysr KysrKysrLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICAg ICAgIHwgNjYgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrCnNyYy9pbmNsdWRlL29wdGlt aXplci9vcHRpbWl6ZXIuaCAgICAgICAgICB8ICAyICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9mYXN0X2RlZmF1bHQub3V0IHwgMTggKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9nZW5lcmF0ZWQub3V0ICAgIHwgIDMgKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvZmFzdF9kZWZh dWx0LnNxbCAgICAgIHwgMTEgKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2VuZXJhdGVkLnNx bCAgICAgICAgIHwgIDMgKysKMTAgZmlsZXMgY2hhbmdlZCwgMTQxIGluc2VydGlvbnMoKyksIDU2 IGRlbGV0aW9ucygtKQoK --===============3281295202719741293==--