![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 09 Jul 2009 @ 20:29:44 GMT
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
| |