Re: Date-Time dangling unit fix

From: Joseph Koshakow <koshy44(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Date-Time dangling unit fix
Date: 2022-12-13 00:11:16
Message-ID: CAAvxfHdRsz=KRbp=gFvbOzVfcX1UoDxCzj8BwAYKMt46Hi+eAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 12, 2022 at 10:55 AM Joseph Koshakow <koshy44(at)gmail(dot)com> wrote:
>
> I just found another class of this bug that the submitted patch does
> not fix. If the units are at the beginning of the string, then they are
> also ignored. For example, `date 'm d y2020m11d3'` is also valid. I
> think the fix here is to check and make sure that ptype is 0 before
> reassigning the value to a non-zero number. I'll send an updated patch
> with this tonight.

Attached is the described patch.

- Joe Koshakow

Attachment Content-Type Size
v2-0001-Handle-dangling-units-in-date-time-input.patch text/x-patch 9.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2022-12-13 00:49:36 Re: slab allocator performance issues
Previous Message Michael Paquier 2022-12-12 23:56:33 Re: [PATCH] Add native windows on arm64 support