Archives of the TeradataForum

Message Posted: Tue, 02 Aug 2005 @ 10:07:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tuesday, August 02, 2005 03:32 -->

Hi,

Does someone know what the correct range of the TERADATA FLOAT datatype? The DBS throws error "3755 Numeric overflow error" for float value 2x10**308.

The V2R4.0 documentation says the range for the FLOAT data type is 2 x 10**-307 to 2 x 10**+308.

thanks

Phantom

     BTEQ 08.02.03c.00 Tue Aug 02 12:59:32 2005

     +---------+---------+---------+---------+---------+---------+

     sel * from dbc.dbcinfo;

      *** Query completed. 2 rows found. 2 columns returned.
      *** Total elapsed time was 1 second.

     InfoKey               InfoData
     -----------------------------------
     RELEASE               V2R.06.01n.00.00
     VERSION               06.01n.00.00

     +---------+---------+---------+---------+---------+---------+


     delete database testdb;

      *** Database's tables deleted.
      *** Total elapsed time was 14 seconds.


     +---------+---------+---------+---------+---------+---------+

     create database testdb as perm=1e6;
      *** Failure 5612 A user, database or role with the specified name already exists.
                Statement# 1, Info =0
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     database testdb;

      *** New default database accepted.
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+


     ct tab1(c1 float);

      *** Table has been created.
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+

     /*Value range 2 x 10**-307 to 2 x 10**+308 as per V2R4.0 documentation*/

     /*test value*/
     ins tab1(2*1E305);

      *** Insert completed. One row added.
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+

     /*min value as per documentation*/
     ins tab1(2*10E-307);

      *** Insert completed. One row added.
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+

     /*max value as per documentation*/
     ins tab1(2*10E308);

     ins tab1(2*10E308);
                $
      *** Failure 3755 Numeric overflow error.
                     Statement# 1, Info =13
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+


     sel tab1.*;

      *** Query completed. 2 rows found. One column returned.
      *** Total elapsed time was 1 second.

                         c1
     ----------------------
      2.00000000000000E 305
      2.00000000000000E-306

     +---------+---------+---------+---------+---------+---------+

	<Prev	Next>		<<First	<Prev	Next>	Last>>