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 1pw6Gz-0008HP-Fc for pgsql-bugs@arkaria.postgresql.org; Mon, 08 May 2023 19:11:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pw6Fz-0004ub-Cx for pgsql-bugs@arkaria.postgresql.org; Mon, 08 May 2023 19:10:47 +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 1pw1uO-0004s7-Id for pgsql-bugs@lists.postgresql.org; Mon, 08 May 2023 14:32:12 +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 1pw1uH-001NZc-6f for pgsql-bugs@lists.postgresql.org; Mon, 08 May 2023 14:32:12 +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=mWLfWLThuh2y5zQ5gilm+1Nb5ynjrqTBMasm+bF8Nt8=; b=NOjS88tX6C4Ep37tE8TFcbi9KP aEynlD/ezUlnnJM0kh82FnFFhtm+DSCRgTP2HlPAEbb/qeOjfjyC00qqh44quJvDWgpY0AZ9h2LIL wPOrCpKGpV6BYNYoH7pts4LUyG5Q+VDU31CmEcyKK2YkZm95BST2A2lixR4K76lT/gxsvO+bSa+cI 5jhHjjkTIywc+FbJg0hmPnKUDAHc4OT1rnwS1/xOUIOcagrnVZVR78c4yz8LreW3dWOi+yPxOH3oN D9hGymcmRI6LsR40UrYx0j7CUJb8VOYILiJyzVkVU13Ir05K4xYQKLWYQqgVY4CDTVs9gs65Swuof PGdCPzSQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pw1uF-0007WS-Qg for pgsql-bugs@lists.postgresql.org; Mon, 08 May 2023 14:32: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 1pw1uE-003zWq-5I for pgsql-bugs@lists.postgresql.org; Mon, 08 May 2023 14:32:02 +0000 Content-Type: multipart/mixed; boundary="===============4909227032918851547==" MIME-Version: 1.0 Subject: BUG #17925: Incorrect select query result To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: joakim@cogmed.com Reply-To: joakim@cogmed.com, pgsql-bugs@lists.postgresql.org Date: Mon, 08 May 2023 14:31:39 +0000 Message-ID: <17925-11423596f9c67cb8@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 --===============4909227032918851547== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzkyNQpMb2dnZWQgYnk6ICAgICAgICAgIEpvYWtpbSBHb2xka3VobApF bWFpbCBhZGRyZXNzOiAgICAgIGpvYWtpbUBjb2dtZWQuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTMuMTAKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKSGVs bG8sIHRoaXMgcXVlcnkgcmV0dXJucyBkaWZmZXJlbnQgcmVzdWx0IGRlcGVuZGluZyBvbiBjaG9z ZW4gZXhlY3V0aW9uCnBsYW4uDQoNClRoZSBxdWVyeSBydW4gaW4gb3VyIGRhdGFiYXNlIGlzIA0K DQogIHdpdGggYWVfdHJhaW5pbmdzIGFzICgNCiAgICBzZWxlY3QgKiBmcm9tIHRyYWluaW5ncy5h Y3Rpdml0eV9ldmVudHMNCiAgICB3aGVyZSB0cmFpbmluZ19pZCBpbiAoNzA5LCA4OTEpKQ0KICBz ZWxlY3QgdGIudHJhaW5pbmdfaWQsIHRiLmJsb2NrLCBjb3VudChhZS50cmlhbF90aW1lX3N0aW11 bGlfc3RhcnQgaXMgbm90Cm51bGwpIHN1c3BpY2lvbnNfY29sdW1uX3Jlc3VsdA0KICBmcm9tIHRy YWluaW5ncy50cmFpbmluZ19ibG9ja3MgdGINCiAgbGVmdCBqb2luIGFlX3RyYWluaW5ncyBhZQ0K ICAgIG9uIGFlLnRyYWluaW5nX2lkID0gdGIudHJhaW5pbmdfaWQNCiAgICAgIGFuZCBhZS5ibG9j ayA9IHRiLmJsb2NrDQogICAgICBhbmQgYWUuYWN0aXZpdHkgPSB0Yi5hY3Rpdml0eQ0KICAgICAg YW5kIGFlLmV2ZW50ID0gJ3RyaWFsJw0KICB3aGVyZSB0Yi50cmFpbmluZ19pZCBpbiAoNzA5LCA4 OTEpDQogICAgLS0gcXVlcnkgcmV0dXJucyBleHBlY3RlZCByZXN1bHQgd2l0aCB0Yi5ibG9jayA8 IDIyIA0KICAgIC0tIGJ1dCB3aXRoIHRiLmJsb2NrIDwgMjMgYWUudHJpYWxfdGltZV9zdGltdWxp X3N0YXJ0IGlzIGluY29ycmVjdGx5Cm51bGwNCiAgICBhbmQgdGIuYmxvY2sgPCAyMg0KICBncm91 cCBieSB0Yi50cmFpbmluZ19pZCwgdGIuYmxvY2sNCiAgb3JkZXIgYnkgdGIudHJhaW5pbmdfaWQs IHRiLmJsb2NrIGRlc2MNCiAgbGltaXQgMTANCg0KZXZlcnl0aGluZyBpcyBmaW5lIHdoZW4gdGIu YmxvY2sgPCAyMiBhbmQgdGhlIHJlc3VsdCBpczoNCg0KNzA5CTIxCTY4DQo3MDkJMjAJNzENCjcw OQkxOQk2OA0KNzA5CTE4CTc2DQo3MDkJMTcJNzMNCjcwOQkxNgk2OQ0KNzA5CTE1CTcwDQo3MDkJ MTQJNjgNCjcwOQkxMwk3MQ0KNzA5CTEyCTY5DQoNCkhvd2V2ZXIsIHdoZW4gcnVuIHdpdGggdGIu YmxvY2sgPCAyMywgaS5lLA0KDQogIHdpdGggYWVfdHJhaW5pbmdzIGFzICgNCiAgICBzZWxlY3Qg KiBmcm9tIHRyYWluaW5ncy5hY3Rpdml0eV9ldmVudHMNCiAgICB3aGVyZSB0cmFpbmluZ19pZCBp biAoNzA5LCA4OTEpKQ0KICBzZWxlY3QgdGIudHJhaW5pbmdfaWQsIHRiLmJsb2NrLCBjb3VudChh ZS50cmlhbF90aW1lX3N0aW11bGlfc3RhcnQgaXMgbm90Cm51bGwpIHN1c3BpY2lvbnNfY29sdW1u X3Jlc3VsdA0KICBmcm9tIHRyYWluaW5ncy50cmFpbmluZ19ibG9ja3MgdGINCiAgbGVmdCBqb2lu IGFlX3RyYWluaW5ncyBhZQ0KICAgIG9uIGFlLnRyYWluaW5nX2lkID0gdGIudHJhaW5pbmdfaWQN CiAgICAgIGFuZCBhZS5ibG9jayA9IHRiLmJsb2NrDQogICAgICBhbmQgYWUuYWN0aXZpdHkgPSB0 Yi5hY3Rpdml0eQ0KICAgICAgYW5kIGFlLmV2ZW50ID0gJ3RyaWFsJw0KICB3aGVyZSB0Yi50cmFp bmluZ19pZCBpbiAoNzA5LCA4OTEpDQogICAgLS0gcXVlcnkgcmV0dXJucyBleHBlY3RlZCByZXN1 bHQgd2l0aCB0Yi5ibG9jayA8IDIyIA0KICAgIC0tIGJ1dCB3aXRoIHRiLmJsb2NrIDwgMjMgYWUu dHJpYWxfdGltZV9zdGltdWxpX3N0YXJ0IGlzIGluY29ycmVjdGx5Cm51bGwNCiAgICBhbmQgdGIu YmxvY2sgPCAyMg0KICBncm91cCBieSB0Yi50cmFpbmluZ19pZCwgdGIuYmxvY2sNCiAgb3JkZXIg YnkgdGIudHJhaW5pbmdfaWQsIHRiLmJsb2NrIGRlc2MNCiAgbGltaXQgMTANCg0KdGhlIHJlc3Vs dCBjaGFuZ2VzIHRvOg0KDQo3MDkJMjIJNQ0KNzA5CTIxCTUNCjcwOQkyMAk1DQo3MDkJMTkJNQ0K NzA5CTE4CTUNCjcwOQkxNwk1DQo3MDkJMTYJNQ0KNzA5CTE1CTUNCjcwOQkxNAk1DQo3MDkJMTMJ NQ0KDQpJIHJ1biBleHBsYWluIGFuYWx5emUgb24gdGhlIHR3byBxdWVyaWVzLCBmaXJzdCBxdWVy eSBwbGFuIGlzDQoNCkxpbWl0ICAoY29zdD0xNi40NS4uMTcxLjM1IHJvd3M9MTAgd2lkdGg9MTQp IChhY3R1YWwgdGltZT0zNS41MTcuLjM1LjYxNgpyb3dzPTEwIGxvb3BzPTEpDQogIC0+ICBHcm91 cEFnZ3JlZ2F0ZSAgKGNvc3Q9MTYuNDUuLjMyMjIuNzIgcm93cz0yMDcgd2lkdGg9MTQpIChhY3R1 YWwKdGltZT0zNS41MTYuLjM1LjYxNCByb3dzPTEwIGxvb3BzPTEpDQogICAgICAgIEdyb3VwIEtl eTogdGIudHJhaW5pbmdfaWQsIHRiLmJsb2NrDQogICAgICAgIC0+ICBJbmNyZW1lbnRhbCBTb3J0 ICAoY29zdD0xNi40NS4uMzIxOS4xMCByb3dzPTIwNyB3aWR0aD0xNCkKKGFjdHVhbCB0aW1lPTM1 LjQ5Ny4uMzUuNTM0IHJvd3M9NzA0IGxvb3BzPTEpDQogICAgICAgICAgICAgIFNvcnQgS2V5OiB0 Yi50cmFpbmluZ19pZCwgdGIuYmxvY2sgREVTQw0KICAgICAgICAgICAgICBQcmVzb3J0ZWQgS2V5 OiB0Yi50cmFpbmluZ19pZA0KICAgICAgICAgICAgICBGdWxsLXNvcnQgR3JvdXBzOiAxICBTb3J0 IE1ldGhvZDogcXVpY2tzb3J0ICBBdmVyYWdlIE1lbW9yeToKMjhrQiAgUGVhayBNZW1vcnk6IDI4 a0INCiAgICAgICAgICAgICAgUHJlLXNvcnRlZCBHcm91cHM6IDEgIFNvcnQgTWV0aG9kOiBxdWlj a3NvcnQgIEF2ZXJhZ2UgTWVtb3J5OgoxMjJrQiAgUGVhayBNZW1vcnk6IDEyMmtCDQogICAgICAg ICAgICAgIC0+ICBOZXN0ZWQgTG9vcCBMZWZ0IEpvaW4gIChjb3N0PTAuODcuLjMyMDkuODIgcm93 cz0yMDcKd2lkdGg9MTQpIChhY3R1YWwgdGltZT0wLjA0MC4uMzUuMjE3IHJvd3M9MTU3NCBsb29w cz0xKQ0KICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggT25seSBTY2FuIHVzaW5nIHBrX3Ry YWluaW5nX2Jsb2NrcyBvbgp0cmFpbmluZ19ibG9ja3MgdGIgIChjb3N0PTAuNDMuLjU0Ni44NiBy b3dzPTIwNyB3aWR0aD0xMCkgKGFjdHVhbAp0aW1lPTAuMDEwLi4wLjEwMCByb3dzPTEwNiBsb29w cz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoKHRyYWluaW5nX2lk ID0gQU5ZCignezcwOSw4OTF9Jzo6aW50ZWdlcltdKSkgQU5EIChibG9jayA8IDIyKSkNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgSGVhcCBGZXRjaGVzOiAxMDYNCiAgICAgICAgICAgICAgICAg ICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaV9hY3Rpdml0eV9ldmVudHNfdHJhaW5pbmdfaWQgb24K YWN0aXZpdHlfZXZlbnRzICAoY29zdD0wLjQ0Li4xMi44NSByb3dzPTEgd2lkdGg9MTgpIChhY3R1 YWwKdGltZT0wLjExOS4uMC4zMjggcm93cz0xNSBsb29wcz0xMDYpDQogICAgICAgICAgICAgICAg ICAgICAgICAgIEluZGV4IENvbmQ6ICgodHJhaW5pbmdfaWQgPSB0Yi50cmFpbmluZ19pZCkgQU5E Cih0cmFpbmluZ19pZCA9IEFOWSAoJ3s3MDksODkxfSc6OmludGVnZXJbXSkpKQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICBGaWx0ZXI6ICgoZXZlbnQgPSAndHJpYWwnOjp0cmFpbmluZ3MuZXZl bnQpIEFORAooYmxvY2sgPSB0Yi5ibG9jaykgQU5EIChhY3Rpdml0eSA9IHRiLmFjdGl2aXR5KSkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMjE2NQ0K UGxhbm5pbmcgVGltZTogMC4zMjkgbXMNCkV4ZWN1dGlvbiBUaW1lOiAzNS42NTMgbXMNCg0Kd2hp bGUgdGhlIHNlY29uZCAod2hpY2ggZ2l2ZXMgaW5jb3JyZWN0IHJlc3VsdCkgaXMNCg0KTGltaXQg IChjb3N0PTE1LjkxLi4xNjUuNDUgcm93cz0xMCB3aWR0aD0xNCkgKGFjdHVhbCB0aW1lPTI4Ljkx Ni4uMjguOTI4CnJvd3M9MTAgbG9vcHM9MSkNCiAgLT4gIEdyb3VwQWdncmVnYXRlICAoY29zdD0x NS45MS4uMzI2MC45OCByb3dzPTIxNyB3aWR0aD0xNCkgKGFjdHVhbAp0aW1lPTI4LjkxNC4uMjgu OTI1IHJvd3M9MTAgbG9vcHM9MSkNCiAgICAgICAgR3JvdXAgS2V5OiB0Yi50cmFpbmluZ19pZCwg dGIuYmxvY2sNCiAgICAgICAgLT4gIEluY3JlbWVudGFsIFNvcnQgIChjb3N0PTE1LjkxLi4zMjU3 LjE4IHJvd3M9MjE3IHdpZHRoPTE0KQooYWN0dWFsIHRpbWU9MjguOTA1Li4yOC45MDkgcm93cz01 MSBsb29wcz0xKQ0KICAgICAgICAgICAgICBTb3J0IEtleTogdGIudHJhaW5pbmdfaWQsIHRiLmJs b2NrIERFU0MNCiAgICAgICAgICAgICAgUHJlc29ydGVkIEtleTogdGIudHJhaW5pbmdfaWQNCiAg ICAgICAgICAgICAgRnVsbC1zb3J0IEdyb3VwczogMSAgU29ydCBNZXRob2Q6IHF1aWNrc29ydCAg QXZlcmFnZSBNZW1vcnk6CjI4a0IgIFBlYWsgTWVtb3J5OiAyOGtCDQogICAgICAgICAgICAgIFBy ZS1zb3J0ZWQgR3JvdXBzOiAxICBTb3J0IE1ldGhvZDogcXVpY2tzb3J0ICBBdmVyYWdlIE1lbW9y eToKNTlrQiAgUGVhayBNZW1vcnk6IDU5a0INCiAgICAgICAgICAgICAgLT4gIE1lcmdlIExlZnQg Sm9pbiAgKGNvc3Q9MC44Ny4uMzI0Ny40NSByb3dzPTIxNyB3aWR0aD0xNCkKKGFjdHVhbCB0aW1l PTAuMDQ3Li4yOC43NjIgcm93cz03MjcgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgTWVy Z2UgQ29uZDogKHRiLnRyYWluaW5nX2lkID0KYWN0aXZpdHlfZXZlbnRzLnRyYWluaW5nX2lkKQ0K ICAgICAgICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKChhY3Rpdml0eV9ldmVudHMuYmxvY2sg PSB0Yi5ibG9jaykgQU5ECihhY3Rpdml0eV9ldmVudHMuYWN0aXZpdHkgPSB0Yi5hY3Rpdml0eSkp DQogICAgICAgICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBKb2luIEZpbHRlcjogNzM0ODEN CiAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IE9ubHkgU2NhbiB1c2luZyBwa190cmFpbmlu Z19ibG9ja3Mgb24KdHJhaW5pbmdfYmxvY2tzIHRiICAoY29zdD0wLjQzLi41NzIuNzMgcm93cz0y MTcgd2lkdGg9MTApIChhY3R1YWwKdGltZT0wLjAxMC4uMC4xMTggcm93cz0xMTEgbG9vcHM9MSkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKCh0cmFpbmluZ19pZCA9IEFO WQooJ3s3MDksODkxfSc6OmludGVnZXJbXSkpIEFORCAoYmxvY2sgPCAyMykpDQogICAgICAgICAg ICAgICAgICAgICAgICAgIEhlYXAgRmV0Y2hlczogMTExDQogICAgICAgICAgICAgICAgICAgIC0+ ICBJbmRleCBTY2FuIHVzaW5nIGlfYWN0aXZpdHlfZXZlbnRzX3RyYWluaW5nX2lkIG9uCmFjdGl2 aXR5X2V2ZW50cyAgKGNvc3Q9MC40NC4uMjY2NC43NSByb3dzPTM1ODQgd2lkdGg9MTgpIChhY3R1 YWwKdGltZT0wLjAwOS4uMTguMjkwIHJvd3M9NzQwMzIgbG9vcHM9MSkNCiAgICAgICAgICAgICAg ICAgICAgICAgICAgSW5kZXggQ29uZDogKHRyYWluaW5nX2lkID0gQU5ZCignezcwOSw4OTF9Jzo6 aW50ZWdlcltdKSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoZXZlbnQgPSAn dHJpYWwnOjp0cmFpbmluZ3MuZXZlbnQpDQpQbGFubmluZyBUaW1lOiAwLjU3MCBtcw0KRXhlY3V0 aW9uIFRpbWU6IDI4Ljk3NCBtcw0KDQpJJ20gbm8gcG9zdGdyZXNxbCBleHBlcnQgYW5kIEkgZG9u J3QgdGhpbmsgSSB1bmRlcnN0YW5kIHRoZSBxdWVyeSBwbGFubmVyLApidXQgdG8gbWUgdGhlIGl0 IHNlZW1zIGxpa2UgYSBidWcuIEknbSBzb3JyeSB0aGF0IEkgY291bGRuJ3QgY29tZSB1cCB3aXRo IGEKbW9yZSBtaW5pbWFsIHF1ZXJ5IGV4YW1wbGUgYnV0IGlmIEkgbWFrZSBzbWFsbCB0d2Vha3Mg dG8gdGhlIHF1ZXJ5IGl0IHN0YXJ0cwp0byBwcm9kdWNlIGV4cGVjdGVkIHJlc3VsdHMgYWdhaW4u DQoNClRoYW5rcyBmb3IgYXdlc29tZSBzb2Z0d2FyZSBhbnl3YXkhDQoNCi9Kb2FraW0KCg== --===============4909227032918851547==--