Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 May 2008 @ 22:19:30 GMT


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


Subj:   Re: Dieter's collect stats query on v12
 
From:   Dieter Noeth

Anomy.Anom wrote:

  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 formats.

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.


Dieter



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023