I am working on Teradata 14 and i see that integers/decimal are stored with leading spaces in table. I haven't seen this behavious previously.
create volatile table tmp1 ( col DECIMAL(8,2) ) on commit preserve rows;
ins tmp1 values ('123.72');
ins tmp1 values ('-12.34');
ins tmp1 values (98.76);
sel * from tmp1
col 1 -12.34 2 98.76 3 123.72
Similar behavious is seen with integers as well
Can anyone explain?