Is this a bug?

[Douglas Vogt]

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.