Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2007 @ 13:19:03 GMT

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

Hi,

I have a table with column decimal(18,0) in which I want to store large generated key. I have discovered strange behaviour when working with the number stored in it. See examples below. When I use decimal(16,0) everything is ok. I have a suspision that 2 places are reserved for the decimal separator and sign and decimal(16,0) is maximum for storing numbers. Can someone add more light to this?

     drop table decimal_test;
     create set table decimal_test (a decimal(18,0))
     ;
     insert decimal_test(a)
     values (222222333333444444);

This select returns number which is different from the one I have inserted:

     select * from decimal_test
     where a = 222222333333444444;

result:

     222222333333444448 - through jdbc connection
     222222333333444450 - odbc connection - sql assistant

     select * from decimal_test
     where a = '222222333333444444';

I get following error:

Precision error in FLOAT type constant or during implicit conversions. _

Thanks,

j.

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