MySQL Forums
Forum List  »  Quality Assurance

Is this a bug?
Posted by: Douglas Vogt
Date: January 02, 2007 11:32AM

I haven't been able to find anything on this... I've done the following:

created this table:
CREATE TABLE `testdb`.`math_test` (
`number_a` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`number_b` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`number_c` INTEGER UNSIGNED NOT NULL DEFAULT 0
)
ENGINE = InnoDB;

Inserted this row of data:
insert into math_test values (0,1,1)

Run this select statement:
select (number_a - number_b) / number_c from math_test

This is the result I get:
18446744073709551615.0000

Any ideas? If this is a bug I'll submit it... but I don't know what I could be doing wrong.

Douglas



Edited 1 time(s). Last edit at 01/02/2007 11:33AM by Douglas Vogt.

Options: ReplyQuote


Subject
Views
Written By
Posted
Is this a bug?
4579
January 02, 2007 11:32AM
2836
January 02, 2007 12:38PM
2557
July 19, 2007 06:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.