HI all I have a question regarding Numeric overflow error. I know that when we are using aggregate functions the datatype of the result is same as that of the Column being aggregated. If the value passes beyond the linit supported by that datatype it gives numeric overflow error. However is this true in case of COUNT. What is the datatype of the result when we use count(*). i want to know what is the maximum count that we can have.?
It's surprising with the introduction of BIGINT that the default data type returned in Teradata mode was not changed. (Of course it would wreak havoc with MS Office products that do not support the data type correctly and may have been the deciding factor to leave it at INTEGER. But DECIMAL(38) would cause equal headaches.)