Re: BIG files

On Sun, 19 Jun 2005, Michael Fuhr wrote:

> PostgreSQL 8.0.3:
>
>           n1          |          n2          |       ?column?
> ----------------------+----------------------+----------------------
>  10000000000000000000 | 10000000000000000001 | 20000000000000000001
>
> MySQL 4.1.12:
>
> +----------------------+----------------------+-----------------------+
> | n1                   | n2                   | n1 + n2               |
> +----------------------+----------------------+-----------------------+
> | -8446744073709551616 | -8446744073709551615 | -16893488147419099136 |
> +----------------------+----------------------+-----------------------+
>
> Beauty.  Nice of MySQL not to raise an error if I've exceeded some
> implementation-defined limit.

To be fair, we didn't raise proper errors for integer math until fairly
recently (as recently as 7.4, we had overflow issues on operators where
the arguments were in range but the result was not).