Re: Bug in calculations of UNSIGNED int

[Ben. H.]

As far 222-223 is not positive you should used a signed type to get good result.

Take a look at,

SELECT S91-223 FROM SPS;

+----------------------+
| S91-223 |
+----------------------+
| 18446744073709551615 |
+----------------------+

But you want -1?

So, use a signed smallint will not probably help, it will give you the right
solution. Note also this will cost 1 byte more per record, so as example for
about 1048576 records you take 1MB as much harddisk space, is really matter?