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 1iiM2T-0001Vi-Lx for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Dec 2019 17:26: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 1iiM2S-0007hz-Dn for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Dec 2019 17:26: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 1iiM2S-0007hs-5G for pgsql-bugs@lists.postgresql.org; Fri, 20 Dec 2019 17:26:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1iiM2P-0002b9-HC for pgsql-bugs@lists.postgresql.org; Fri, 20 Dec 2019 17:26:07 +0000 Content-Type: multipart/mixed; boundary="===============0760405588726134080==" MIME-Version: 1.0 Subject: BUG #16176: NULL value returned by category_sql argument to crosstab() causes segmentation fault To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ipluta@wp.pl Reply-To: ipluta@wp.pl, pgsql-bugs@lists.postgresql.org Date: Fri, 20 Dec 2019 17:25:56 +0000 Message-ID: <16176-7489719b05e4303c@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0760405588726134080== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE3NgpMb2dnZWQgYnk6ICAgICAgICAgIElyZW5ldXN6IFBsdXRhCkVt YWlsIGFkZHJlc3M6ICAgICAgaXBsdXRhQHdwLnBsClBvc3RncmVTUUwgdmVyc2lvbjogMTIuMQpP cGVyYXRpbmcgc3lzdGVtOiAgIEZyZWVCU0QgMTIuMQpEZXNjcmlwdGlvbjogICAgICAgIAoKVGhl IHRlc3RjYXNlOg0KDQogICAgJCBwc3FsIC1YYSBzZXJ2aWNlPXRlc3QgPCB0ZXN0Y2FzZS5zcWwg DQogICAgXHBzZXQgbnVsbCA8TlVMTD4NCiAgICBOdWxsIGRpc3BsYXkgaXMgIjxOVUxMPiIuDQog ICAgc2VsZWN0IHZlcnNpb24oKTsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCnZlcnNpb24gICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAKICANCiAgIAotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAgICAgUG9z dGdyZVNRTCAxMi4xIG9uIHg4Nl82NC11bmtub3duLWZyZWVic2QxMi4xLCBjb21waWxlZCBieSBG cmVlQlNECmNsYW5nIHZlcnNpb24gOC4wLjEgKHRhZ3MvUkVMRUFTRV84MDEvZmluYWwgMzY2NTgx KSAoYmFzZWQgb24gTExWTSA4LjAuMSksCjY0LWJpdA0KICAgICgxIHJvdykNCiAgICDigIsNCiAg ICBjcmVhdGUgZXh0ZW5zaW9uIGlmIG5vdCBleGlzdHMgdGFibGVmdW5jOw0KICAgIE5PVElDRTog IGV4dGVuc2lvbiAidGFibGVmdW5jIiBhbHJlYWR5IGV4aXN0cywgc2tpcHBpbmcNCiAgICBDUkVB VEUgRVhURU5TSU9ODQogICAgLS0gdGhpcyB3aWxsIG5vdCBmYWlsIG9yIGNyYXNoOg0KICAgIHNl bGVjdCAqIGZyb20gY3Jvc3N0YWIgKCd2YWx1ZXMgKDEsIDIsIDEyKSwgKDEsIDMsIDEzKSwgKDIs IDIsIDIyKSwgKDIsCjMsIDIzKSwgKDMsIDIsIDMyKSwgKDMsIDMsIDMzKSBvcmRlciBieSAxLCAy LCAzJywgJ3ZhbHVlcyAoMiksICgzKScpIGFzIHJyCihhIGludCwgIjIiIGludCwgIjMiIGludCk7 DQogICAgIGEgfCAyICB8IDMgIA0KICAgIC0tLSstLS0tKy0tLS0NCiAgICAgMSB8IDEyIHwgMTMN CiAgICAgMiB8IDIyIHwgMjMNCiAgICAgMyB8IDMyIHwgMzMNCiAgICAoMyByb3dzKQ0KICAgIOKA iw0KICAgIC0tIHRoaXMgd2lsbCBjcmFzaCBwZzEyLCBidXQgbm90IHZlcnNpb24oKSA8IDEyIC0g bm90ZSBOVUxMIHZhbHVlIGluCmNhdGVnb3JpZXMgcXVlcnk6DQogICAgc2VsZWN0ICogZnJvbSBj cm9zc3RhYiAoJ3ZhbHVlcyAoMSwgMiwgMTIpLCAoMSwgMywgMTMpLCAoMiwgMiwgMjIpLCAoMiwK MywgMjMpLCAoMywgMiwgMzIpLCAoMywgMywgMzMpIG9yZGVyIGJ5IDEsIDIsIDMnLCAndmFsdWVz ICgyKSwgKG51bGwpJykgYXMKcnIgKGEgaW50LCAiMiIgaW50LCAiMyIgaW50KTsNCiAgICBzZXJ2 ZXIgY2xvc2VkIHRoZSBjb25uZWN0aW9uIHVuZXhwZWN0ZWRseQ0KICAgICAgICAgICAgVGhpcyBw cm9iYWJseSBtZWFucyB0aGUgc2VydmVyIHRlcm1pbmF0ZWQgYWJub3JtYWxseQ0KICAgICAgICAg ICAgYmVmb3JlIG9yIHdoaWxlIHByb2Nlc3NpbmcgdGhlIHJlcXVlc3QuDQogICAgY29ubmVjdGlv biB0byBzZXJ2ZXIgd2FzIGxvc3QNCg0KQmFja3RyYWNlOg0KDQoNCiAgICBBdHRhY2hpbmcgdG8g cHJvY2VzcyA2NDE2MA0KICAgIFJlYWRpbmcgc3ltYm9scyBmcm9tIC91c3IvbG9jYWwvcGdzcWwx MjEvYmluL3Bvc3RncmVzLi4uDQogICAgUmVhZGluZyBzeW1ib2xzIGZyb20gL3Vzci9sb2NhbC9s aWIvbGlieG1sMi5zby4yLi4uDQogICAgKE5vIGRlYnVnZ2luZyBzeW1ib2xzIGZvdW5kIGluIC91 c3IvbG9jYWwvbGliL2xpYnhtbDIuc28uMikNCiAgICBSZWFkaW5nIHN5bWJvbHMgZnJvbSAvdXNy L2xpYi9saWJzc2wuc28uMTExLi4uDQogICAgUmVhZGluZyBzeW1ib2xzIGZyb20gL3Vzci9saWIv ZGVidWcvL3Vzci9saWIvbGlic3NsLnNvLjExMS5kZWJ1Zy4uLg0KICAgIFJlYWRpbmcgc3ltYm9s cyBmcm9tIC9saWIvbGliY3J5cHRvLnNvLjExMS4uLg0KICAgIFJlYWRpbmcgc3ltYm9scyBmcm9t IC91c3IvbGliL2RlYnVnLy9saWIvbGliY3J5cHRvLnNvLjExMS5kZWJ1Zy4uLg0KICAgIFJlYWRp bmcgc3ltYm9scyBmcm9tIC9saWIvbGlibS5zby41Li4uDQogICAgUmVhZGluZyBzeW1ib2xzIGZy b20gL3Vzci9saWIvZGVidWcvL2xpYi9saWJtLnNvLjUuZGVidWcuLi4NCiAgICBSZWFkaW5nIHN5 bWJvbHMgZnJvbSAvbGliL2xpYmMuc28uNy4uLg0KICAgIFJlYWRpbmcgc3ltYm9scyBmcm9tIC91 c3IvbGliL2RlYnVnLy9saWIvbGliYy5zby43LmRlYnVnLi4uDQogICAgUmVhZGluZyBzeW1ib2xz IGZyb20gL2xpYi9saWJ6LnNvLjYuLi4NCiAgICBSZWFkaW5nIHN5bWJvbHMgZnJvbSAvdXNyL2xp Yi9kZWJ1Zy8vbGliL2xpYnouc28uNi5kZWJ1Zy4uLg0KICAgIFJlYWRpbmcgc3ltYm9scyBmcm9t IC91c3IvbGliL2xpYmx6bWEuc28uNS4uLg0KICAgIFJlYWRpbmcgc3ltYm9scyBmcm9tIC91c3Iv bGliL2RlYnVnLy91c3IvbGliL2xpYmx6bWEuc28uNS5kZWJ1Zy4uLg0KICAgIFJlYWRpbmcgc3lt Ym9scyBmcm9tIC9saWIvbGlidGhyLnNvLjMuLi4NCiAgICBSZWFkaW5nIHN5bWJvbHMgZnJvbSAv dXNyL2xpYi9kZWJ1Zy8vbGliL2xpYnRoci5zby4zLmRlYnVnLi4uDQogICAgUmVhZGluZyBzeW1i b2xzIGZyb20gL3Vzci9sb2NhbC9wZ3NxbDEyMS9saWIvcGdfc3RhdF9zdGF0ZW1lbnRzLnNvLi4u DQogICAgUmVhZGluZyBzeW1ib2xzIGZyb20gL2xpYmV4ZWMvbGQtZWxmLnNvLjEuLi4NCiAgICBS ZWFkaW5nIHN5bWJvbHMgZnJvbSAvdXNyL2xpYi9kZWJ1Zy8vbGliZXhlYy9sZC1lbGYuc28uMS5k ZWJ1Zy4uLg0KICAgIFtTd2l0Y2hpbmcgdG8gTFdQIDEwMzE1MSBvZiBwcm9jZXNzIDY0MTYwXQ0K ICAgIF9wb2xsICgpIGF0IF9wb2xsLlM6Mw0KICAgIDMgICAgICAgX3BvbGwuUzogTm8gc3VjaCBm aWxlIG9yIGRpcmVjdG9yeS4NCiAgICAoZ2RiKSBzZXQgcGFnaW5hdGlvbiBvZmYNCiAgICAoZ2Ri KSBzZXQgbG9nZ2luZyBmaWxlIGNyb3NzdGFiLnR4dA0KICAgIChnZGIpIHNldCBsb2dnaW5nIG9u IA0KICAgIENvcHlpbmcgb3V0cHV0IHRvIGNyb3NzdGFiLnR4dC4NCiAgICAoZ2RiKSBjb250DQog ICAgQ29udGludWluZy4NCiAgICDigIsNCiAgICBQcm9ncmFtIHJlY2VpdmVkIHNpZ25hbCBTSUdT RUdWLCBTZWdtZW50YXRpb24gZmF1bHQuDQogICAgc3RybGVuIChzdHI9MHgwKSBhdCAvdXNyL3Ny Yy9saWIvbGliYy9zdHJpbmcvc3RybGVuLmM6MTAxDQogICAgd2FybmluZzogU291cmNlIGZpbGUg aXMgbW9yZSByZWNlbnQgdGhhbiBleGVjdXRhYmxlLg0KICAgIDEwMSAgICAgICAgICAgICB2YSA9 ICgqbHAgLSBtYXNrMDEpOw0KICAgIChnZGIpIGJ0DQogICAgIzAgIHN0cmxlbiAoc3RyPTB4MCkg YXQgL3Vzci9zcmMvbGliL2xpYmMvc3RyaW5nL3N0cmxlbi5jOjEwMQ0KICAgICMxICAweDAwMDAw MDAwMDA5MzJmMmMgaW4gZG9wciAodGFyZ2V0PTB4N2ZmZmZmZmZkNWEwLApmb3JtYXQ9MHg5MTE1 OTc1ZmMgIiVzIiwgYXJncz0weDdmZmZmZmZmZDU4MCkgYXQgc25wcmludGYuYzo0NDMNCiAgICAj MiAgMHgwMDAwMDAwMDAwOTM1NWYxIGluIHBnX3ZzbnByaW50ZiAoc3RyPTxvcHRpbWl6ZWQgb3V0 PiwKY291bnQ9PG9wdGltaXplZCBvdXQ+LCBmbXQ9MHg5MTE1OTc1ZmMgIiVzIiwgYXJncz0weDMw MDAwMDAwMjApIGF0CnNucHJpbnRmLmM6MTk1DQogICAgIzMgIHBnX3NucHJpbnRmIChzdHI9PG9w dGltaXplZCBvdXQ+LCBjb3VudD08b3B0aW1pemVkIG91dD4sCmZtdD0weDkxMTU5NzVmYyAiJXMi KSBhdCBzbnByaW50Zi5jOjIwOA0KICAgICM0ICAweDAwMDAwMDA5MTE1OThiY2EgaW4gbG9hZF9j YXRlZ29yaWVzX2hhc2ggKGNhdHNfc3FsPTxvcHRpbWl6ZWQKb3V0PiwgcGVyX3F1ZXJ5X2N0eD08 b3B0aW1pemVkIG91dD4pIGF0IHRhYmxlZnVuYy5jOjc3NA0KICAgICM1ICBjcm9zc3RhYl9oYXNo IChmY2luZm89PG9wdGltaXplZCBvdXQ+KSBhdCB0YWJsZWZ1bmMuYzo2NzcNCiAgICAjNiAgMHgw MDAwMDAwMDAwNjYwM2Q3IGluIEV4ZWNNYWtlVGFibGVGdW5jdGlvblJlc3VsdAooc2V0ZXhwcj08 b3B0aW1pemVkIG91dD4sIGVjb250ZXh0PTB4OTExNTFlNDYwLCBhcmdDb250ZXh0PTxvcHRpbWl6 ZWQgb3V0PiwKZXhwZWN0ZWREZXNjPTB4OTExNTFmMDIwLCByYW5kb21BY2Nlc3M9PG9wdGltaXpl ZCBvdXQ+KSBhdCBleGVjU1JGLmM6MjMzDQogICAgIzcgIDB4MDAwMDAwMDAwMDY2Zjc5NSBpbiBG dW5jdGlvbk5leHQgKG5vZGU9MHg5MTE1MWUzNTApIGF0Cm5vZGVGdW5jdGlvbnNjYW4uYzo5NQ0K ICAgICM4ICAweDAwMDAwMDAwMDA2NTgzNGQgaW4gRXhlY1Byb2NOb2RlIChub2RlPTxvcHRpbWl6 ZWQgb3V0PikgYXQKLi4vLi4vLi4vc3JjL2luY2x1ZGUvZXhlY3V0b3IvZXhlY3V0b3IuaDoyMzkN CiAgICAjOSAgRXhlY3V0ZVBsYW4gKGVzdGF0ZT08b3B0aW1pemVkIG91dD4sIHBsYW5zdGF0ZT0w eDkxMTUxZTM1MCwKb3BlcmF0aW9uPTxvcHRpbWl6ZWQgb3V0PiwgbnVtYmVyVHVwbGVzPTxvcHRp bWl6ZWQgb3V0PiwKZGlyZWN0aW9uPTxvcHRpbWl6ZWQgb3V0PiwgZGVzdD0weDkxMTU5MWFlOCwg dXNlX3BhcmFsbGVsX21vZGU9PG9wdGltaXplZApvdXQ+LCBzZW5kVHVwbGVzPTxvcHRpbWl6ZWQg b3V0PiwgZXhlY3V0ZV9vbmNlPTxvcHRpbWl6ZWQgb3V0PikgYXQKZXhlY01haW4uYzoxNjQ2DQog ICAgIzEwIHN0YW5kYXJkX0V4ZWN1dG9yUnVuIChxdWVyeURlc2M9MHg4MDFhYTE5MTAsIGRpcmVj dGlvbj08b3B0aW1pemVkCm91dD4sIGNvdW50PTAsIGV4ZWN1dGVfb25jZT08b3B0aW1pemVkIG91 dD4pIGF0IGV4ZWNNYWluLmM6MzY0DQogICAgIzExIDB4MDAwMDAwMDgwMWFlYTllMCBpbiBwZ3Nz X0V4ZWN1dG9yUnVuIChxdWVyeURlc2M9MHg4MDFhYTE5MTAsCmRpcmVjdGlvbj1Gb3J3YXJkU2Nh bkRpcmVjdGlvbiwgY291bnQ9MCwgZXhlY3V0ZV9vbmNlPTxvcHRpbWl6ZWQgb3V0PikgYXQKcGdf c3RhdF9zdGF0ZW1lbnRzLmM6ODkzDQogICAgIzEyIDB4MDAwMDAwMDAwMDdiZjhmOCBpbiBQb3J0 YWxSdW5TZWxlY3QgKHBvcnRhbD0weDkxMTQ0MTExMCwKZm9yd2FyZD08b3B0aW1pemVkIG91dD4s IGNvdW50PTAsIGRlc3Q9PG9wdGltaXplZCBvdXQ+KSBhdCBwcXVlcnkuYzo5MjkNCiAgICAjMTMg MHgwMDAwMDAwMDAwN2JmNTJkIGluIFBvcnRhbFJ1biAocG9ydGFsPTB4OTExNDQxMTEwLApjb3Vu dD05MjIzMzcyMDM2ODU0Nzc1ODA3LCBpc1RvcExldmVsPTxvcHRpbWl6ZWQgb3V0PiwgcnVuX29u Y2U9PG9wdGltaXplZApvdXQ+LCBkZXN0PTB4OTExNTkxYWU4LCBhbHRkZXN0PTB4OTExNTkxYWU4 LCBjb21wbGV0aW9uVGFnPTB4N2ZmZmZmZmZkYjMwCiIiKSBhdCBwcXVlcnkuYzo3NzANCiAgICAj MTQgMHgwMDAwMDAwMDAwN2JlNjA3IGluIGV4ZWNfc2ltcGxlX3F1ZXJ5IChxdWVyeV9zdHJpbmc9 MHg4MDEzZGMxMTAKInNlbGVjdCAqIGZyb20gY3Jvc3N0YWIgKCd2YWx1ZXMgKDEsIDIsIDEyKSwg KDEsIDMsIDEzKSwgKDIsIDIsIDIyKSwgKDIsIDMsCjIzKSwgKDMsIDIsIDMyKSwgKDMsIDMsIDMz KSBvcmRlciBieSAxLCAyLCAzJywgJ3ZhbHVlcyAoMiksIChudWxsKScpIGFzIHJyCihhIGludCwg XCIyXCIgaW50LCBcIjNcIiBpbnQpOyIpIGF0IHBvc3RncmVzLmM6MTIxNQ0KICAgICMxNSAweDAw MDAwMDAwMDA3YmMyZmEgaW4gUG9zdGdyZXNNYWluIChhcmdjPTxvcHRpbWl6ZWQgb3V0PiwKYXJn dj08b3B0aW1pemVkIG91dD4sIGRibmFtZT08b3B0aW1pemVkIG91dD4sIHVzZXJuYW1lPTxvcHRp bWl6ZWQgb3V0PikgYXQKcG9zdGdyZXMuYzo0MjMyDQogICAgIzE2IDB4MDAwMDAwMDAwMDczODFh MiBpbiBCYWNrZW5kUnVuIChwb3J0PTB4OTExNDBjMDAwKSBhdApwb3N0bWFzdGVyLmM6NDQzNw0K ICAgICMxNyAweDAwMDAwMDAwMDA3Mzc4YmEgaW4gQmFja2VuZFN0YXJ0dXAgKHBvcnQ9MHg5MTE0 MGMwMDApIGF0CnBvc3RtYXN0ZXIuYzo0MTI4DQogICAgIzE4IFNlcnZlckxvb3AgKCkgYXQgcG9z dG1hc3Rlci5jOjE3MDQNCiAgICAjMTkgMHgwMDAwMDAwMDAwNzM0YjQyIGluIFBvc3RtYXN0ZXJN YWluIChhcmdjPTMsIGFyZ3Y9MHg3ZmZmZmZmZmU4YjApCmF0IHBvc3RtYXN0ZXIuYzoxMzc3DQog ICAgIzIwIDB4MDAwMDAwMDAwMDZhNTdlZSBpbiBtYWluIChhcmdjPTMsIGFyZ3Y9MHg3ZmZmZmZm ZmU4YjApIGF0Cm1haW4uYzoyMjgNCiAgICAoZ2RiKQoK --===============0760405588726134080==--