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?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.