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


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.


  <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