| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | Bruno Wolff III <bruno(at)wolff(dot)to>, rabt(at)dim(dot)uchile(dot)cl, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: BIG files |
| Date: | 2005-06-19 16:33:01 |
| Message-ID: | 20050619092922.L16897@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-06-19 18:20:50 | Re: BIG files |
| Previous Message | Michael Fuhr | 2005-06-19 14:17:42 | Re: BIG files |