Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iWVov-0003KA-V0 for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Nov 2019 01:27:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iWVou-0000rI-GY for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Nov 2019 01:27:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iWVou-0000oS-7S for pgsql-bugs@lists.postgresql.org; Mon, 18 Nov 2019 01:27:12 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iWVoo-00081s-Lp for pgsql-bugs@lists.postgresql.org; Mon, 18 Nov 2019 01:27:11 +0000 Content-Type: multipart/mixed; boundary="===============4640454801121341496==" MIME-Version: 1.0 Subject: BUG #16121: 12 regression: Volatile function in target list subquery behave as stable To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: elprans@gmail.com Reply-To: elprans@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 18 Nov 2019 01:26:30 +0000 Message-ID: <16121-b8e8dc82e608b89d@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4640454801121341496== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjEyMQpMb2dnZWQgYnk6ICAgICAgICAgIEVsdmlzIFByYW5za2V2aWNo dXMKRW1haWwgYWRkcmVzczogICAgICBlbHByYW5zQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDEyLjEKT3BlcmF0aW5nIHN5c3RlbTogICBHZW50b28gTGludXgKRGVzY3JpcHRpb246ICAg ICAgICAKClRoZXJlIHNlZW1zIHRvIGJlIGEgcmVncmVzc2lvbiBpbiBQb3N0Z3JlcyAxMiByZWxh dGVkIHRvIGhvdyB2b2xhdGlsZQpmdW5jdGlvbnMgYXJlIGhhbmRsZWQuIElmIHB1dCBpbnNpZGUg YSBzdWJxdWVyeSBpbiB0aGUgdGFyZ2V0IGxpc3QsIHRoZQp2b2xhdGlsZSBmdW5jdGlvbiBzZWVt cyB0byBiZWhhdmUgbGlrZSBhIHN0YWJsZSBvbmU6DQoNCnZvbGF0aWxpdHk9IyBTRUxFQ1QNCiAg IHYuaSwNCiAgIChTRUxFQ1QgcmFuZG9tKCkgZnJvbSAodmFsdWVzICh2LmkpKSBhcyBxKSBBUyB2 MQ0KRlJPTQ0KICAgZ2VuZXJhdGVfc2VyaWVzKDEsIDIpIGFzIHYoaSk7DQogaSDilIIgICAgICAg ICB2MQ0K4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pSA4pSA4pSA4pSA4pSADQogMSDilIIgMC44MzAzNjE1MTI0MjgyMjk1DQogMiDilIIg MC44MzAzNjE1MTI0MjgyMjk1DQooMiByb3dzKQ0KDQpQb3N0Z3JlcyAxMSBhbmQgZWFybGllciB3 b3JrZWQgY29ycmVjdGx5Og0KDQp2b2xhdGlsaXR5PSMgU0VMRUNUDQogICB2LmksDQogICAoU0VM RUNUIHJhbmRvbSgpIGZyb20gKHZhbHVlcyAodi5pKSkgYXMgcSkgQVMgdjENCkZST00NCiAgIGdl bmVyYXRlX3NlcmllcygxLCAyKSBhcyB2KGkpOw0KIGkg4pSCICAgICAgICB2MQ0K4pSA4pSA4pSA 4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA 4pSADQogMSDilIIgMC4xMzc0NzIwNzE2ODQ4OTcNCiAyIOKUgiAwLjI4ODc5ODA4NDAxNjg4OQ0K KDIgcm93cykKCg== --===============4640454801121341496==--