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 1kPvlH-0007uG-1g for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Oct 2020 22:48:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kPvlE-0003uN-Fo for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Oct 2020 22:48:44 +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 1kPvMY-0000aX-HX for pgsql-bugs@lists.postgresql.org; Tue, 06 Oct 2020 22:23:14 +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 1kPvMR-0004BO-O5 for pgsql-bugs@lists.postgresql.org; Tue, 06 Oct 2020 22:23:14 +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=Ktrmcw8h/xKDHT21KS5s+PNb5vOoqCKgndCxUi/gf1c=; b=JVpFe34gNJlhG/lT7GQ2B5IsTJ vJhy7ZwEVrltmUxbmvQH+Knys2d0cJ1vg1Hnlu2kDxiRPomlq+mLTqx0LvsvWItkBQ+9vQv7UXASR MIDUEiTGeG7IGBbeVSZN+V1qB24LbNXtYdppA6rnE3jwmc1a+kkzNsbcRiB3JQ3szhBlyNE+AUz0T xlDEvU525QmfEm7no8uzhvBycZNyfdwj65PelGOF7Q3LaCrN/BJNJ0dvW20Xt35VHF7VHFekJUvFd Vpb0jUTVrqo2zY5XuL00oo4I/Oqh7jeKkEevABo1mSgVqQlWuAVxzj8/KxadyOpRiS38QsDhns+hO wPBPoh1Q==; 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 1kPvMQ-0002NA-6x for pgsql-bugs@lists.postgresql.org; Tue, 06 Oct 2020 22:23:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kPvMM-0002XB-FN for pgsql-bugs@lists.postgresql.org; Tue, 06 Oct 2020 22:23:02 +0000 Content-Type: multipart/mixed; boundary="===============3648927146027926584==" MIME-Version: 1.0 Subject: BUG #16657: Index not reflecting update when date to timestamp comparison operation used in index scan To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: huss@9fin.com Reply-To: huss@9fin.com, pgsql-bugs@lists.postgresql.org Date: Tue, 06 Oct 2020 22:22:18 +0000 Message-ID: <16657-cde2f876d8cc7971@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3648927146027926584== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjY1NwpMb2dnZWQgYnk6ICAgICAgICAgIEh1c3MgRUwtU2hlaWtoCkVt YWlsIGFkZHJlc3M6ICAgICAgaHVzc0A5ZmluLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEzLjAK T3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKSGVsbG8sDQoN Ckkgb2JzZXJ2ZWQgdGhlIGZvbGxvd2luZyBvZGQgYmVoYXZpb3VyIHdoZW4gZGVidWdnaW5nIGEg cHJvYmxlbSB3aGVyZSBteQphcHBsaWNhdGlvbiBpbnNlcnRlZCBhIHdpbGRseSBsYXJnZSBkYXRl IGludG8gYSB0YWJsZS4gT24gbXkgZW5kLCB0aGUgZGF0ZQpzaG91bGQgaGF2ZSBiZWVuIHByb3Bl cmx5IGJvdW5kYXJ5IGNoZWNrZWQgaW4gdGhlIGFwcGxpY2F0aW9uIGZpcnN0LCBob3dldmVyCndo ZW4gZml4aW5nIHRoZSB2YWx1ZSB3aXRoIGFuIHVwZGF0ZSwgc3Vic2VxdWVudCBxdWVyaWVzIGFn YWluc3QgdGhlIHRhYmxlCndlcmUgcmV0dXJuaW5nICAiU1FMIEVycm9yIFsyMjAwOF06IEVSUk9S OiBkYXRlIG91dCBvZiByYW5nZSBmb3IgdGltZXN0YW1wIi4KQWZ0ZXIgc29tZSBpbnZlc3RpZ2F0 aW9uLCBJIHRoaW5rIEkgaGF2ZSBuYXJyb3dlZCBpdCBkb3duIHRvIHNvbWUgc29ydCBvZgppbmNv bnNpc3RlbmN5IHdpdGggdGhlIGluZGV4IHVzZWQgaW4gdGhlIHF1ZXJ5LiBJdCBpcyBiZWhhdmlu ZyBhcyBpZiB0aGUgb2xkCmludmFsaWQgdmFsdWUgaXMgc3RpbGwgaW4gdGhlIHRhYmxlLCB3aGlj aCBpdCBpcyBub3QuIEkgdGhpbmsgaXQncyBhbHNvCnNpZ25pZmljYW50IHRoYXQgdGhpcyBpcyBo YXBwZW5pbmcgd2l0aCB0byB0aGUgY2FzdGluZyB0byA6OnRpbWVzdGFtcCBpbiB0aGUKV0hFUkUg Y2xhdXNlIG9mIHRoZSBxdWVyeSwgYnV0IHRoZSBuYXRpdmUgdHlwZSBvZiB0aGUgZmllbGQgaXMg OjpkYXRlLiBJZgp0aGVyZSBpcyBubyA6OnRpbWVzdGFtcCBjYXN0aW5nLCB0aGlzIGlzc3VlIGRv ZXMgbm90IGhhcHBlbi4NCg0KSSBhdHRhY2ggYmVsb3cgYSBzY3JpcHQgdG8gcmVwbGljYXRlIHRo ZSBpc3N1ZS4NCg0KUmVnYXJkcywNCkh1c3MNCg0KYGBgDQpiZWdpbjsNCmRyb3AgdGFibGUgaWYg ZXhpc3RzIHB1YmxpYy5yZXBsaWNhdGVfdGltZXN0YW1wX3JhbmdlX2luZGV4Ow0KDQpjcmVhdGUg dGFibGUgcHVibGljLnJlcGxpY2F0ZV90aW1lc3RhbXBfcmFuZ2VfaW5kZXggKA0KaWQgYmlnc2Vy aWFsIG5vdCBudWxsIHByaW1hcnkga2V5LA0KZGF0ZV9maWVsZCBkYXRlIG5vdCBudWxsDQopOw0K Y3JlYXRlIGluZGV4IGRhdGVfZmllbGRfaWR4IG9uIHB1YmxpYy5yZXBsaWNhdGVfdGltZXN0YW1w X3JhbmdlX2luZGV4CihkYXRlX2ZpZWxkKTsNCg0KLS0gaW5zZXJ0IGRhdGUgd2hpY2ggaXMgd2l0 aGluIHRoZSBhbGxvd2FibGUgZGF0ZSByYW5nZSwgYnV0IG91dHNpZGUgb2YgdGhlCnRpbWVzdGFt cCByYW5nZQ0KaW5zZXJ0IGludG8gcHVibGljLnJlcGxpY2F0ZV90aW1lc3RhbXBfcmFuZ2VfaW5k ZXggKGRhdGVfZmllbGQpIHZhbHVlcwooJzIyMDIwMjAtMTAtMDUnKTsNCi0tIHVwZGF0ZSB0byAi Zml4IiB0aGlzIGVycm9yDQp1cGRhdGUgcHVibGljLnJlcGxpY2F0ZV90aW1lc3RhbXBfcmFuZ2Vf aW5kZXggc2V0IGRhdGVfZmllbGQgPSAnMjAyMC0xMC0wNScKd2hlcmUgaWQgPSAxOw0KDQotLSB1 bmNvbW1lbnQgdGhpcyBibG9jayBmb3IgdGhlIHJlaW5kZXhpbmcgdG8gdGFrZSBlZmZlY3QNCi0t IGFwcGVhcnMgYXMgaWYgY29tbWl0dGluZyB0aGUgcHJldmlvdXMgRE1MLCBhbmQgdGhlbiBjb21t aXR0aW5nIHRoZQpyZWluZGV4DQotLSBpcyB0aGUgb25seSB3YXkgZm9yIHRoZSBpbmRleCB0byAi cmVwYWlyIiBpdHNlbGYNCi8qDQpjb21taXQ7ICAtLSBjb21taXQgcHJldmlvdXMNCmJlZ2luOyAg LS0gbmV3IHR4DQpyZWluZGV4IGluZGV4IHB1YmxpYy5kYXRlX2ZpZWxkX2lkeDsNCmNvbW1pdDsg IC0tIGNvbW1pdCByZWluZGV4DQpiZWdpbjsgLS0gbmV3IHR4DQoqLw0KDQpTRVQgZW5hYmxlX3Nl cXNjYW4gPSBPRkY7IC0tIGVuc3VyZSB0aGUgaW5kZXggaXMgdXNlZA0KZXhwbGFpbiBhbmFseXNl DQpzZWxlY3QgKg0KRlJPTSBwdWJsaWMucmVwbGljYXRlX3RpbWVzdGFtcF9yYW5nZV9pbmRleA0K d2hlcmUgZGF0ZV9maWVsZCA9ICcyMDIwLTEwLTA1Jzo6dGltZXN0YW1wOw0KDQpkcm9wIHRhYmxl IGlmIGV4aXN0cyBwdWJsaWMucmVwbGljYXRlX3RpbWVzdGFtcF9yYW5nZV9pbmRleDsNCmNvbW1p dDsNCg0KLS0gdGVzdGVkIGFnYWluc3QgYmVsb3cgdmVyc2lvbigpIG91dHB1dHMNCi0tIFBvc3Rn cmVTUUwgMTIuMiBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKEdDQykg NC44LjMKMjAxNDA5MTEgKFJlZCBIYXQgNC44LjMtOSksIDY0LWJpdA0KLS0gUG9zdGdyZVNRTCAx My4wIChEZWJpYW4gMTMuMC0xLnBnZGcxMDArMSkgb24geDg2XzY0LXBjLWxpbnV4LWdudSwKY29t cGlsZWQgYnkgZ2NjIChEZWJpYW4gOC4zLjAtNikgOC4zLjAsIDY0LWJpdA0KYGBgCgo= --===============3648927146027926584==--