Re: Remove dependence on integer wrapping

From: Matthew Kim <matthewkmkim(at)gmail(dot)com>
To: Joseph Koshakow <koshy44(at)gmail(dot)com>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Alexander Lakhin <exclusion(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Remove dependence on integer wrapping
Date: 2024-08-10 21:54:48
Message-ID: CAGzNdfFs4hN=_2SZzZivoNtR8H1DiYHc+Zgh_oLv16EgXLuZGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jul 22, 2024 at 5:52 PM Alexander Lakhin
<exclusion(at)gmail(dot)com>
wrote:

> Also there are several trap-producing cases with date types:
> SELECT to_timestamp('1000000000,999', 'Y,YYY');

I attached patch 5 that fixes the to_timestamp overflow.

Thank you,
Matthew Kim

Attachment Content-Type Size
v18-0003-Handle-overflows-in-do_to_timestamp.patch application/x-patch 3.1 KB
v18-0004-Handle-overflow-when-taking-absolute-value-of-BC-yea.patch application/x-patch 1.9 KB
v18-0002-Remove-dependence-on-integer-wrapping-for-jsonb.patch application/x-patch 2.7 KB
v18-0001-Remove-dependence-on-integer-wrapping.patch application/x-patch 14.4 KB
v18-0005-Prevent-overflow-when-converting-years-to-millenia.patch application/x-patch 3.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2024-08-10 22:11:00 Re: On non-Windows, hard depend on uselocale(3)
Previous Message Andres Freund 2024-08-10 21:47:57 Re: Vacuum ERRORs out considering freezing dead tuples from before OldestXmin