of that with FLOOR(expr) or TRUNCATE(expr, 0).
Hope that helps.
Matt
- Original Message -
From: Mark Marshall
Sent: Thursday, November 20, 2003 11:05 AM
Subject: Re: Why does -1 show up as 18446744073709551613?
That would be it!
Not sure how I missed that.
Thank you!
Mark
I've been running this query for quite some time that basically says:
SELECT (A + B + C) - (X + Y + Z) AS Variance
FROM .
Up until now, this has been working correctly and showing up as
anything from -100 to +100. Now all of a sudden, it's showing up as
18446744073709551613 instead of
This is in the Upgrading from 3.23 manual:
http://www.mysql.com/doc/en/Upgrading-from-3.23.html
Note: when you use subtraction between integer values where one is of type
UNSIGNED, the result will be unsigned. In other words, before upgrading to
MySQL 4.0, you should check your application for
That would be it!
Not sure how I missed that.
Thank you!
Mark
Mikael Fridh [EMAIL PROTECTED] 11/20/03 11:44AM
This is in the Upgrading from 3.23 manual:
http://www.mysql.com/doc/en/Upgrading-from-3.23.html
Note: when you use subtraction between integer values where one is of
type