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 1jN9Da-00080q-Np for pgsql-bugs@arkaria.postgresql.org; Sat, 11 Apr 2020 06:02:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jN9DX-0000cs-IE for pgsql-bugs@arkaria.postgresql.org; Sat, 11 Apr 2020 06:02:11 +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 1jN9DX-0000cl-BK for pgsql-bugs@lists.postgresql.org; Sat, 11 Apr 2020 06:02:11 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jN9DQ-0001SV-4X for pgsql-bugs@lists.postgresql.org; Sat, 11 Apr 2020 06:02:10 +0000 Content-Type: multipart/mixed; boundary="===============3272016386462883516==" MIME-Version: 1.0 Subject: BUG #16357: Incorrect rounding for negative arguments in to_timestamp() To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ivbel@ispras.ru Reply-To: ivbel@ispras.ru, pgsql-bugs@lists.postgresql.org Date: Sat, 11 Apr 2020 06:01:49 +0000 Message-ID: <16357-4ed50b3eb9a1a065@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3272016386462883516== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjM1NwpMb2dnZWQgYnk6ICAgICAgICAgIEl2YW4gQmVsb2Jvcm9kb3YK RW1haWwgYWRkcmVzczogICAgICBpdmJlbEBpc3ByYXMucnUKUG9zdGdyZVNRTCB2ZXJzaW9uOiA5 LjYuMTcKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCA1LjAuMCwgVWJ1bnR1IDE4LjA0LjEKRGVz Y3JpcHRpb246ICAgICAgICAKCnRvX3RpbWVzdGFtcCgpIHJldHVybnMgaW5jb3JyZWN0IHJlc3Vs dHMgZm9yIHNvbWUgbmVnYXRpdmUgYXJndW1lbnRzOiANCg0Kc2V0IGV4dHJhX2Zsb2F0X2RpZ2l0 cyB0byAxOw0KU0VUDQpzZWxlY3QgZXh0cmFjdChlcG9jaCBmcm9tIHRpbWVzdGFtcCAnMTkyMC0x MC0yNCAxMjoxMToxMy45NzUyMjcnKTsNCiAgICAgZGF0ZV9wYXJ0ICAgICAgDQotLS0tLS0tLS0t LS0tLS0tLS0tLQ0KIC0xNTUyMjE4NTI2LjAyNDc3Mw0KKDEgcm93KQ0Kc2VsZWN0IHRvX3RpbWVz dGFtcCgtMTU1MjIxODUyNi4wMjQ3NzMpIGF0IHRpbWUgem9uZSAnVVRDJzsNCiAgICAgICAgICB0 aW1lem9uZSAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAxOTIwLTEw LTI0IDEyOjExOjEzLjk3NTIyOA0KKDEgcm93KQ0KDQpXaGVyZWFzIGZvciBwb3NpdGl2ZSBhcmd1 bWVudHMgb2YgdGhlIHNhbWUgbWFnbml0dWRlIGV2ZXJ5dGhpbmcncyBvazoNCg0Kc2VsZWN0IGV4 dHJhY3QoZXBvY2ggZnJvbSB0aW1lc3RhbXAgJzIwMTktMDMtMTAgMTE6NDg6NDYuMDI0NzczJyk7 DQogICAgIGRhdGVfcGFydCAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tDQogMTU1MjIxODUyNi4w MjQ3NzMNCigxIHJvdykNCnNlbGVjdCB0b190aW1lc3RhbXAoMTU1MjIxODUyNi4wMjQ3NzMpIGF0 IHRpbWUgem9uZSAnVVRDJzsNCiAgICAgICAgICB0aW1lem9uZSAgICAgICAgICANCi0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAyMDE5LTAzLTEwIDExOjQ4OjQ2LjAyNDc3Mw0KKDEgcm93 KQ0KDQpUaGUgcHJvYmxlbSBpcyBub3Qgd2l0aCBleHRyYV9mbG9hdF9kaWdpdHM6DQoNCnNldCBl eHRyYV9mbG9hdF9kaWdpdHMgdG8gMDsNClNFVA0Kc2VsZWN0IHRvX3RpbWVzdGFtcCgtMTU1MjIx ODUyNi4wMjQ3NzMpIGF0IHRpbWUgem9uZSAnVVRDJyA9IHRpbWVzdGFtcAonMTkyMC0xMC0yNCAx MjoxMToxMy45NzUyMjcnOw0KID9jb2x1bW4/IA0KLS0tLS0tLS0tLQ0KIGYNCigxIHJvdykNCg0K QW5kLCBhcyBmYXIgYXMgSSB1bmRlcnN0YW5kLCBub3Qgd2l0aCBpbnN1ZmZpY2llbnQgcHJlY2lz aW9uIG9mIGZsb2F0OCwgaGVyZQppcyBhbiBleGFtcGxlIHdpdGggdGhlIHNhbWUgYmVoYXZpb3Vy IHdpdGggMTUgc2lnbmlmaWNhbnQgZGlnaXRzOg0KDQpzZWxlY3QgZXh0cmFjdChlcG9jaCBmcm9t IHRpbWVzdGFtcCAnMTg1My0wOC0xNSAxMDowNDoxNS4zNTA2NCcpOw0KICAgICBkYXRlX3BhcnQg ICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIC0zNjcyNTY4NTQ0LjY0OTM2DQooMSByb3cpDQpz ZWxlY3QgdG9fdGltZXN0YW1wKC0zNjcyNTY4NTQ0LjY0OTM2KSBhdCB0aW1lIHpvbmUgJ1VUQyc7 DQogICAgICAgICAgdGltZXpvbmUgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQogMTg1My0wOC0xNSAxMDowNDoxNS4zNTA2MzkNCigxIHJvdykNCnNlbGVjdCBleHRyYWN0 KGVwb2NoIGZyb20gdGltZXN0YW1wICcyMDg2LTA1LTE4IDEzOjU1OjQ0LjY0OTM2Jyk7DQogICAg ZGF0ZV9wYXJ0ICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLQ0KIDM2NzI1Njg1NDQuNjQ5MzYNCigx IHJvdykNCnNlbGVjdCB0b190aW1lc3RhbXAoMzY3MjU2ODU0NC42NDkzNikgYXQgdGltZSB6b25l ICdVVEMnOw0KICAgICAgICAgdGltZXpvbmUgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NCiAyMDg2LTA1LTE4IDEzOjU1OjQ0LjY0OTM2DQooMSByb3cpDQoNClRlc3RlZCB0 aGlzIGJlaGF2aW91ciBvbiBQb3N0Z3JlU1FMIDkuNi4xNywgTGludXggNS4wLjAsIFVidW50dSAx OC4wNC4xIGFuZApQb3N0Z3JlU1FMIDEwLjEsIExpbnV4IDQuNC4wLCBVYnVudHUgMTQuMDQuMQoK --===============3272016386462883516==--