7.1: to_char() bug fix

Started by Karel Zakover 25 years ago2 messagespatches
Jump to latest
#1Karel Zak
zakkr@zf.jcu.cz

Hi,

here is a patch fixing today's bug report:

Date: Thu, 14 Dec 2000 12:44:47 +0100 (CET)
From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
To: pgsql-bugs@postgresql.org
Subject: [BUGS] to_char() causes backend to close connection

Hi, this query gives different strange results:

select to_char(now()::abstime,'YYMMDDHH24MI');

I get e.g. a "backend closed the channel unexpectedly..." error with
successful or failed resetting attempt (indeterministic)

Again thanks Kovacs, you found really designing bug, that appear
if anyone write bad format template to "number" version of to_char()
(as you with 'DD').

Karel

PS. It's not recursive diff, must be apply into src/utils/atd, Thanks.

Attachments:

to_char-12142000.patch.gzapplication/x-gzip; name=to_char-12142000.patch.gzDownload
#2Bruce Momjian
bruce@momjian.us
In reply to: Karel Zak (#1)
Re: 7.1: to_char() bug fix

Thanks. Applied.

Hi,

here is a patch fixing today's bug report:

Date: Thu, 14 Dec 2000 12:44:47 +0100 (CET)
From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
To: pgsql-bugs@postgresql.org
Subject: [BUGS] to_char() causes backend to close connection

Hi, this query gives different strange results:

select to_char(now()::abstime,'YYMMDDHH24MI');

I get e.g. a "backend closed the channel unexpectedly..." error with
successful or failed resetting attempt (indeterministic)

Again thanks Kovacs, you found really designing bug, that appear
if anyone write bad format template to "number" version of to_char()
(as you with 'DD').

Karel

PS. It's not recursive diff, must be apply into src/utils/atd, Thanks.

Content-Description:

[ application/x-gzip is not supported, skipping... ]

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026