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 1jPm1E-0002Fy-A3 for pgsql-bugs@arkaria.postgresql.org; Sat, 18 Apr 2020 11:52:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jPm1D-0004d3-2E for pgsql-bugs@arkaria.postgresql.org; Sat, 18 Apr 2020 11:52:19 +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 1jPkLZ-0003zO-M2 for pgsql-bugs@lists.postgresql.org; Sat, 18 Apr 2020 10:05:13 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jPkLO-0003MC-Gz for pgsql-bugs@lists.postgresql.org; Sat, 18 Apr 2020 10:05:09 +0000 Content-Type: multipart/mixed; boundary="===============8029877464924054289==" MIME-Version: 1.0 Subject: BUG #16377: select stuck when use order by and limit 1 if order-by-field has one index and result has no records To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kingyzf@outlook.com Reply-To: kingyzf@outlook.com, pgsql-bugs@lists.postgresql.org Date: Sat, 18 Apr 2020 10:04:05 +0000 Message-ID: <16377-86af0a40aa096b0d@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8029877464924054289== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjM3NwpMb2dnZWQgYnk6ICAgICAgICAgIFl1bmZlbmcgV2FuZwpFbWFp bCBhZGRyZXNzOiAgICAgIGtpbmd5emZAb3V0bG9vay5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx MS42Ck9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudG9zIDcuNgpEZXNjcmlwdGlvbjogICAgICAgIAoK c2VsZWN0IHN0dWNrIHdoZW4gdXNlIG9yZGVyIGJ5IGFuZCBsaW1pdCAxIGlmIG9yZGVyLWJ5LWZp ZWxkIGhhcyBvbmUKaW5kZXg6DQphbmQgcG9zc2liaWxpdHkgaXMgaGlnaCBpZiByZXN1bHQgaGFz IG5vIHJlY29yZHMsIG90aGVyd2lzZSBwb3NzaWJpbGl0eSBpcwpsb3c7DQppZiBubyAibGltaXQg MSIgb3Igbm8gaW5kZXggb24gY29sdW1uIHBheV9kYXRlLCBubyBwcm9ibGVtOw0KDQpzcWw6DQpz ZWxlY3QgKiBmcm9tDQooc2VsZWN0ICggY2FzZSB3aGVuIHByZV9wYXkgaXMgbnVsbCB0aGVuIDAg ZWxzZSBwcmVfcGF5IGVuZCApIGFzICJQUkVfUEFZIgoNCmZyb20gaW5wYXRpZW50cHJlcGF5DQp3 aGVyZSBjYW5jZWw9JzAnDQphbmQgZWhyaWQ9NA0Kb3JkZXIgYnkgcGF5X2RhdGUgZGVzYw0KKSBh cyB0DQpsaW1pdCAxDQo7DQpvdGhlciBpbmZvOiB0aGUgIGlucGF0aWVudHByZXBheSB0YWJsZSBo YXMgbmluZSBtaWxsaW9uIHJlY29yZHMsIEkgdGhpbmsKaXQncyBzdHVjayBiZWNhdXNlIGlmIG5v IGxpbWl0IDEgLHNwZWVkIGlzIG9rOwoK --===============8029877464924054289==--