Bug #17006 ERROR 1264 (22003): Out of range value adjusted for column

• Submitted: 1 Feb 2006 14:50
• Modified: 1 Feb 2006 15:05
• Reporter: Andreas Otterstein
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.15-nt
• OS: Windows (Win2000)
• CPU Architecture: Any

[1 Feb 2006 14:50] Andreas Otterstein

Description:
Hi,

i have a Problem with MySQL Server

After creating a table and inserting elements MySQL gave me errors.

How to repeat:
i created a table:

mysql> create table t1 (mains_ID int(11) AUTO_INCREMENT,test1 varchar(100), PRIM
ARY KEY (mains_ID));

After interting a new element with:
insert into t1 VALUES ('','2121113');

MySQL gave my the error message:
ERROR 1264 (22003): Out of range value adjusted for column 'mains_ID' at row 1

either in phpmyadmin and console..

Without '' there is no problem..

[1 Feb 2006 15:05] MySQL Verification Team

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

See also the sql_mode are you running.

c:\mysql\bin>mysql -uroot db1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 35 to server version: 5.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table t1 (mains_ID int(11) AUTO_INCREMENT,test1 varchar(100),
    -> PRIMARY KEY (mains_ID));
Query OK, 0 rows affected (0.11 sec)

mysql> insert into t1 VALUES ('','2121113');
Query OK, 1 row affected, 1 warning (0.03 sec)