BIGINT(20) delete fails for 10 digit value

[Connie Lumpkin]

We are getting an 'Out of range value adjusted for column' error when we try to delete a table row based on a BIGINT(20) value with 10 digits. A value with 9 digits works ok. Here is what we get:

mysql> desc abc_xyz_tbl;
+------------------+------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------+------+-----+-------------------+-------+
| abc_id | bigint(20) | NO | PRI | | |
| xyz_id | int(11) | NO | PRI | | |
| is_main | tinyint(1) | YES | | NULL | |
| lastModifiedDate | timestamp | NO | MUL | CURRENT_TIMESTAMP | |
+------------------+------------+------+-----+-------------------+-------+
4 rows in set (0.02 sec

mysql> insert into abc_xyz_tbl (abc_id, xyz_id, lastModifiedDate) values (-6666666666, 11111, now());
Query OK, 1 rows affected (0.01 sec)

mysql> delete from abc_xyz_tbl where abc_id = -6666666666;
Out of range value adjusted for column 'abc_id' at row 1

We get same results with positive 10 digit number.

Anyone know what is causing this?