Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jT5pc-0005AU-83 for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Apr 2020 15:38:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jT5pb-0003fI-4y for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Apr 2020 15:38:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jT5f1-0004mw-Fi for pgsql-bugs@lists.postgresql.org; Mon, 27 Apr 2020 15:27:07 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jT5ey-0007QW-FT for pgsql-bugs@lists.postgresql.org; Mon, 27 Apr 2020 15:27:07 +0000 Content-Type: multipart/mixed; boundary="===============7076882889952312417==" MIME-Version: 1.0 Subject: BUG #16396: Parallel Union queries seem to treat NULL values differently To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: stephan@teeuwendesign.nl Reply-To: stephan@teeuwendesign.nl, pgsql-bugs@lists.postgresql.org Date: Mon, 27 Apr 2020 15:26:59 +0000 Message-ID: <16396-083a432fe7ac8fb9@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7076882889952312417== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjM5NgpMb2dnZWQgYnk6ICAgICAgICAgIFN0ZXBoYW4gVGVldXdlbgpF bWFpbCBhZGRyZXNzOiAgICAgIHN0ZXBoYW5AdGVldXdlbmRlc2lnbi5ubApQb3N0Z3JlU1FMIHZl cnNpb246IDEyLjIKT3BlcmF0aW5nIHN5c3RlbTogICBNYWMgMTAuMTUuMwpEZXNjcmlwdGlvbjog ICAgICAgIAoKV2UgcmVjZW50bHkgdXBncmFkZWQgZnJvbSBQRyA5LjUgdG8gUEcgMTIuMiBhbmQg ZW5jb3VudGVyZWQgdGhlIGZvbGxvd2luZwplcnJvciBtZXNzYWdlOiAiRVJST1I6ICBVTklPTiB0 eXBlcyBpbnRlZ2VyIGFuZCB0ZXh0IGNhbm5vdCBiZSBtYXRjaGVkIg0KDQpFdmVuIHRob3VnaCBk b2NzIHN0YXRlIHRoYXQgaWYgdGhlIGxlZnQgc2lkZSBvZiB0aGUgam9pbiBpcyBkZWZpbmVkLiB0 aGUKcmlnaHQgc2lkZSB0eXBlIHNob3VsZCBub3QgaGF2ZSBiZWVuIGRlZmluZWQ6IA0KaHR0cHM6 Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi90eXBlY29udi11bmlvbi1jYXNlLmh0bWwNCg0K VGhpcyBxdWVyeSBmaXRzIHRoZSBkb2N1bWVudGVkIG9uIGFib3ZlIHVybDoNClNFTEVDVCBDQVNU KE5VTEwgQVMgSU5URUdFUikgQVMgaGVsbG9fd29ybGQNCglVTklPTg0KU0VMRUNUIE5VTEwgQVMg aGVsbG9fd29ybGQNCg0KQnV0IGFzIGluIG91ciBxdWVyeSB0aGUgZm9sbG93aW5nIGhhcHBlbmVk Og0KU0VMRUNUIGhlbGxvX3dvcmxkDQpGUk9NIChTRUxFQ1QgQ0FTVChOVUxMIEFTIElOVEVHRVIp IEFTIGhlbGxvX3dvcmxkKSBhcyBhDQoJVU5JT04NClNFTEVDVCBoZWxsb193b3JsZA0KRlJPTSAo U0VMRUNUIE5VTEwgQVMgaGVsbG9fd29ybGQpIGFzIGINCg0KSXQgZmFpbHMgYW5kIGlzIG9ubHkg Zml4YWJsZSBieSBkZWZpbmluZyB0aGUgTlVMTCBpbiB0aGUgcmlnaHQgc2lkZSBvZiB0aGUKVU5J T04gYXMgQ0FTVChOVUxMIEFTIElOVEVHRVIpDQoNCldoaWNoIHdhc24ndCByZXF1aXJlZCBvbiBQ b3N0Z3JlcyA5LjUsIGJ1dCBpcyByZXF1aXJlZCBmb3Igc3VyZSBvbiBQb3N0Z3JlcwoxMi4yDQpJ J20gdW5zdXJlIHdoaWNoIHZlcnNpb24gaW50cm9kdWNlZCB0aGlzIGRpZmZlcmVudCwgYnV0IGl0 IHdvdWxkIGJlIGdvb2QgdG8KaGF2ZSBpdCByZXByZXNlbnRlZCBpbiB0aGUgZG9jdW1lbnRhdGlv biBtZW50aW9uZWQgYWJvdmUhDQoNCktpbmcgcmVnYXJkcywgDQpTdGVwaGFuIFRlZXV3ZW4KCg== --===============7076882889952312417==--