Archives of the TeradataForum

Message Posted: Thu, 26 Jul 2002 @ 06:41:16 GMT

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

H-e-l-l-o to All!

I'm accessing a table with the following structure:

Table_AAA

Key_col1 dec(18,0)
ADate_col2 date
AChar_col3 char(5)
Another_Dec_col4 dec(3,0) title 'ADEC'
PI(Key_col1)

Assume Table_AAA has 3 rows: Sel * from Table_AAA

Key_col1                    Date_col2   Char_col3     ADEC_col4
104230608995498370 2002-07-24   AAAA           100
214555555555567800 2002-07-25   BBBB           200
333333333333333500 2002-07-26   CCCC           300

If I attempt to select a specific row by PI; the result is null.

For example,

Sel * from Table_AAA where Key_col1 = 333333333333333500
yields a null set.

However, if I qualify rows by any other column; I get the expected result.

For example,

Sel * from Table_AAA where ADEC_Col4 = 300

Key_col1                    Date_col2   Char_col3     ADEC_col4
333333333333333500 2002-07-26   CCCC           300

After running a few tests; I can only conclude that a column defined as Decimal 18, with zero precision, misbehaves. Or, I may be doing something incorrectly.

Has anyone encountered this problem? If so, why is this occurring? And what can I do to prevent it?

PS> In-depth explanations are always welcomed.

Thanks in advance for all your help.

Al

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