From owner-freebsd-standards@FreeBSD.ORG Wed May 7 10:57:44 2003 Return-Path: Delivered-To: freebsd-standards@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 90EA937B416 for ; Wed, 7 May 2003 10:57:42 -0700 (PDT) Received: from perrin.int.nxad.com (internal.ext.nxad.com [69.1.70.251]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9BE6143F3F for ; Wed, 7 May 2003 10:57:41 -0700 (PDT) (envelope-from sean@perrin.int.nxad.com) Received: by perrin.int.nxad.com (Postfix, from userid 1001) id F263F20F00; Wed, 7 May 2003 10:57:40 -0700 (PDT) Date: Wed, 7 May 2003 10:57:40 -0700 From: Sean Chittenden To: freebsd-standards@FreeBSD.org Message-ID: <20030507175740.GM49916@perrin.int.nxad.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Q0rSlbzrZN6k9QnT" Content-Disposition: inline User-Agent: Mutt/1.4i X-PGP-Key: finger seanc@FreeBSD.org X-PGP-Fingerprint: 3849 3760 1AFE 7B17 11A0 83A6 DD99 E31F BC84 B341 X-Web-Homepage: http://sean.chittenden.org/ Subject: float values at the extreme... when did things change? X-BeenThere: freebsd-standards@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Standards compliance List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 07 May 2003 17:57:44 -0000 --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 iD8DBQE+uUkU3ZnjH7yEs0ERAq9lAKCpvTG1pI06ce9PF7cBGicGdL5evwCfcw86 ux2VPvbGwBVWH8s+OKafQ3E= =orD1 -----END PGP SIGNATURE----- --Q0rSlbzrZN6k9QnT--