 |
 |
Archives of the TeradataForum
Message Posted: Fri, 28 Aug 2009 @ 14:39:42 GMT
| Subj: | | Re: Spool space error |
| |
| From: | | Victor Sokovin |
| | No, when there's a plain "SELECT TOP x * FROM table" without WHERE or ORDER it's not expected to spool the table. | |
Apparently, buggy releases have been reported in the past. For example, here:
www.teradataforum.com/teradata/20060922_185048.htm
It could be that the R6 demo versions distributed around that time were also affected and they are still in use. Perhaps following
Randall's observation and using a column name rather than * could sort out the spool issue in such cases?
Victor
| |
