 |
 |
Archives of the TeradataForum
Message Posted: Tue, 20 May 2003 @ 14:20:06 GMT
| Subj: | | Re: Size of count(*) field |
| |
| From: | | Walter, Todd A |
It is actually quite easy to fix. There's always a but...
If we change it, then most applications which are coded to return count currently will fail when the database release is
installed. The failure will occur because the length, type and format of the result will change. Reports will change column layouts,
code will have to be changed to receive a different type/length, ...
Everytime we ask, we get a chorus of screams about how painful such a change will be. Note that it is DECIMAL(18,0) in ANSI mode
because we could start with it that way on day one.
| |