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.96) (envelope-from ) id 1vQMwZ-006Omk-0g for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Dec 2025 09:45:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQMwY-007443-0t for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Dec 2025 09:45:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQLGv-006YDw-2H for pgsql-bugs@lists.postgresql.org; Tue, 02 Dec 2025 07:58:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQLGt-002i5Y-2J for pgsql-bugs@lists.postgresql.org; Tue, 02 Dec 2025 07:58:05 +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=m3wNPGrFx+skyXSStr82b6EHVhCUxs1JYfs2MPMuoV4=; b=Jw0m1BiFp/IyWozPp6+ZoweWKC w0qPIx3moURz+5O9ng/zrNZXb/FcbcDEShM01uPVrJ+MBbrtaRBunFrrYhbZ8R7fURmBtkdbv13CB SWOVHTwmv2IDthD3u4v9mxVLETgpG1HTg5tkv/Ftlzl0WxMcelDuEtv1bsZRb5lfsixDSjw6DBk3f bisOBNZL+DefgFDm5vxsSqRPL8rCg8rcKWv/Ojq5vKYSFffAa37MnquvKxKvz4z9wjhgF+quo+y5M ZHHzbMxogGqAnKCOpFCMRp6iiL7e9rRr6Bq5m0HwPlcy0wZ1nt8H8uc0ODlcTHzsGPLjy9VQQ/6S9 xVeSjhQw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQLGu-003uah-0d for pgsql-bugs@lists.postgresql.org; Tue, 02 Dec 2025 07:58:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQLGr-003UB0-2T for pgsql-bugs@lists.postgresql.org; Tue, 02 Dec 2025 07:58:02 +0000 Content-Type: multipart/mixed; boundary="===============2115380606373156672==" MIME-Version: 1.0 Subject: BUG #19340: Wrong result from CORR() function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: o15611@gmail.com Reply-To: o15611@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 02 Dec 2025 07:57:35 +0000 Message-ID: <19340-6fb9f6637f562092@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 --===============2115380606373156672== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM0MApMb2dnZWQgYnk6ICAgICAgICAgIE9sZWcgSXZhbm92CkVtYWls IGFkZHJlc3M6ICAgICAgbzE1NjExQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE4LjEK T3BlcmF0aW5nIHN5c3RlbTogICBhbGwKRGVzY3JpcHRpb246ICAgICAgICAKCnBvc3RncmVzPSMg U0VMRUNUIGNvcnIoIDAuMDkgLCAwLjA5MDAwMDAxICkgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwy NCkgOwogY29ycgotLS0tLS0KICAgICAKKDEgcm93KQoKcG9zdGdyZXM9IyBTRUxFQ1QgY29ycigg MC4wOSAsIDAuMDkwMDAwMDEgKSBGUk9NIGdlbmVyYXRlX3NlcmllcygxLDI1KSA7CiAgICAgICAg Y29ycgotLS0tLS0tLS0tLS0tLS0tLS0tLS0KIC0wLjE4NzcyOTQyOTczMjE5OTEKKDEgcm93KQoK cG9zdGdyZXM9IyBTRUxFQ1QgY29yciggMC4wOSAsIDAuMDkwMDAwMDEgKSBGUk9NIGdlbmVyYXRl X3NlcmllcygxLDMxKSA7CiAgICAgICAgIGNvcnIKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogLTAu MDMzNjY1MzIyODk5NjA0NjMKKDEgcm93KQoKcG9zdGdyZXM9IyBTRUxFQ1QgY29yciggMC4wOSAs IDAuMDkwMDAwMDEgKSBGUk9NIGdlbmVyYXRlX3NlcmllcygxLDMyKSA7CiAgICAgICAgIGNvcnIK LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogMC4wMzc5MzkyMzQyNzQ0NTI0NTYKKDEgcm93KQoKQW5v dGhlciBleGFtcGxlOgoKcG9zdGdyZXM9IyBTRUxFQ1QgY29yciggMC45ICwgMC45MSApIEZST00g Z2VuZXJhdGVfc2VyaWVzKDEsMzYpIDsKIGNvcnIKLS0tLS0tCiAgICAgCigxIHJvdykKCnBvc3Rn cmVzPSMgU0VMRUNUIGNvcnIoIDAuOSAsIDAuOTEgKSBGUk9NIGdlbmVyYXRlX3NlcmllcygxLDM3 KSA7CiAgICAgICAgY29ycgotLS0tLS0tLS0tLS0tLS0tLS0tLS0KIDAuMzcxNjc5NTQ3NDU5NDQ4 MDMKKDEgcm93KQoKcG9zdGdyZXM9IyBTRUxFQ1QgY29yciggMC45ICwgMC45MSApIEZST00gZ2Vu ZXJhdGVfc2VyaWVzKDEsMTEzKSA7CiAgICAgICAgIGNvcnIKLS0tLS0tLS0tLS0tLS0tLS0tLS0t LQogMC4wMjI4ODQ3ODc1NTAxNjcxNzYKKDEgcm93KQoKcG9zdGdyZXM9IyBTRUxFQ1QgY29ycigg MC45ICwgMC45MSApIEZST00gZ2VuZXJhdGVfc2VyaWVzKDEsMTE0KSA7CiAgICAgICAgIGNvcnIK LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KIC0wLjAwNDk4MTE3NTExMTMwMzM0MQooMSByb3cpCgpJ biB0aGUgT3JhY2xlIERhdGFiYXNlOgpTUUw+IHNlbGVjdCBjb3JyKCAwLjA5ICwgMC4wOTAwMDAw MSApIEZST00gKHNlbGVjdCByb3dudW0gYXMgaWQgZnJvbSBkdWFsCmNvbm5lY3QgYnkgbGV2ZWwg PD0zMzApOwoKQ09SUigwLjA5LDAuMDkwMDAwMDEpCi0tLS0tLS0tLS0tLS0tLS0tLS0tLQoKSWYg YXJndW1lbnQgaXMgdGhlIGNvbnN0YW50LCBmdW5jdGlvbiBDT1JSKCkgbXVzdCBnaXZlIGEgMCBv ciBOYU4uCkNvbnNlcXVlbmNlcyBvZiB0aGlzIGJ1Zzogc3RhdGlzdGljIGZ1bmN0aW9ucyBhcmUg dXNlZCB0byBtYWtlIGJ1c2luZXNzCmRlc2Npc2lvbi4gV3JvbmcgYW5kIGNvbXBsZXRlbHkgZGlm ZmVyZW50IHJlc3VsdHMgY2FuIGxlYWQgdG8gbWFrZSBtaXN0YWtlcy4KCg== --===============2115380606373156672==--