Date: Wed, 7 May 2003 10:57:40 -0700 From: Sean Chittenden <seanc@FreeBSD.org> To: freebsd-standards@FreeBSD.org Subject: float values at the extreme... when did things change? Message-ID: <20030507175740.GM49916@perrin.int.nxad.com>
next in thread | raw e-mail | index | archive | help
--Q0rSlbzrZN6k9QnT
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
While PostgreSQL runs its regression tests fine on 4.X, in recent 5.X
the return values of floats have changed and I'm trying to figure out
the best way to detect this.
Under older versions of FreeBSD, the following was true:
INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
ERROR: Input '10e400' is out of range for float8
INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
ERROR: Input '-10e400' is out of range for float8
INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
Small values were considered zero. Now, however, small values are out
of range:
INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
ERROR: Input '-10e400' is out of range for float8
INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
ERROR: Input '10e-400' is out of range for float8
INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
ERROR: Input '-10e-400' is out of range for float8
No doubt that things are more correct in their current incarnation,
however, when did this change (not sure where to look) and was there a
__FreeBSD_version bump regarding this? -sc
PS Reason this is on standards is because from what I can tell,
-CURRENT's float handling is more standards compliant than previously
and figure someone on this list had a hand in making this the case.
--=20
Sean Chittenden
--Q0rSlbzrZN6k9QnT
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Comment: Sean Chittenden <sean@chittenden.org>
iD8DBQE+uUkU3ZnjH7yEs0ERAq9lAKCpvTG1pI06ce9PF7cBGicGdL5evwCfcw86
ux2VPvbGwBVWH8s+OKafQ3E=
=orD1
-----END PGP SIGNATURE-----
--Q0rSlbzrZN6k9QnT--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030507175740.GM49916>