Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 09 Jul 2009 @ 20:29:44 GMT


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


Subj:   Re: VARCHAR and ORDER BY
 
From:   Victor Sokovin

  We have run this simple query which inserts 2 rows into a table, and > runs 3 separate selects.  


  We have tried this on a V2R6.1 , V2R6.2 and V12 machines.  


  The results are the same, the last 2 selects produce the wrong results.  


  We're told its due to the COLUMNLIST being over VARCHAR(1000).  


Sounds similar to

www.teradataforum.com/teradata/20070215_000000.htm


but instead of an explicit error it seems to be a silent bug now.

You can use the similar technique of casting the COLUMNLIST to VARCHAR(999), VARCHAR(1000), VARCHAR(1001) etc to find the true limit. I think it may be higher than 1000 but hard to tell without experiments. The lower it is the more damage the bug can bring, of course.


Victor



     
  <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