[PATCH] Fix interval input at minimum signed field values (BUG #19746)

From: Tình Trần <tranvantinhnbk(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: [PATCH] Fix interval input at minimum signed field values (BUG #19746)
Date: 2026-10-20 13:27:45
Message-ID: CAEPgAbE+V7Wgx-1BYap276v_Ohc7Zk2HV3-U8Wp520Jz84NRmg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

Attached is a proposed fix for BUG #19746.

The bug causes an interval containing INT64_MIN microseconds to be
printed successfully but rejected when read back.

The patch fixes the interval parsing logic and adds regression tests for
text round trips, boundary values, overflow, and AGO output.

This is my first PostgreSQL patch submission, so feedback would be greatly
appreciated.

Regards,
Tinh

Attachment Content-Type Size
v2-0001-fix-interval-input-at-minimum-signed-values.patch application/octet-stream 13.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2026-10-20 13:29:05 Re: ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases
Previous Message David G. Johnston 2026-10-20 13:26:29 Re: Extract text from XML, pay attention to XML Entities