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.94.2) (envelope-from ) id 1uNvfr-00C4Si-BM for pgsql-bugs@arkaria.postgresql.org; Sat, 07 Jun 2025 15:41:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uNvfp-00Dnhh-Ar for pgsql-bugs@arkaria.postgresql.org; Sat, 07 Jun 2025 15:41:33 +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.94.2) (envelope-from ) id 1uNjYR-005Nzr-3q for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 02:45:08 +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 1uNjYQ-000gBT-0U for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 02:45:06 +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=/qo1ZltXETBKJ2jTDnKEH1pN9M1enUmMPSjZznGlLGE=; b=VhyigN4MJLVcOBZkrJU0ZQIUXr OdfhuwicW+rP7NRa4IpwqVRZiQJJeW/C211eTbR1uumBWUQ8SaFy6EJu2oOJgBCBhj1IBhMBjHJI1 MbDt6xaPx/2hLIjkIwFlcbvObliS/s5Y1qKqWRinkgU2dmBRiodHFBLuAmRZqkp8GBQBZ1JAU0flU JxIIb8ORU3KbFGMJ+RcsBE21T2C8LBNYDCX+cf+Qy/EVP460C0kIZEECZlGiTZbe434mS9cOubCPq ez4Pkd9fKyTMK0xhpkgkyA/XwFktNjplXnUOhh5WoZDSDvPTb+zOCzVynUcWsUJbbreIERtERgU32 K+DJHwyw==; 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.94.2) (envelope-from ) id 1uNjYO-002Mzu-Ls for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 02:45: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 1uNjYN-0063Mh-1C for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 02:45:03 +0000 Content-Type: multipart/mixed; boundary="===============5702230520179837654==" MIME-Version: 1.0 Subject: BUG #18948: Equivalent MAX() result in view and inline query yields inconsistent row count To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dengwenking@gmail.com Reply-To: dengwenking@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 07 Jun 2025 02:44:08 +0000 Message-ID: <18948-a05bf0726c2c993a@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 --===============5702230520179837654== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk0OApMb2dnZWQgYnk6ICAgICAgICAgIFdlbmtpbmcgRGVuZwpFbWFp bCBhZGRyZXNzOiAgICAgIGRlbmd3ZW5raW5nQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE1LjAKT3BlcmF0aW5nIHN5c3RlbTogICBEb2NrZXIKRGVzY3JpcHRpb246ICAgICAgICAKClRo aXMgYnVnIGRlbW9uc3RyYXRlcyBhIGRpc2NyZXBhbmN5IGluIFBvc3RncmVTUUwgd2hlbiBjb21w YXJpbmcgdGhlIHJlc3VsdApvZiBhbiBhZ2dyZWdhdGUgZnVuY3Rpb24gdXNlZCBpbmxpbmUgdmVy c3VzIHN0b3JlZCBpbiBhIHZpZXcuIFRoZSBxdWVyaWVzClNFTEVDVCBNQVgoYzApIEZST00gdDAg YW5kIFNFTEVDVCBjMCBGUk9NIHYxIHByb2R1Y2UgZXhhY3RseSB0aGUgc2FtZSB2YWx1ZS4KSG93 ZXZlciwgd2hlbiBhcHBseWluZyBhIFdIRVJFICgxID0gTlVMTCkgY29uZGl0aW9uLCB0aGUgaW5s aW5lIHZlcnNpb24KcmV0dXJucyBvbmUgcm93ICh3aXRoIE5VTEwpLCB3aGlsZSB0aGUgdmlldyB2 ZXJzaW9uIHJldHVybnMgemVybyByb3dzLgpSZXByb2R1Y2UgU3RlcHM6Ci0tIFNldHVwOiBDcmVh dGUgdGFibGUgdDAgYW5kIHZpZXcgdjEKQ1JFQVRFIFRBQkxFIHQwIChjMCBSRUFMKTsKSU5TRVJU IElOVE8gdDAgKGMwKSBWQUxVRVMgKDEuODMwMjUwNjY4MzI0Njg0ZSszOCk7CklOU0VSVCBJTlRP IHQwIChjMCkgVkFMVUVTICgtMy4yOTU1OTYwMzI3MDAxMmUrMzgpOwpJTlNFUlQgSU5UTyB0MCAo YzApIFZBTFVFUyAoMy4zNTIxMzQ2ODkxMDI1NjJlKzM4KTsKQ1JFQVRFIFZJRVcgdjEgQVMgU0VM RUNUIE1BWChjMCkgQVMgYzAgRlJPTSB0MDsKLS0gUXVlcnkgMTogSW5saW5lIE1BWCgpIHdpdGhv dXQgV0hFUkUKZGIxPSMgU0VMRUNUIE1BWChjMCkgRlJPTSB0MDsKICAgICAgbWF4Ci0tLS0tLS0t LS0tLS0tLQogMy4zNTIxMzQ3ZSszOAooMSByb3cpCi0tIFF1ZXJ5IDI6IFZpZXcgdmFsdWUgKHNh bWUgcmVzdWx0KQpkYjE9IyBTRUxFQ1QgYzAgRlJPTSB2MTsKICAgICAgYzAKLS0tLS0tLS0tLS0t LS0tCiAzLjM1MjEzNDdlKzM4CigxIHJvdykKLS0gUXVlcnkgMzogSW5saW5lIE1BWCgpIHdpdGgg V0hFUkUgKDEgPSBOVUxMKQpkYjE9IyBTRUxFQ1QgTUFYKGMwKSBGUk9NIHQwIFdIRVJFICgxID0g TlVMTCk7CiBtYXgKLS0tLS0KKDEgcm93KQotLSBRdWVyeSA0OiBWaWV3IHZhbHVlIHdpdGggc2Ft ZSBXSEVSRSBjbGF1c2UKZGIxPSMgU0VMRUNUIChjMCkgRlJPTSB2MSBXSEVSRSAoMSA9IE5VTEwp OwogYzAKLS0tLQooMCByb3dzKQpFeHBlY3RlZCBSZXN1bHQ6CkJvdGggU0VMRUNUIHNob3VsZCBy ZXR1cm4gb25lIHJvdyB3aXRoIE5VTEwuCgo= --===============5702230520179837654==--