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.