|
Archives of the TeradataForumMessage Posted: Wed, 25 Jul 2007 @ 21:49:11 GMT
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
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||