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 1iyntl-0002z9-Bf for pgsql-bugs@arkaria.postgresql.org; Tue, 04 Feb 2020 02:25:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iyntk-0002sr-4j for pgsql-bugs@arkaria.postgresql.org; Tue, 04 Feb 2020 02:25:08 +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 1iyntj-0002sk-TG for pgsql-bugs@lists.postgresql.org; Tue, 04 Feb 2020 02:25:07 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1iynth-0006SG-6G for pgsql-bugs@lists.postgresql.org; Tue, 04 Feb 2020 02:25:07 +0000 Content-Type: multipart/mixed; boundary="===============8238025378957072617==" MIME-Version: 1.0 Subject: BUG #16242: convert_tuple_* not handling missing values correctly To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andrew@tao11.riddles.org.uk Reply-To: andrew@tao11.riddles.org.uk, pgsql-bugs@lists.postgresql.org Date: Tue, 04 Feb 2020 02:24:47 +0000 Message-ID: <16242-d1c9fca28445966b@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8238025378957072617== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjI0MgpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJldyBHaWVydGgKRW1h aWwgYWRkcmVzczogICAgICBhbmRyZXdAdGFvMTEucmlkZGxlcy5vcmcudWsKUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMi4xCk9wZXJhdGluZyBzeXN0ZW06ICAgYW55CkRlc2NyaXB0aW9uOiAgICAgICAg CgpUaGUgZm9sbG93aW5nIGV4YW1wbGUgc2hvd3MgYSB0dXBsZSBhcHBlYXJpbmcgd2l0aCBOVUxM cyBpbiBhIGNvbHVtbgpkZWNsYXJlZCBOT1QgTlVMTCwgYmVjYXVzZSB0aGVyZSBpcyBhIG1pc3Np bmcgZGVmYXVsdCB2YWx1ZSBub3QgYmVpbmcgZmlsbGVkCmluLiBUaGUgY2F1c2UgaXMgdGhhdCBj b252ZXJ0X3R1cGxlc19ieV9uYW1lLCBvciBtb3JlIHByZWNpc2VseQpjaGVja19hdHRybWFwX21h dGNoLCB0aGlua3MgdGhhdCBpdCdzIGVub3VnaCBmb3IgdGhlIHR1cGRlc2NzIHRvIG1hdGNoIHVw IGFzCnJlZ2FyZHMgYXR0bnVtcy9uYW1lcy90eXBlcywgd2l0aG91dCBjb25zaWRlcmluZyB0aGF0 IHRoZSBzb3VyY2UgdHVwZGVzYwptaWdodCBoYXZlIG1pc3NpbmcgdmFsdWVzIHRoYXQgdGhlIGRl c3RpbmF0aW9uIGRvZXMgbm90LiBTbyBpdCBpbmNvcnJlY3RseQpjb25jbHVkZXMgdGhhdCBubyBj b252ZXJzaW9uIGlzIG5lZWRlZCwgYW5kIHRoZSBtaXNzaW5nIHZhbHVlcyBiZWNvbWUKbnVsbC4N Cg0KVGhpcyB0ZXN0IGNhc2UgdXNlcyBhIHRyaWdnZXIgb24gYSBwYXJ0aXRpb25lZCB0YWJsZSB0 byBkZW1vbnN0cmF0ZSwgYnV0IHRoZQphY3R1YWwgcHJvYmxlbSB3YXMgZGlzY292ZXJlZCBpbiBh IGRpZmZlcmVudCBjb250ZXh0IChWaWsgRmVhcmluZydzCiJwZXJpb2RzIiBleHRlbnNpb24pLiBJ dCBpcyBsaWtlbHkgdGhhdCBvdGhlciB1c2VycyBvZgpjb252ZXJ0X3R1cGxlc19ieV9uYW1lIChh bmQgSSBrbm93IHRoZXJlIGFyZSBvdGhlciBub24tY29yZSBtb2R1bGVzIHRoYXQgdXNlCnRoaXMp IGFyZSBhZmZlY3RlZCBsaWtld2lzZS4NCg0KLS0gcGFydGl0aW9uZWQgdGFibGUgKHBhcmVudCkN CmNyZWF0ZSB0YWJsZSBiYXIxIChhIGludGVnZXIsIGIgaW50ZWdlciBub3QgbnVsbCBkZWZhdWx0 IDEpDQogIHBhcnRpdGlvbiBieSByYW5nZSAoYSk7DQoNCi0tIHRoaXMgd2lsbCBiZWNvbWUgYSBw YXJ0aXRpb246DQpjcmVhdGUgdGFibGUgYmFyMiAoYSBpbnRlZ2VyKTsNCmluc2VydCBpbnRvIGJh cjIgdmFsdWVzICgxKTsNCmFsdGVyIHRhYmxlIGJhcjIgYWRkIGNvbHVtbiBiIGludGVnZXIgbm90 IG51bGwgZGVmYXVsdCAxOw0KDQotLSAoYXQgdGhpcyBwb2ludCBiYXIyIGNvbnRhaW5zIHR1cGxl IHdpdGggbmF0dHM9MSkNCg0KYWx0ZXIgdGFibGUgYmFyMSBhdHRhY2ggcGFydGl0aW9uIGJhcjIg ZGVmYXVsdDsNCg0KLS0gdGhpcyB3b3JrczoNCg0Kc2VsZWN0ICogZnJvbSBiYXIxOw0KDQotLSB0 aGlzIGRvZXNuJ3Q6DQoNCmNyZWF0ZSBmdW5jdGlvbiB4dHJpZygpDQogIHJldHVybnMgdHJpZ2dl cg0KICBsYW5ndWFnZSBwbHBnc3FsDQphcyAkJA0KICBkZWNsYXJlDQogICAgciByZWNvcmQ7DQog IGJlZ2luDQogICAgZm9yIHIgaW4gc2VsZWN0ICogZnJvbSBvbGQgbG9vcA0KICAgICAgcmFpc2Ug aW5mbyAnYT0lLCBiPSUnLCByLmEsIHIuYjsNCiAgICBlbmQgbG9vcDsNCiAgICByZXR1cm4gTlVM TDsNCiAgZW5kOw0KJCQ7DQoNCmNyZWF0ZSB0cmlnZ2VyIHh0cmlnDQogIGFmdGVyIHVwZGF0ZSBv biBiYXIxDQogIHJlZmVyZW5jaW5nIG9sZCB0YWJsZSBhcyBvbGQNCiAgZm9yIGVhY2ggc3RhdGVt ZW50IGV4ZWN1dGUgcHJvY2VkdXJlIHh0cmlnKCk7DQoNCnVwZGF0ZSBiYXIxIHNldCBhID0gYSAr IDE7Cgo= --===============8238025378957072617==--