Archives of the TeradataForum
Message Posted: Tue, 27 May 2008 @ 22:19:30 GMT
| Subj: || || Re: Dieter's collect stats query on v12 |
| From: || || Dieter Noeth |
| ||I also tried to duplicate the 4 as padbytes logic in each branch of the query and ran into numeric overflow.|| |
| ||Should PadBytes be cast as an integer? As a Bigint? Dec(18,0) ?|| |
| ||Are there some intermediate calcs that need to be cast?|| |
Those numeric overflow shouldn't occur if the PadBytes are modified correctly. I thought i fixed that, it was due to some unusual default
I remember a 3610 on a 32-bit TD12 beta once, but it seemed to be fixed. The strange thing about it was: It only happened when submitted using
ODBC, but not with BTEQ. And it was only for the view version, not the base table version, the only difference between both is an additional
calculation in the base table version (but only the view version crashed).
Please try both versions and use SQL Assistant and BTEQ.
But still open an incident, because a 3610 is always a bug.