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 1r1NPS-00AmyP-Dr for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Nov 2023 09:02:38 +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 1r1NPQ-002ZrD-SR for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Nov 2023 09:02:36 +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 1r1BcL-00GmpY-3s for pgsql-bugs@lists.postgresql.org; Thu, 09 Nov 2023 20:27:09 +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 1r1BcH-005aWC-Tj for pgsql-bugs@lists.postgresql.org; Thu, 09 Nov 2023 20:27:08 +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=Y/qfKnQqVCk52lbzV37v1/ReESnRRAGECAlyzWEIDHk=; b=W/jkM/ubkof7VHCFhOVr4wjrkv +GnQN/VQQz+Av33IETrsqi9kHWeVsIb6pQDSz8D5iP2wLPcP+x10teGh0s7QcfI6ipoNlVhsMv5Sf BwgBNVdnjNi9h4HUU+HftL5gpSqJiz7ixYkfEudcej+Gixr0tWfzgJMR2APFla07I/9jUJtwRccVv isTyDsbaFbwMItbKQmhh5Snu4GxSeP/kXsZOJAVsMn2jt6IJDMCim8LEnVWrx1MQKfdvAvTmQBaWB O58XyY1lsdKbLR/Ef1QsZVZthzUbwU+9hM+UWj24k9uaUcnlepv1Cw7twgHJO6oA01Ekvv/CI6vit OEt1DAkw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r1BcG-000VpP-V8 for pgsql-bugs@lists.postgresql.org; Thu, 09 Nov 2023 20:27: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 1r1BcD-000b1Q-Rt for pgsql-bugs@lists.postgresql.org; Thu, 09 Nov 2023 20:27:02 +0000 Content-Type: multipart/mixed; boundary="===============3013464954962095802==" MIME-Version: 1.0 Subject: BUG #18188: wrong varnullingrels To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: fotonszekta@gmail.com Reply-To: fotonszekta@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 09 Nov 2023 20:26:41 +0000 Message-ID: <18188-2e472071c919b3f1@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 --===============3013464954962095802== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE4OApMb2dnZWQgYnk6ICAgICAgICAgIEfDoWJvciBTemFiw7MKRW1h aWwgYWRkcmVzczogICAgICBmb3RvbnN6ZWt0YUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNi4xCk9wZXJhdGluZyBzeXN0ZW06ICAgd2luZG93cywgdWJ1bnR1CkRlc2NyaXB0aW9uOiAg ICAgICAgCgovKg0Kd3JvbmcgdmFybnVsbGluZ3JlbHM6DQpOZWVkZWQgYSB0YWJsZSBmdW5jdGlv biBjYWxsLCBhIExFRlQgSk9JTiB3aXRoIHRoYXQgdGFibGUsIGFuZCBhbiBvdGhlciBqb2luCkFG VEVSIHRoZSBsZWZ0IGpvaW4uDQooVGhlIGZpcnN0IGpvaW4gbXVzdCBiZSBMRUZULCB0aGUgc2Vj b25kIGpvaW4gY2FuIGJlIGFueSB0cHllLiBObyBkYXRhIGluCnRhYmxlcyBuZWVkZWQuKQ0KDQpS ZXByb2R1Y2VkIG9uOg0KV2luZG93cyAxMSArIFBvc3RncmVTUUwgMTYuMCwgMTYuMQ0KVWJ1bnR1 IDIyLjA0LjMgKyBQb3N0Z3JlU1FMIDE2LjENCg0KVGVzdGVkIHdpdGggbm8gZXJyb3I6IA0KV2lu ZG93cyAxMSArIFBvc3RnclNRTCAxNS40LCAxNS41LCANClVidW50dSAyMi4wNC4zICsgUG9zdGdy ZVNRTCAxMi4xNywgMTIuMTYsDQpVYnVudHUgMjAuMDQuNiArIFBvc3RncmVTUUwgMTQuOQ0KDQpF cnJvciBtZXNzYWdlIGZyb20gdmVyYm9zZSBsb2c6DQoNCkVSUk9SOiAgWFgwMDA6IHdyb25nIHZh cm51bGxpbmdyZWxzIChiKSAoZXhwZWN0ZWQgKGIgMykpIGZvciBWYXIgMi8xDQpMT0NBVElPTjog IHNlYXJjaF9pbmRleGVkX3RsaXN0X2Zvcl92YXIsIHNldHJlZnMuYzoyODA3DQpTVEFURU1FTlQ6 ICBTRUxFQ1QNCg0KCSAgdGFibGVfMi5kaXNwLA0KDQoJICB0YWJsZV8zLnRhYmxlXzNfaWQNCg0K CUZST00gdGFibGVfMQ0KDQoJTEVGVCBKT0lOIHRhYmxlXzIgT04gdGFibGVfMi50YWJsZV8yX2lk ID0gdGFibGVfMS50YWJsZV8yX2lkDQoNCglMRUZUIEpPSU4gdGFibGVfMyBPTiB0YWJsZV8zLnRh YmxlXzNfaWQgPSB0YWJsZV8xLnRhYmxlXzNfaWQNCg0KDQpzY3JpcHQgdG8gcmVwcm9kdWNlOg0K Ki8NCi0tDQotLSBQb3N0Z3JlU1FMIGRhdGFiYXNlIGR1bXANCi0tDQoNCi0tIER1bXBlZCBmcm9t IGRhdGFiYXNlIHZlcnNpb24gMTYuMQ0KLS0gRHVtcGVkIGJ5IHBnX2R1bXAgdmVyc2lvbiAxNi4x DQoNClNFVCBzdGF0ZW1lbnRfdGltZW91dCA9IDA7DQpTRVQgbG9ja190aW1lb3V0ID0gMDsNClNF VCBpZGxlX2luX3RyYW5zYWN0aW9uX3Nlc3Npb25fdGltZW91dCA9IDA7DQpTRVQgY2xpZW50X2Vu Y29kaW5nID0gJ1VURjgnOw0KU0VUIHN0YW5kYXJkX2NvbmZvcm1pbmdfc3RyaW5ncyA9IG9uOw0K U0VMRUNUIHBnX2NhdGFsb2cuc2V0X2NvbmZpZygnc2VhcmNoX3BhdGgnLCAnJywgZmFsc2UpOw0K U0VUIGNoZWNrX2Z1bmN0aW9uX2JvZGllcyA9IGZhbHNlOw0KU0VUIHhtbG9wdGlvbiA9IGNvbnRl bnQ7DQpTRVQgY2xpZW50X21pbl9tZXNzYWdlcyA9IHdhcm5pbmc7DQpTRVQgcm93X3NlY3VyaXR5 ID0gb2ZmOw0KDQotLQ0KLS0gTmFtZTogcHVibGljOyBUeXBlOiBTQ0hFTUE7IFNjaGVtYTogLTsg T3duZXI6IHBvc3RncmVzDQotLQ0KDQotLSAqbm90KiBjcmVhdGluZyBzY2hlbWEsIHNpbmNlIGlu aXRkYiBjcmVhdGVzIGl0DQoNCg0KQUxURVIgU0NIRU1BIHB1YmxpYyBPV05FUiBUTyBwb3N0Z3Jl czsNCg0KU0VUIGRlZmF1bHRfdGFibGVzcGFjZSA9ICcnOw0KDQpTRVQgZGVmYXVsdF90YWJsZV9h Y2Nlc3NfbWV0aG9kID0gaGVhcDsNCg0KLS0NCi0tIE5hbWU6IHRhYmxlXzI7IFR5cGU6IFRBQkxF OyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzDQotLQ0KDQpDUkVBVEUgVEFCTEUgcHVi bGljLnRhYmxlXzIgKA0KICAgIHRhYmxlXzJfaWQgaW50ZWdlciBOT1QgTlVMTA0KKTsNCg0KDQpB TFRFUiBUQUJMRSBwdWJsaWMudGFibGVfMiBPV05FUiBUTyBwb3N0Z3JlczsNCg0KLS0NCi0tIE5h bWU6IGRpc3AocHVibGljLnRhYmxlXzIpOyBUeXBlOiBGVU5DVElPTjsgU2NoZW1hOiBwdWJsaWM7 IE93bmVyOgpwb3N0Z3Jlcw0KLS0NCg0KQ1JFQVRFIEZVTkNUSU9OIHB1YmxpYy5kaXNwKHBfdGFi bGVfMiBwdWJsaWMudGFibGVfMikgUkVUVVJOUyBpbnRlZ2VyDQogICAgTEFOR1VBR0Ugc3FsDQog ICAgQVMgJCQNCg0KU0VMRUNUIHBfdGFibGVfMi50YWJsZV8yX2lkDQoNCiQkOw0KDQoNCkFMVEVS IEZVTkNUSU9OIHB1YmxpYy5kaXNwKHBfdGFibGVfMiBwdWJsaWMudGFibGVfMikgT1dORVIgVE8g cG9zdGdyZXM7DQoNCi0tDQotLSBOYW1lOiB0YWJsZV8xOyBUeXBlOiBUQUJMRTsgU2NoZW1hOiBw dWJsaWM7IE93bmVyOiBwb3N0Z3Jlcw0KLS0NCg0KQ1JFQVRFIFRBQkxFIHB1YmxpYy50YWJsZV8x ICgNCiAgICB0YWJsZV8xX2lkIGludGVnZXIgTk9UIE5VTEwsDQogICAgdGFibGVfMl9pZCBpbnRl Z2VyLA0KICAgIHRhYmxlXzNfaWQgaW50ZWdlcg0KKTsNCg0KDQpBTFRFUiBUQUJMRSBwdWJsaWMu dGFibGVfMSBPV05FUiBUTyBwb3N0Z3JlczsNCg0KLS0NCi0tIE5hbWU6IHRhYmxlXzM7IFR5cGU6 IFRBQkxFOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzDQotLQ0KDQpDUkVBVEUgVEFC TEUgcHVibGljLnRhYmxlXzMgKA0KICAgIHRhYmxlXzNfaWQgaW50ZWdlciBOT1QgTlVMTA0KKTsN Cg0KDQpBTFRFUiBUQUJMRSBwdWJsaWMudGFibGVfMyBPV05FUiBUTyBwb3N0Z3JlczsNCg0KLS0N Ci0tIERhdGEgZm9yIE5hbWU6IHRhYmxlXzE7IFR5cGU6IFRBQkxFIERBVEE7IFNjaGVtYTogcHVi bGljOyBPd25lcjoKcG9zdGdyZXMNCi0tDQoNCkNPUFkgcHVibGljLnRhYmxlXzEgKHRhYmxlXzFf aWQsIHRhYmxlXzJfaWQsIHRhYmxlXzNfaWQpIEZST00gc3RkaW47DQpcLg0KDQoNCi0tDQotLSBE YXRhIGZvciBOYW1lOiB0YWJsZV8yOyBUeXBlOiBUQUJMRSBEQVRBOyBTY2hlbWE6IHB1YmxpYzsg T3duZXI6CnBvc3RncmVzDQotLQ0KDQpDT1BZIHB1YmxpYy50YWJsZV8yICh0YWJsZV8yX2lkKSBG Uk9NIHN0ZGluOw0KXC4NCg0KDQotLQ0KLS0gRGF0YSBmb3IgTmFtZTogdGFibGVfMzsgVHlwZTog VEFCTEUgREFUQTsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOgpwb3N0Z3Jlcw0KLS0NCg0KQ09QWSBw dWJsaWMudGFibGVfMyAodGFibGVfM19pZCkgRlJPTSBzdGRpbjsNClwuDQoNCg0KLS0NCi0tIE5h bWU6IHRhYmxlXzEgdGFibGVfMV9wa2V5OyBUeXBlOiBDT05TVFJBSU5UOyBTY2hlbWE6IHB1Ymxp YzsgT3duZXI6CnBvc3RncmVzDQotLQ0KDQpBTFRFUiBUQUJMRSBPTkxZIHB1YmxpYy50YWJsZV8x DQogICAgQUREIENPTlNUUkFJTlQgdGFibGVfMV9wa2V5IFBSSU1BUlkgS0VZICh0YWJsZV8xX2lk KTsNCg0KDQotLQ0KLS0gTmFtZTogdGFibGVfMiB0YWJsZV8yX3BrZXk7IFR5cGU6IENPTlNUUkFJ TlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjoKcG9zdGdyZXMNCi0tDQoNCkFMVEVSIFRBQkxFIE9O TFkgcHVibGljLnRhYmxlXzINCiAgICBBREQgQ09OU1RSQUlOVCB0YWJsZV8yX3BrZXkgUFJJTUFS WSBLRVkgKHRhYmxlXzJfaWQpOw0KDQoNCi0tDQotLSBOYW1lOiB0YWJsZV8zIHRhYmxlXzNfcGtl eTsgVHlwZTogQ09OU1RSQUlOVDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOgpwb3N0Z3Jlcw0KLS0N Cg0KQUxURVIgVEFCTEUgT05MWSBwdWJsaWMudGFibGVfMw0KICAgIEFERCBDT05TVFJBSU5UIHRh YmxlXzNfcGtleSBQUklNQVJZIEtFWSAodGFibGVfM19pZCk7DQoNCg0KLS0NCi0tIE5hbWU6IFND SEVNQSBwdWJsaWM7IFR5cGU6IEFDTDsgU2NoZW1hOiAtOyBPd25lcjogcG9zdGdyZXMNCi0tDQoN ClJFVk9LRSBVU0FHRSBPTiBTQ0hFTUEgcHVibGljIEZST00gUFVCTElDOw0KR1JBTlQgQUxMIE9O IFNDSEVNQSBwdWJsaWMgVE8gUFVCTElDOw0KDQoNCi0tDQotLSBQb3N0Z3JlU1FMIGRhdGFiYXNl IGR1bXAgY29tcGxldGUNCi0tDQoNCi0tIHJlc3RvcmUgc2VhcmNoX3BhdGg6DQpTRUxFQ1QgcGdf Y2F0YWxvZy5zZXRfY29uZmlnKCdzZWFyY2hfcGF0aCcsICdwZ19jYXRhbG9nLCBwdWJsaWMnLCBm YWxzZSk7IA0KDQotLSBxdWVyeToNClNFTEVDVA0KICB0YWJsZV8yLmRpc3AsDQogIHRhYmxlXzMu dGFibGVfM19pZA0KRlJPTSB0YWJsZV8xDQpMRUZUIEpPSU4gdGFibGVfMiBPTiB0YWJsZV8yLnRh YmxlXzJfaWQgPSB0YWJsZV8xLnRhYmxlXzJfaWQNCkxFRlQgSk9JTiB0YWJsZV8zIE9OIHRhYmxl XzMudGFibGVfM19pZCA9IHRhYmxlXzEudGFibGVfM19pZDsKCg== --===============3013464954962095802==--