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



Mon, 25 Nov 2002 22:00:26 -0500
"Merlin Moncure" <wizard_32141@yahoo.com>
possible obvious bug?
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



27 Nov 2002 02:17:14 +0500
Hannu Krosing <hannu@tm.ee>
Re: possible obvious bug?
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?


Tue, 26 Nov 2002 15:11:40 -0700 (MST)
"scott.marlowe" <scott.marlowe@ihs.com>
Re: possible obvious bug?

> 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


Tue, 26 Nov 2002 14:12:17 -0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: possible obvious bug?
> > 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


Tue, 26 Nov 2002 14:13:48 -0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: possible obvious bug?