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