Archives of the TeradataForum

Message Posted: Wed, 25 Jul 2007 @ 21:49:11 GMT

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

But the old one run successfully?

I can't remember, if i changed the logic for the typecast to timestamp....

Maybe there's a change in the internal storage of the stats?

Could you create a table, inserts some rows in it, collect stats and extract the stored varbytes?

     CREATE TABLE dropme( i INT, d DECIMAL(30 ,0), ts TIMESTAMP);

     INSERT INTO dropme VALUES( 1, 1234567890123456789.,
        TIMESTAMP '2007-07-25 21:24:03.540000+00:00');

     COLLECT STATS ON dropme COLUMN ts;
     COLLECT STATS ON dropme COLUMN d;
     COLLECT STATS ON dropme COLUMN i;

     SELECT ColumnName, SUBSTR(fieldstatistics, 1, 80) AS STATS
     FROM dbc.ColumnStats
     WHERE databasename = DATABASE
     AND tablename = 'dropme';

     DROP TABLE dropme;

These are the result on my notebook, the first 8 bytes are date/time, so they will change, but the remaining bytes shouldn't:

     ColumnName                      STATS
     ------------------------------
     ------------------------------------------------------------------------
     ------------------------------------------------------------------------
     ----------------
     ts
     D7070719161C29460200000000000000000000000100000020043600D707071915180000
     C500445520043600D707071915180000C5004455000000000000F03F000000000000F03F
     000000000000F03F
     d
     D7070719161C294C0200000000000000000000000100010081E97DF41022B14381E97DF4
     1022B143000000000000F03F000000000000F03F000000000000F03F81E97DF41022B143
     81E97DF41022B143
     i
     D7070719161C294F02000000000000000000000001000100000000000000F03F00000000
     0000F03F000000000000F03F000000000000F03F000000000000F03F000000000000F03F
     000000000000F03F

Dieter

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