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 1m1FJA-0006qu-Og for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Jul 2021 21:42:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m1FJ9-0006or-M6 for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Jul 2021 21:42:15 +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 1m1F3Z-00082E-MG for pgsql-bugs@lists.postgresql.org; Wed, 07 Jul 2021 21:26:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m1F3W-0007M5-IP for pgsql-bugs@lists.postgresql.org; Wed, 07 Jul 2021 21:26:09 +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=1d83PnKu8/cmTQ+Tk7BxDcZxakDva+hUMcqGPW8AiLU=; b=1EZ4Rsf7/X2pNsz792C9+a7Vgl hTi+RahLDU93qI8r6fY/Ej0t1VN19wjLbQxBRb+Kw8apnQGjOlcALIrpGf1CrYY20ESVsHdakBJFm XtduPb/ZuUW8yRMjJbrLn+uu8PtKzzsB+LhpldsXvKeJbxlafmPRfqgni27LCvK7cPR75MlUjgqX7 tXVuFAGCpMP9cm0vdEAoXfaI+nHVUGRPI/nnU6u5nqZVz2mHKKXEmBBAv45g6Hv1p27TBStzU+WAS dJritkDa/fUKn3kVOIjkurwcSjkiu841vZRPrDwco2Lql6mS/+ogwRrP0tmT0KnwnBodY0NJAEwIf MUUaEi3g==; 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 1m1F3V-0001GL-9Z for pgsql-bugs@lists.postgresql.org; Wed, 07 Jul 2021 21:26:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m1F3S-0007gn-30 for pgsql-bugs@lists.postgresql.org; Wed, 07 Jul 2021 21:26:02 +0000 Content-Type: multipart/mixed; boundary="===============3389702065062644901==" MIME-Version: 1.0 Subject: BUG #17092: SELECT using LIMIT clause without ORDER BY fails when parallel query is on To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: roberto72@gmail.com Reply-To: roberto72@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 07 Jul 2021 21:25:50 +0000 Message-ID: <17092-2524a756f0f764e0@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 --===============3389702065062644901== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA5MgpMb2dnZWQgYnk6ICAgICAgICAgIFJvYmVydG8gUm9zYQpFbWFp bCBhZGRyZXNzOiAgICAgIHJvYmVydG83MkBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx My4zCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIwLjA0LjIgTFRTIChLZXJuZWwgNS40LjAt NjUgeDg2XzY0KQpEZXNjcmlwdGlvbjogICAgICAgIAoKUG9zdGdyZVNRTCBpcyB2ZXJzaW9uIDEz LjMuIE9wZXJhdGluZyBzeXN0ZW0gaXMgVWJ1bnR1IDIwLjA0LjIgTFRTLiBUaGUKdGFibGUgdGVz dGVkIGhhcyAxMDM5NjggcmVjb3Jkcy4gUGFyYW1ldGVycyAibWF4X3BhcmFsbGVsX3dvcmtlcnMi IGFuZAoibWF4X3BhcmFsbGVsX3dvcmtlcnNfcGVyX2dhdGhlciIgYXJlIGRlZmF1bHQgKDggYW5k IDIsIHJlc3BlY3RpdmVseSkuIFRoZQp0YWJsZSBuYW1lIGFuZCBmaWVsZCB3ZXJlIGNoYW5nZWQg Zm9yIHByaXZhY3kgb2YgdGhlIGNvbXBhbnkgaW52b2x2ZWQuDQoNClRoZSBxdWVyeSAoMSk6DQoN ClNFTEVDVCAqDQpGUk9NIHRoZV90YWJsZQ0KV0hFUkUgaWQ9NDENCkxJTUlUIDENCg0KZmFpbHMg YW5kIHJlcG9ydHMgdGhlIGVycm9yOg0KDQpFUlJPUjogIGludmFsaWQgaW5wdXQgc3ludGF4IGZv ciB0eXBlIGludGVnZXI6ICIiDQpDT05URVhUOiAgcGFyYWxsZWwgd29ya2VyDQoNCkhvd2V2ZXIs IGlmIHdlIGFkZCB0aGUgT1JERVIgQlkgY2xhdXNlICgyKTsNCg0KU0VMRUNUICoNCkZST00gdGhl X3RhYmxlDQpXSEVSRSBpZD00MQ0KT1JERVIgQlkgMQ0KTElNSVQgMQ0KDQpUaGUgcmVzdWx0IHNo b3duIGNvbnRhaW5zIGFsbCB0aGUgY29sdW1ucywgYXMgZGVzaXJlZCBhbmQgZXhwZWN0ZWQuIEFs c28sIGlmCndlIHJlbW92ZSB0aGUgV0hFUkUgY2xhdXNlICgzKQ0KDQpTRUxFQ1QgKg0KRlJPTSB0 aGVfdGFibGUNCkxJTUlUIDENCg0KaXQgc2hvd3MgdGhlIGV4cGVjdGVkIHJlc3VsdC4NCg0KQXMg dGhpcyBpcyBhIHByb2R1Y3Rpb24gZGF0YWJhc2UgYW5kIHRoZSBhcHBsaWNhdGlvbiBpcyBidWls dCBieSBhbiBleHRlcm5hbApncm91cCBvZiBpbmRpdmlkdWFscywgd2UgYXJlIHVuYWJsZSAoYXQg dGhpcyBtb21lbnQpIHRvIGNoYW5nZSB0aGUgY29kZSwKaW5jbHVkaW5nIHRoZSBPUkRFUiBCWSBj bGF1c2UuIFNvLCB0aGUgdGVtcG9yYXJ5IHNvbHV0aW9uIHdhcyB0byBzZXQgYm90aAoibWF4X3Bh cmFsbGVsX3dvcmtlcnMiIGFuZCAibWF4X3BhcmFsbGVsX3dvcmtlcnNfcGVyX2dhdGhlciIgdG8g MCAoemVybykgaW4KdGhlIGNvbmZpZ3VyYXRpb24gZmlsZSBhbmQgcmVsb2FkIHRoZSBjb25maWd1 cmF0aW9uLiBJbiBkb2luZyB0aGF0LCB0aGUKb3JpZ2luYWwgcXVlcnkgKDEpIHN1Y2NlZWRzLCBh cyBhbGwgdGhlIG90aGVyIHR3byBxdWVyaWVzIC0gKDIpIGFuZCAoMykuDQoNCklmIHNvbWUgaW5m b3JtYXRpb24gaXMgbWlzc2luZywgcGxlYXNlIGxldCBtZSBrbm93Lg0KDQpSZWdhcmRzCgo= --===============3389702065062644901==--