| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, "Hannu Krosing" <hannu(at)tm(dot)ee> |
| Cc: | "Merlin Moncure" <wizard_32141(at)yahoo(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: possible obvious bug? |
| Date: | 2002-11-26 22:13:48 |
| Message-ID: | 022801c29599$1850ab30$6500a8c0@internal |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > Merlin Moncure kirjutas T, 26.11.2002 kell 08:00:
> > > I was playing with the Japanese win32 7.2.1 port and I noticed that
"select
> > > 0 / 0" caused the server to crash and restart. I understand that it
is a
> > > totally unsupported version, but it should be easy enough to check vs.
the
> > > current version. Note that select 0.0/0.0 worked fine!
> >
> > So what is the right answer ?
>
> Maybe it's a locale oriented thing?
In 7.2.3 there seem to be two different messages:
usa=# select 0/0;
ERROR: floating point exception! The last floating point operation either
exceeded legal ranges or was a divide by zero
usa=# select 0/0.0;
ERROR: float8div: divide by zero error
usa=# select 0.0/0.0;
ERROR: float8div: divide by zero error
usa=# select 0.0/0;
ERROR: float8div: divide by zero error
usa=# select 1/0;
ERROR: floating point exception! The last floating point operation either
exceeded legal ranges or was a divide by zero
usa=# select 1/0.0;
ERROR: float8div: divide by zero error
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-11-26 23:20:10 | Request from eWeek for 7.3 comments |
| Previous Message | Christopher Kings-Lynne | 2002-11-26 22:12:17 | Re: possible obvious bug? |