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 1r3dw1-004t9F-7M for pgsql-committers@arkaria.postgresql.org; Thu, 16 Nov 2023 15:05:37 +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 1r3dvz-007NNJ-Sm for pgsql-committers@arkaria.postgresql.org; Thu, 16 Nov 2023 15:05:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r3dvz-007N8F-Dx for pgsql-committers@lists.postgresql.org; Thu, 16 Nov 2023 15:05:35 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r3dvv-005sNL-5Q for pgsql-committers@lists.postgresql.org; Thu, 16 Nov 2023 15:05:33 +0000 Received: from gemulon.postgresql.org ([72.32.157.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-004Afp-D2 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-005jqJ-KI for pgsql-committers@lists.postgresql.org; Thu, 16 Nov 2023 15:05:29 +0000 Content-Type: multipart/mixed; boundary="===============5366740884961183063==" 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 --===============5366740884961183063== 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 MzJmQHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0t Cmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNzQzZGRhZmM3MTI0NjA0 YzFmNTliNWQ5ZjY2MWJlNDdhOTg3YThkMAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0K c3JjL2JhY2tlbmQvY2F0YWxvZy9oZWFwLmMgICAgICAgICAgICAgICAgIHwgIDcgKysrLQpzcmMv YmFja2VuZC9jb21tYW5kcy9jb3B5ZnJvbS5jICAgICAgICAgICAgfCAgNiArKy0Kc3JjL2JhY2tl bmQvY29tbWFuZHMvaW5kZXhjbWRzLmMgICAgICAgICAgIHwgMzEgKy0tLS0tLS0tLS0tLS0Kc3Jj L2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMgICAgICAgICAgIHwgNTAgKysrKysrKysrKyst LS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9jbGF1c2VzLmMgICAgICAgfCA2 NiArKysrKysrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL2luY2x1ZGUvb3B0aW1pemVyL29w dGltaXplci5oICAgICAgICAgIHwgIDIgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2Zhc3Rf ZGVmYXVsdC5vdXQgfCAxOCArKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVy YXRlZC5vdXQgICAgfCAgMyArKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9mYXN0X2RlZmF1bHQuc3Fs ICAgICAgfCAxMSArKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9nZW5lcmF0ZWQuc3FsICAgICAg ICAgfCAgMyArKwoxMCBmaWxlcyBjaGFuZ2VkLCAxNDEgaW5zZXJ0aW9ucygrKSwgNTYgZGVsZXRp b25zKC0pCgo= --===============5366740884961183063==--