Bug with field type double unsigned
Uzi Klein <[email protected]> Wed, 05 Jan 2005 12:12:26 +0200
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hi
thters seems to be an error with double unsigned fields :
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 |
| -0.855 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -1.695 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.847 |
| -0.855 |
| -0.847 |
| -0.847 |
| -12277.966 |
| -3205.128 |
+-------------+
38 rows in set (0.13 sec)
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]