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 1mDro8-0003Iq-Q8 for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Aug 2021 17:14:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mDro7-0004Ms-QI for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Aug 2021 17:14:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mDrG3-00018e-4A for pgsql-bugs@lists.postgresql.org; Wed, 11 Aug 2021 16:39:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mDrFx-0007Fb-Na for pgsql-bugs@lists.postgresql.org; Wed, 11 Aug 2021 16:39:10 +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=7RK+6gUOSKYBzmemiSlCUGw+JQY5feZFjhqQg4N6rmA=; b=iHVAIglq/Jw8F7xDIDT4xKFfRG YoTYTqz2qI909ah1uAUiRFEJmUVQTwn6V6JIx3EJlb6y+J0lbWiy++A+7gTDLZwfBkGaGznSf4TZP uE0PoJeADnsC5ffqlBaN3gM4BpCHWFgi/YQOUkLtgnBW2Cj9i2yLZ7im6xdCueUiqGLEnB/EyUeCH ceT2YpBC/uid78xFaqDai6CZO/qq2YRrJZSu7Lr/CZ3t10GopP99n3TxmW8ZF339mrOOjgtPEHNr7 YnSe0+l1l3blP4e0xxumo8z8eMXZwXmLRa4uWQQdeolgYOwnK6ESDnuijqE0Ptyad8U0UdY07wASx 6VY+ktpg==; 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 1mDrFw-0005iA-BM for pgsql-bugs@lists.postgresql.org; Wed, 11 Aug 2021 16:39:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mDrFu-0000uE-MI for pgsql-bugs@lists.postgresql.org; Wed, 11 Aug 2021 16:39:02 +0000 Content-Type: multipart/mixed; boundary="===============2607805441358289589==" MIME-Version: 1.0 Subject: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: emil@iggland.com Reply-To: emil@iggland.com, pgsql-bugs@lists.postgresql.org Date: Wed, 11 Aug 2021 16:38:15 +0000 Message-ID: <17141-913d78b9675aac8e@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 --===============2607805441358289589== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzE0MQpMb2dnZWQgYnk6ICAgICAgICAgIEVtaWwgSWdnbGFuZApFbWFp bCBhZGRyZXNzOiAgICAgIGVtaWxAaWdnbGFuZC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMy4z Ck9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cwpEZXNjcmlwdGlvbjogICAgICAgIAoKSSBhbSB0 cnlpbmcgdG8gY3JlYXRlIGEgcXVldWUgd2hpY2ggc2hvdWxkIGFzc2lnbiBtdWx0aXBsZSB0YXNr cyB0byBhCndvcmtlci4gSSB1c2Ugcm93IGxvY2tpbmcgd2l0aCBGT1IgVVBEQVRFIFNLSVAgTE9D S0VELCBidXQgdGhlIG51bWJlciBvZgpyb3dzIHJldHVybmVkIGFyZSBpbmNvbnNpc3RlbnQgd2l0 aCB3aGF0IEkgZXhwZWN0LiANCg0KTWluaW11bSBleGFtcGxlOg0KIA0KQ1JFQVRFIFRBQkxFIHF1 ZXVlICh0YXNrIElOVEVHRVIpOyANCklOU0VSVCBJTlRPIHF1ZXVlICh0YXNrKQ0KVkFMVUVTICgx ODApLCgyODApLCgzODApLCg0ODApLCg1ODApLCgxODApLCgyODApLCgzODApLCg0ODApLCg1ODAp Ow0KDQpCRUdJTjsgDQpTRUxFQ1QgKiBGUk9NIHF1ZXVlDQpPUkRFUiBCWSB0YXNrIERFU0MNCkZF VENIIEZJUlNUIDEgUk9XUyBXSVRIIFRJRVMNCkZPUiBVUERBVEUgU0tJUCBMT0NLRUQ7DQovKiBT b21lIHdvcmsgdG8gYmUgZG9uZSBoZXJlICovDQpDT01NSVQ7DQoNCnNlbGVjdCB2ZXJzaW9uKCk7 DQpQb3N0Z3JlU1FMIDEzLjMsIGNvbXBpbGVkIGJ5IFZpc3VhbCBDKysgYnVpbGQgMTkxNCwgNjQt Yml0DQoNCkV4cGVjdGVkIHJlc3VsdCBXb3JrZXIgMTogKDU4MCksICg1ODApLCBBY3R1YWwgcmVz dWx0IFdvcmtlciAxOiAoNTgwKSwKKDU4MCkNCkV4cGVjdGVkIHJlc3VsdCBXb3JrZXIgMjogKDQ4 MCksICg0ODApLCBBY3R1YWwgcmVzdWx0IFdvcmtlciAyOiAoNDgwKQoK --===============2607805441358289589==--