Re: Bug with field type double unsigned

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 [email protected] 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

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]