Re: Bug with field type double unsigned - Sergei Golubchik - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsRe: Bug with field type double unsigned

From	Sent On	Attachments
Uzi Klein	05 Jan 2005 02:12
Sergei Golubchik	06 Jan 2005 02:38
Uzi Klein	06 Jan 2005 03:24

Subject:	Re: Bug with field type double unsigned
From:	Sergei Golubchik (se...@mysql.com)
Date:	01/06/2005 02:38:57 AM
List:	com.mysql.lists.bugs

Hi!

On Jan 05, Uzi Klein wrote:

Hi thters seems to be an error with double unsigned fields :

Could you provide a repeatable test case ? (that is, INSERT/UPDATE statements that would generate such a table)

I failed to repeat it with random data :(

By the way, the recommended place to report bugs is our bug-tracking system at http://bugs.mysql.com, you will get automatic notification when the bug is fixed, etc.

But of course bu...@lists.mysql.com is ok too

mysql version 4.0.22 red hat linux 9

mysql> SHOW CREATE TABLE ContractPayments; +------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table +------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ContractPayments | CREATE TABLE `ContractPayments` ( `PaymentID` int(10) unsigned NOT NULL auto_increment, `ContractID` int(10) unsigned NOT NULL default '0', `FundRemains` double unsigned default NULL, PRIMARY KEY (`PaymentID`), KEY `ContractID` (`ContractID`) ) ENGINE=MyISAM DEFAULT | +------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)

mysql> SELECT FundRemains FROM ContractPayments WHERE FundRemains<0; +-------------+ | FundRemains | +-------------+ | -1439.252 | | -100529.06 | | -0.847 | +-------------+ 38 rows in set (0.13 sec)

Regards, Sergei