| Lists: | pgsql-hackers |
|---|
| From: | "Merlin Moncure" <wizard_32141(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | possible obvious bug? |
| Date: | 2002-11-26 03:00:26 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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!
Merlin
| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Merlin Moncure <wizard_32141(at)yahoo(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: possible obvious bug? |
| Date: | 2002-11-26 21:17:14 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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 ?
----------
Hannu
| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | Merlin Moncure <wizard_32141(at)yahoo(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: possible obvious bug? |
| Date: | 2002-11-26 22:11:40 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On 27 Nov 2002, Hannu Krosing wrote:
> 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?
| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Hannu Krosing" <hannu(at)tm(dot)ee>, "Merlin Moncure" <wizard_32141(at)yahoo(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: possible obvious bug? |
| Date: | 2002-11-26 22:12:17 |
| Message-ID: | 021601c29598$e2659170$6500a8c0@internal |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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 ?
NaN :)
Chris
| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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